|
|
Initialization Phase
 |
| In the initialization phase ZEROCONF offers all available and user-authenticated database connection pools for selection. From this point on, ZEROCONF does not need any configuration files. It explores the database on its own. |
 |
|
|
|
Table Exploration Phase
 |
| Having selected the database connection pool the user is presented all database tables in the schema. |
|
|
|
|
Column Selection Phase
 |
| After table selection ZEROCONF allows the user to choose from all columns of the selected table. The selected table, as well as the selected database connection pool, is highlighted. |
|
|
|
|
Report Execution Phase
 |
| Corresponding to the previous column selection, ZEROCONF generates a typical engine2 reports. If working with an Oracle database, ZEROCONF automatically recognizes the referential integrity and enhances reports with automatic links to the referencing tables. With MySQL, ZEROCONF needs an additional file for automatic linking. |
|
|
|
|
Drilldown Capabilities
 |
| If the user clicks on the automatic link in the report, ZEROCONF executes this report to deliver the report only in the scope of the requested information. ZEROCONF updates the columns and table informations as well so that the meta information goes along the content. |
|
|
|
|
Consistency
 |
| Even after drilldown ZEROCONF keeps the scope of the requested information while still providing all additional functionality: filtering, sorting, pagination, export to excel. There are also no restrictions on using the "back" button of the browser. |
|
|
|
|
Saving the Configuration
 |
| If the user wishes to save the current report he only needs to specify the name of the parent submenu file and push "save" button. All other informations are updated and integrated automatically. The report is saved as FOURFIVE engine2 report - together with automatic links. Thus, the generation of the FOURFIVE reports for a database scheme is as easy as "Click Ref -> Click Save -> Click Ref -> Click Save -> Click Ref -> Click Save" and so on. The exported reports can now be enhanced with charts informations, additional joins etc. |
 |
|
|
