SQL Power Architect data modeling tool has many unique features geared specifically for the data warehouse architect. It is a powerful database utility that not only builds diagrams of databases, but also provides data dictionary language output, which can be used to build database solutions.
Desktop/Cloud: |
Desktop
|
ER Diagram: |
|
Export: |
HTML
|
Metadata stored in: |
Program metadata
|
Commercial: |
Commercial
|
Free edition: |
|
Notable features: |
Connects to multiple source databases concurrently, Compares data models & database structures and identifies discrepancies, Generates source-to-target visual Mapping Reports, Forward/reverse engineers PostgreSQL, Oracle, MS SQL Server & more
|
Runs on: (for desktop): |
Mac OS,Windows
|