A tool for database design without reporting functionalities would be worth nothing! You need reporting for auditing, quality control, sharing information, …

In Data Modeler you can generate reports either from open designs or from a Reporting Repository.

Open Designs

If you want to create a report based on open designs there are three possibilities:

  • File | Reports
  • Search
  • File | Print Diagram

Depends on what you need which one is the best.

The reports can be generated into different formats:

  • PDF
  • HTML
  • RTF
  • XLS/XLSX
  • The format selections depends on the way of reporting and the templates used.

The Preferences you should look into:

RepPref1

RepPref2

Reporting Repository

A Reporting Repository can be any Oracle database. I recommend you create a new user in a database as the schema owner of the Reporting Repository. After you have created the user, edit the file datamodeler\datamodeler\reports\Reporting_Schema_Permissions.sql and run it in the repository to grant privileged needed. The first time you export a design to the reporting repository, the reporting schema structure is created automatically (log in as the schema owner). In datamodeler\datamodeler\reports\Reporting Schema diagrams, you can find the descriptions of the reporting repository structures.

To export to the Reporting Repository select File | Export | To Reporting Schema. You can also maintain the reporsitory (drop/enable/disable indexes, delete designs from repository) from File | Export | To Reporting Schema and add/remove glossaries to/from the Reporting Repository.

To run reports from the Reporting Repository select File | Reports or connect to the database and use SQL.

Advertisements