数据建模工具 SQL Power Architect

kider

SQL Power Architect 是一个数据建模工具，主要用在数据仓库和数据集市的模型设计。

It allows the designer to open multiple concurrent source database connections, create and explore profiles of the source data, discover differences between two schemas (even if they're on different database platforms), drag and drop source schemas, tables, and columns into the data modeling playpen, and forward engineer the resultant target database and its associated ETL template.

Features

---

• Accesses source databases via JDBC
• Connects to multiple source databases concurrently
• Compares data models & database structures and identifies discrepancies
• Drag-and-drop source tables & columns into the playpen
• Remembers the origin of each column
• Generates source-to-target visual Mapping Reports
• Forward/reverse engineers PostgreSQL, Oracle, MS SQL Server & more
• Saves source data structure snapshots in the project, so you can work remotely
• All project data is stored in an easy-to-parse XML format
• OLAP schema modeling: Cubes, Measures, Dimensions, Hierarchies & Levels
• Free Download (Open Source, GPL v.3 licensed) (Community Edition)
  

官网：http://www.sqlpower.ca/page/architect