Active Query Viewer

Product Focus

Provide a means of viewing queries developed and saved using the MODEL based diagram method to create queries via Active Query.

Product Description

ActiveQueryViewer allows the user to view the following types of queries in an organized way:

  • Dynamic queries saved by ActiveQuery which allows a sophisticated end user to change the column selection criteria, ordering and query contingency.
  • Static queries saved by the ActiveQuery designer, which allows a less sophisticated end user to run a canned query based on predefined selection criteria.
  • End user HTML/Doc reports saved by a report by an ActiveQuery designer.

Product Architecture

The solution architecture is highly scalable. It can support hundreds of users and thousands of devices. It has multiple options to support active-active or active-passive architectures.

  • Database Compatibility:

    Oracle

    SQL Server

    DB2

  • Operating System Compatibility:

    Windows95/98/ME

    WindowsNT/2000 client connecting to ANY Database on the corporate network

  • Technical Requirements:

    Pentium 100MHz or higher

    10MB hard disk space

    64 MB RAM (128 MB recommended).

Benefits

  • Allows end users access to powerful customizable dynamic queries, without having to worry about technical details or SQL when forming the queries.
  • Allows less sophisticated users access to canned Static as well as end user WEB reports without any complexity.
  • Scheduled queries can be distributed for users specific to their organizational function and requirements.
  • Support for HTML reports for viewing using a standard WEB Browser.

Application Area

  • Any Database application, new or existing, custom or industry standard application, ActiveQueryViewer provides the end user a treasure chest of canned as well as customizable queries, out-of-the-box.
  • Secure access to data via scheduled query reports to specific WEB addresses. Thus, end users are not required to have live database connections for viewing queries.