Data Modeler Reports

You can export the information about a Data Modeler design to a database schema (called the reporting repository), and you can then use the reports feature in SQL Developer to view reports about that Data Modeler design.

The reporting repository is a collection of schema objects for storing metadata and data about Data Modeler designs. It is recommended that you create a separate database user for the Data Modeler reporting repository, and use that schema only for the reporting repository. For example, create a user named DM_REPORT_REPOS, and grant that user at least CONNECT and RESOURCE privileges. (You can create the reporting repository in an existing schema that is also used for other purposes, but you might find that more confusing to keep track of.)

To export the information about a design to the reporting repository, click File, then Export, then To Reporting Schema.

To view the reports in SQL Developer, you must do the following:

  1. In SQL Developer, check to see if the Reports navigator already includes a child node named Data Modeler Reports. If it does include that node, go to the next step; if it does not include that node, install the Data Modeler Reports extension, as follows:

    Click Help, then Check for Updates. In the Check for Updates wizard, specify Install From Local File, and specify the following local file in the location where you installed Data Modeler: datamodeler\reports\oracle.sqldeveloper.datamodeler_reports.nn.nn.zip (Windows systems) or datamodeler/reports/oracle.sqldeveloper.datamodeler_reports.nn.nn.zip (Linux systems), where nn.nn reflects a build number.

  2. In SQL Developer, open the Reports navigator, expand the Data Modeler Reports node, plus nodes under it as desired.

For each report that you want to view:

  1. Double-click the node for the report name.

  2. Select the database connection that you used for the reports repository.

  3. Complete the Bind Variables dialog information, and click OK. For the bind variables, the default values represent the most typical case: display all available information for the most recent version of the design.

    The bind variables enable you to restrict the output. The default value for most bind variables is null, which implies no further restrictions. To specify a bind variable, select the variable name and type an entry in the Value field. Any bind variable values that you enter are case insensitive. Bind variable values can contain the special characters % (percent sign) to mean any string and _ (underscore) to mean any character.

Data Modeler reports are grouped in the following categories:

Design Content reports list information about the design content (objects in the design).

Design Rules reports list information about the design rules as they apply to the logical and relational models.

Design Content reports

Design Content reports list information about the design content (objects in the design).

Data Types Model: Contains reports related to the Data Types Model.

Logical Model: Contains reports related to the Logical Model.

Relational Model: Contains reports related to the Relational Models.

Related Topics

Data Modeler Reports

Design Rules reports

Design Rules reports list information about the design rules as they apply to the logical and relational models. (See the information about the Design Rules dialog box.)

Logical Model: Contains reports related to the Logical Model.

Relational Model: Contains reports related to the Relational Models.

Related Topics

Data Modeler Reports