Generating ERDs for Data Sources

Overview

Example of Entity-Relationship Diagram

BI Catalog Builder allows users to generate a script for drawing Entity-Relationship Diagrams (ERDs) for any data source.

Users simply download a DDL script for any data source and then import it into any tool that creates entity-relationship diagrams.

CMiC recommends Oracle’s SQL Developer Data Modeler, as it’s free to use and powerful enough to draw quite sophisticated diagrams. The data modeler can be downloaded from Oracle’s website:
https://www.oracle.com/database/technologies/appdev/datamodeler.html.