MariaDB社区

标题: 数据建模工具 SQL Power Architect [打印本页]

作者: kider 时间: 2013-4-17 15:37
标题: 数据建模工具 SQL Power Architect

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

欢迎光临 MariaDB社区 (http://123.56.88.72/)