Excel exports
In KeepTool Hora, users can easily create individual database queries (via SQL, QueryBuilder, or interactive filter technologies). They can then group these using drag and drop; aggregate functions (sum, number, etc.) are available on the group level as well as for the total amount. These can then be exported to Excel with just one click – without losing any groupings or aggregate functions calculated with a formula in the process.
Excel imports
Excel files can be imported to an existing table in an Oracle database. Users can even automatically create a fitting table in the Oracle database into which the data is then imported.
KeepTool offers interfaces to additional file formats such as CSV, SQL, KML, XML, HTML, PDF, ... as well as an integrated reporting tool based on FastReport. Excel is the most important tool for short-term analyses in many companies. Users of KeepTool benefit considerably from its many convenient options.