The SQL Power Architect is an innovative Java-based data modeling tool geared primarily for Data Warehouse and Data Mart designers. It allows designers to open multiple concurrent source Database connections, data profile the various source data, compare any source and target schemas, drag and drop source schemas, tables and columns into the date modeling playpen and forward engineer the resultant target database and its associated ETL template.

Candidate Release 1.0 addresses several issues found in Release 0.9.1 while providing DW Designers with additional Data Modeling features, including:

• Support for indexes and unique constraints
• Support for MYSQL, allowing DW Designers to compare schemas and to generate DDL for MYSQL
• Bundling of SQL Server and PostgreSQL with this release
• Rework and simplifying of JDBC connection interface
• Provide ability to connect to multiple Oracle versions concurrently
• Provide ability to save playpen to PDF

The SQL Power Architect provides a complete view of all required source data and data structures and expedites every aspect of Data Warehouse design.

Design your Data Warehouse in a fraction of the time with the SQL Power Architect. SQL Power Architect is available free to individuals for personal use. Commercial licensing and support are available at competitive prices. Please call us at 1‑866‑SQL‑POWR to purchase.

You can download the SQL Power Architect for Free from the SQL Power website: www.sqlpower.ca/page/architect

Hope you enjoy using Candidate Release 1.0 of the SQL Power Architect - we look forward to your feedback!

The SQL Power Development Team