Enterprise Query & Reporting Software(OZ EQ)

OZ EQ is a specialized new data extraction solution that has specialized the existing Query tools and the data extraction functions and query creation of OLAP tools. OZ EQ helps non-professionals, who are not used to the SQL, to connect on the database to inquire and process the needed data through Drag & Drop. OZ EQ is supporting various and convenient functions in Japan. The good quality and the low cost of the product is bring great reactions in the Japanese market.

Features

1. A tool for people who are not used to SQL

A powerful EUC embodiment that enables amateurs, who are not used to SQL to extract data and frame queries easily using the Wizard.

2. Quick and flexible data extraction function

OZ EQ supports various data extractions and process functions such as; total company data use through the linkage of Oracle, MS-SQL, Sybase, DB2 and other databases. Multilevel data extraction, data extraction from external multi CSV files, application of embellishment fields, editing data results into excel files and etc.

3. Provides database connection management function

Registration and management for a number of DB sites, enables to connect by importing the connection information file given out by the manager. Therefore, users can connect to the database just by clicking on the mouse without any connection information input. Users can connect to various different databases without installing other clients.

4. Data Input/Revision/Elimination

Able to input or revision the result tables inquired from Excel or EQ by Copy & Paste.

5. File data links

Inquire functions are possible for text file data through the link function of DB tables.

6. Multi-level data inquiry

Able to inquire new data in terms of different Query set data. (Master/Detail Query)

Architecture

OZ EQ enables data abstraction by simple drag & drop after connecting various data bases with JDBC/ODBC. The data can be processed and used by conversing into Excel or CSV files.