BI Catalog Builder - Building an ERD using Oracle Data Modeler

Step 1: Download ERD script for your data source.

• Select your data source.

• Press [Download ERD script] button. A pop-up with the suggested file name will appear.

  

  Pop-up window launched from [Download ERD script] button

• Select the ‘Include Column Comments’ checkbox if you wish to generate column comments. When selected, Field Description property will be used as a source for the generated column comments.

• Press [Download] button.

• Once the file is generated, the browser’s Save dialog will appear. Save the file to the desired location.

  

  Example of browser’s pop-up window used for saving DDL script

Step 2: Use Data Modeler to draw ERD.

• Open Data Modeler, then go to “File”=>“Import”=>“DDL File”.

  

  Importing a DDL file in Oracle SQL Developer Data Modeler

• Select the generated DDL script. Make sure Import to: option is set to “New Relational Model” and click [OK].

  

• Select “Oracle Database 11g” and click [OK].

  

• Review the import log and click [Close].

  

• Click [Merge] in the Compare Models dialog window. If you wish, you can explore this dialog and select only those items that you would like to import. CMiC recommends that you use defaults and import everything.

  

• Once the merge process is completed, use Fit Screen or Zoom toolbar buttons to make the diagram visible. If your data source includes a lot of folders, a diagram created by default may be too big, as shown in the screenshot below.

  

• To create a new diagram with a smaller number of folders, right-click on the default diagram and select menu item “Diagram”=>“Create SubView”.

  

• Then right-click on the new diagram and select “Object”=>“Add/Remove Objects”.

  

• In the Add/Remove Objects pop-up, select only those objects that you would like to include into your diagram. In example below, we include all JC objects. When finished, click [Apply] and [Close].

  

• If new objects are not visible in the diagram, click Fit Screen toolbar button.

  

• You can also automatically arrange the objects using the Auto Layout function, as shown in the screenshot below.

  

  Auto Layout function in Oracle SQL Developer Data Modeler

• You can also select what information will be visible in the diagram. In the screenshot below, we included “Comments”.

  

  Example of selecting details, such as Comments, to be visible in the diagram

• You can export the diagrams to a PDF or Image file by selecting “File” => “Print Diagram” => “DDL File”.

  

  Exporting a diagram to PDF