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.