Oracle SQL Developer Data Modeler

Oracle SQL Developer Data Modeler is a data modeling and database design tool that provides an environment for capturing, modeling, and managing database metadata. SQL Developer Data Modeler allows you to create, browse and edit, logical, relational, physical, multi-dimensional, and data type models. P6 users can download SQL Developer Data Modeler and use it to:

SQL Developer Data Modeler is a stand-alone product, available for download from the Oracle Technology Network (OTN) or as an extension to Oracle SQL Developer 3.0.

SQL Developer Data Modeler and the P6 Extended Schema

P6 report builders can use the SQL Developer Data Modeler to view the P6 Extended Schema's DMD. The DMD contains additional information on P6 Extended Schema views.

To open the P6 Extended Schema's DMD in SQL Developer Data Modeler, click Open on the File menu, and then browse to and select the P6 Extended Schema's DMD.

Locating a P6 Extended Schema View's Functional Description

For each P6 Extended Schema view, SQL Developer Data Modeler contains a description of its related P6 function. These descriptions may help you identify which tables to use in reports.

To access a view's functional description, right-click on a view and select Properties. The View Properties dialog box is displayed. In the View Properties dialog box, select Comments in RDBMS. The Comments in RDBMS field contains a description of the P6 function related to the selected P6 Extended Schema view.

Locating a P6 Extended Schema View's Source Tables

Use the Query Builder within the SQL Developer Data Modeler to display a view's underlying SQL query.

Right-click a view and select Properties to display the View Properties dialog box. In the General section of the View Properties dialog box, click Query to display the SQL Developer Data Modeler's Query Builder. The bottom field of the Query Builder contains the view's SQL query, including SELECT statements and a FROM clause. Scroll down in the bottom field until you see a FROM clause.

The FROM clause dictates the P6 database table from which the corresponding view is derived. For example, RESOURCES, in a FROM clause denotes that the P6RESOURCES Extended Schema view retrieves its data from the RESOURCES P6 database table.


Last Published Wednesday, December 13, 2023