안써봐서 모르겠으나 괜찮을거 같아 올려봄 GPL 라이센스라 함...

불법으로 Erwin 을 쓰는거 보다 나을거 같음..

( 모델링에는 DA# 이 훌륭하긴 한데.... 간단한 업무일때는 over-weight 라고 볼수있음... 
DA# 은 무료로 가능한지 무료로 어느정도 기능까지 쓸수있는지는 모르겠음 )


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-engineers to 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

http://www.sqlpower.ca/page/architect



posted by Jeeta
: