RSS Feed for This PostCurrent Article

Power Architect: Data Modeling and Profiling Tool

Just after I wrote about Mogwai ER Designer NG, someone told me about Power Architect.


As quoted, 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. Plus, the Power*Architect has the ability to take snapshots of database structures, allowing users to design DW data models while working offline.

Features of Power Architect

  • 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
  • BSD licensed

Try out both and decide which one suits your needs..

Trackback URL

Sorry, comments for this entry are closed at this time.