Power*Architect from SQL Power Group is a visual data modeling tool designed for data architects, DBAs, analysts, designers, and other professionals. Quickly design every aspect of your data model using diagrams and a hierarchical view of your model structure. Your data model remains platform-independent, allowing you to maintain a single database schema that works well with multiple database platforms.

Power*Architect is also well-suited to data warehouse and data mart design. You can open multiple source databases concurrently, then drag and drop objects (such as schemas, tables, and columns) into Power*Architect's data modeling playpen to create a new model. After fine-tuning the data model in the playpen, you can forward engineer the data model into new database on platforms such as Oracle, SQL Server, DB2, PostgreSQL, or MySQL. Power*Architect also creates ETL (Extract, Transform, Load) procedures you can use with Pentaho's popular open source Kettle ETL tool to populate the new database.

Power*Architect provides you with a variety of tools to view and compare data structures and mappings. For example, you can compare the structure of any two databases, highlighting the differences and similarities and generating the required DDL statements to synchronize them. You can also create a visual mapping report listing the source tables used in your data model, or create an easy-to-read profile summarizing the data contained in a database.

Whether you're building or maintaining a data model, Power*Architect provides the tools to help you design your model in a fraction of the time.