Application Support Teams:
Go Beyond Standard Reporting

For application support teams, KeepTool is the ideal partner when it comes to data analysis and reporting — going far beyond the capabilities of the application itself.

Take advantage of powerful features such as:

  • Query-by-Example for quick and intuitive queries

  • Graphical data grouping for a clear presentation of results

  • Foreign key lookups directly from the master table

  • The Query Builder to easily create your own database queries

In addition, you can conveniently export results to MS Excel, create custom reports, and store them securely in PDF/A format.

Free Download
KeepTool Hora icon

Data Browsing for Application Support Teams

Application support teams often need to quickly access, review, and occasionally adjust live data to diagnose and resolve issues. The Data Browser provides an intuitive interface to explore and manage table or view contents efficiently.

Key Capabilities

  • Flexible Data Exploration: View and optionally modify data from any table or view. Apply SQL expressions or use Query by Example (QBE) for convenient filtering.

  • Smart Data Grouping: Visually group records by key values and calculate group totals for quick insights.

  • Master/Detail Navigation: Automatically display related detail tables alongside the master table. Easily shift focus to any linked master or detail table while maintaining context and filters.

  • Context-Aware Lookups: Use the “..” button to retrieve context values directly from a master table.

Productivity Enhancements

  • One-Click Scripting: Right-click to generate INSERT, UPDATE, or MERGE scripts for the currently displayed dataset.

  • Custom Views: Hide unneeded columns to simplify the display and exclude them from scripting.

With these features, support teams can analyze issues faster, create targeted scripts on the fly, and maintain control over application data without unnecessary complexity.

Oracle Data Content Browser
KeepTool Hora icon

SQL Scratchpad for Application Support Teams

For application support teams, quick access to reusable SQL statements is essential when analyzing issues or troubleshooting applications. The SQL Scratchpad serves as a personal and shared repository for all your SQL snippets, making it easy to organize, reuse, and execute them directly within Hora.

Key Capabilities

  • Organized SQL Library: SQL statements are stored in the file system and displayed in Hora as a tree view, where each node represents both a folder and a SQL file.

  • Collaboration Ready: Add multiple root folders from network drives to share SQL statements seamlessly with colleagues.

  • Parameter Support: Use SQL parameters (:1) or lexical parameters (&1). KeepTool automatically prompts for values before execution, ensuring accuracy and flexibility.

  • Powerful Result Handling: Query results appear in a familiar data grid that supports advanced filtering, grouping, and navigation — similar to the Data Content Browser.

Benefits for Support Teams

With the SQL Scratchpad, support teams can:

  • Quickly access frequently used queries.

  • Share tested SQL scripts across the team.

  • Standardize troubleshooting and analysis workflows.

  • Gain deeper insights into data with powerful filtering and grouping.

By combining organization, collaboration, and flexibility, the SQL Scratchpad empowers support teams to resolve issues faster and more efficiently.

Oracle SQL Scratchpad
KeepTool Hora icon

SQL Query Builder for Application Support Teams

Application support teams often need to analyze data quickly without writing complex SQL from scratch. The SQL Query Builder makes this process intuitive by allowing you to construct queries visually and accurately.

Key Capabilities

  • Visual Query Design: Start with any table, then add related master or detail tables.

  • Automatic Join Detection: Hora identifies foreign key relationships and builds the necessary joins, displaying the query in a format similar to an entity relationship diagram.

  • Column Selection Made Easy: Select columns using simple checkboxes instead of typing SQL code.

  • Flexible Query Options: Add WHERE conditions, grouping, and aggregate functions such as sums to refine your results.

  • Standards Support: Choose between Oracle’s proprietary join syntax or ANSI SQL-compliant joins, depending on project requirements.

Benefits for Support Teams

With the SQL Query Builder, application support teams can:

  • Build accurate queries faster without deep SQL expertise.

  • Reduce errors by relying on automatically detected relationships.

  • Standardize data analysis with clear, visual query construction.

  • Save time when troubleshooting issues or validating application data.

By combining ease of use, accuracy, and flexibility, the SQL Query Builder helps support teams turn complex data questions into actionable insights.

Oracle SQL query generator
KeepTool Hora icon

Reporting for Application Support Teams

Application support teams often need to turn raw query results into clear, actionable reports. With Hora’s integrated FastReport Designer, creating professional reports is fast and straightforward.

Key Capabilities

  • Instant Report Generation: Hora automatically creates a default layout based on either the SQL statement you are editing or the currently displayed data.

  • Flexible Report Design: Customize layouts, add functional logic, and apply features such as conditional color highlighting to make reports more insightful.

  • Standards-Compliant Output: Export reports as PDF/A-compliant documents, ensuring long-term readability and compatibility.

Benefits for Support Teams

With reporting in Hora, support teams can:

  • Quickly transform query results into shareable documents.

  • Highlight critical information with conditional formatting.

  • Standardize reporting workflows without relying on external tools.

  • Provide stakeholders with clear, professional, and compliant reports.

By combining automation, customization, and compliance, Hora makes reporting a powerful tool for both day-to-day troubleshooting and long-term documentation.

Creating Oracle reports using Fastreport
KeepTool Hora icon

Data Import and Export for Application Support Teams

Application support teams often need to move data between systems or export it for further analysis. Hora simplifies these tasks with a powerful set of import and export features designed for flexibility and accuracy.

Key Capabilities

  • Seamless Excel Export: Export the contents of any data grid to MS Excel with Ctrl+Shift+E. All formatting, including column visibility, grouping, and totals, is preserved. Group and grand totals are automatically converted into Excel formulas for continued analysis.

  • Multiple Export Formats: Beyond Excel, export data as CSV, XML, SQL scripts, KML (for spatial data), and more.

  • Flexible Data Import: Import data from external sources directly into the data content grid with just a few clicks.

  • Integration with Oracle Utilities: Generate ready-to-use command templates for Oracle expdp and impdp directly from the DBA | User Data Grid context menu.

Benefits for Support Teams

With Hora’s import and export tools, support teams can:

  • Quickly transfer and share data across formats.

  • Analyze data in Excel without losing grouping or totals.

  • Automate database export/import operations using Oracle utilities.

  • Streamline workflows by reducing manual reformatting or script writing.

By combining ease of use, flexibility, and Oracle integration, Hora’s import and export features empower support teams to manage data efficiently and reliably.

Oracle to MS Excel export

See More Real-World Use Cases

Application Development
Database Administration