Advanced database application users will find KeepTool as the perfect companion for data mining and reporting beyond the capabilities of your database application. Apply query by example technologies, perform graphical data grouping, lookup foreign key values, create your own SQL queries using our query builder. Export data to MS-Excel, create your own reports and export to PDF/A format.
Use the Data Browser to view and optionally modify the data contents of a table or view. You can use SQL expressions to filter data, as well as Query by Example (QBA) technologies for more convenient filtering. You can visually group data by key values and calculate group totals.
There is a master/detail view that automatically displays the contents of each detail table. In addition, you can move the context from the currently viewed table to any master or detail table and filter it using the connect from the previously viewed master or detail table.
Use the “..” button to look up context values from a master table. Right-click context menu items to create INSERT/UPDATE/MERGE scripts for the currently displayed data. Hide columns from view to exclude them from scripting.
The SQL repository is your own treasure trove of SQL statements. It is stored in the file system and displayed in Hora as a tree view, where each node represents both a folder and a SQL file. You can add multiple roots from network folders to share SQL statements with your colleagues. You can use both SQL parameters (:1) and lexical parameters (&1). KeepTool prompts you for values before executing.
The result is displayed in a data grid that supports further filtering/grouping similar to the Data Content Browser.
Start with any table and then add related master or detail tables. Hora automatically detects joins from foreign key relationships between tables and displays the query similar to an entity relationship model. You can visually select columns from checkboxes. WHERE conditions, group by expressions and sums can be further specified. Depending on your needs, you can use either Oracle’s proprietary joins or ANSI SQL-compliant joins.
Hora includes a fully functional FastReport Designer. To get started, Hora generates a default layout based on either your currently edited SQL statement or the currently displayed data content. Now you can use the designer to make changes to the layout or add functional logic such as conditional color highlighting. Any report output can be saved as a PDF/A compliant document.
For data analysis in MS Excel, you can export the contents of any data grid using the Ctrl+Shift+E shortcut. All formatting, such as column visibility and data grouping, is retained in Excel. Calculation of group and grand totals is translated to MS Excel formulas.
The data content grid comes with additional data import and export options such as CSV, XML, SQL script, KML (spatial data) and much more.
To use Oracle expdp and impdp utilities, you can create a command template from the context menu of the DBA|User Data Grid.
