It encapsulates the most important features of our flagship tool Hora.
The Data Content Browser allows you to interactively query data either using query by example technologies or by defining SQL conditions. Result sets can be exported to MS Excel or you can create your own reports. You can also create INSERT scripts to transfer data to another system
The SQL Scratchpad is a hierarchical repository for your ad hoc queries. You can use the Query Builder to interactively create select statements. Result sets can be displayed in a grid view or exported to MS Excel.
KeepTool Free is our ideal offer for users who use our tools occasionally. For example, you can use our free Hora Free tool for data analysis on your customer’s system without purchasing a license for that machine.
You can include multiple SQL root directories in the tree view and share each with members of your project team.
Use the query builder to help you build queries based on either traditional Oracle or ANSI join syntax.
Each tree node is associated with an SQL file, which is displayed in the right pane of the editor. SQL statements can be executed either in batch mode or iteratively, while the SQL result set is displayed in a dockable output window.
The Data Content Browser makes it easy to browse, filter, and update table and view data. Double-click a table or view on the left to open a tab in the Data Content pane and display table data in a grid view. You can switch to a record view, tree view, pivot view, or chart view to choose a different type of data display. For foreign key column values, tooltips show you the referenced master record. For editing, you can use the ellipsis button in the data cell to open a popup that allows you to grab a reference from the master table.
The filter box above the grid allows you to enter SQL-where conditions and filter the data content. Alternatively, you can use QBE (query by example) technologies and enter filter values in the filter cells below each grid column header. To explore master/detail dependencies, you can use the context menu to open a filtered master or detail data view on another tab.
