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.