免费工具介绍:Power*Architect

Power*Architect

Data Modeling & Profiling Tool

The Power*Architect is a user-friendly data modeling tool created by data warehouse designers, and has many unique features geared specifically for the data warehouse architect. It allows users to reverse-engineer existing databases, perform data profiling on source databases, and auto-generate ETL metadata.

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
GPL (version 3) licensed

Data Architects, DBA’s, Analysts and Designers rely on Data Modeling tools to facilitate and simplify their data Modeling efforts, while maximizing the use of their resources. The Power*Architect allows these busy highly technical resources to perform this most intricate part of their job in a fraction of the time.

Plus, the Power*Architect has the ability to take snapshots of database structures, allowing users to design DW data models while working offline.

Whether you are building a Data Warehouse or using data models to communicate business rules, the Power*Architect will facilitate and automate your data modeling efforts.

设计数据库原来用DBDesigner4。Windows的易用性是没说的,下载了安装就可以了。不过在Ubuntu上着实费了点事。先是DBDesigner4用Kylix3开发,需要下载支持库。后来,后来发现我在用amd64版本,在32位程序兼容方面,库之间的调用关系和设置还是没有太了解。所以发动gooooogle,现在打算用这个了。Power*Architect,听着象PowerDesigner,不过照着PowerDesigner还是差了不是一星半点啊。

有兴趣用D版或者wine一下的同学可以试一下:在linux 下运行PowerDesigner 15 Beta 2

Ubuntu安装Power*Architect也很容易

下载Architect-generic-jdbc-x.x.x.tar.gz(x.x.x为版本号)

tar -zxvf Architect-generic-jdbc-x.x.x.tar.gz

cd architect-x.x.x

java -jar architect.jar

就可以使用了。

打赏

发表评论

电子邮件地址不会被公开。 必填项已用*标注