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
|