About Site Map Submit Contact Us Log in | Create an account
Create an account Log In
Average Rating
User Rating:
Visitors Rating:
My rating:

Write review
  • Last update: 7 years ago
  • Total downloads: 308
  • Operating system: WinXP, Win2003, Win2000, Win Vista, Windows 7
  • Publisher: SQL Power (1 other programs)
See full specifications

windows default iconPower*Architect Publisher's description

The Power*Architect is an innovative Java-based data modeling tool geared specifically for Data Warehouse and Data Mart design.

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.

Power*Architect project is an innovative Java-based data modeling tool geared specifically for Data Warehouse and Data Mart design. It allows the designer to open multiple concurrent source Database connections, create and explore profiles of the source data, drag and drop source schemas, tables and columns into the data modeling playpen, and forward engineer the resultant target database and its associated ETL template.

Here are some key features of "Power Architect":

??? Access any JDBC or ODBC accessible source database
??? Quickly create profiles of source data, including information about the size of the data in each column, maximum and minimum values, frequency distribution of values in a column, and more.
??? Profile information is saved with the project, so profile data can still be used to aid off-site design sessions when it is not possible to access the source databases.
??? Design the target database Data Model (Data Warehouse)
??? Compare the database structure of any two databases highlighting the structural differences and generating the required DDL to synchronize
??? Compare the Data Model data structures to an existing target database
??? Save a snapshot of all source systems' data structures in the project file, allowing data warehouse designers to evolve their target data model remotely
??? Forward engineer to Oracle, SQL Server, DB2, and PostgreSQL and more.
??? Forward engineer ETL Templates containing source-to-target data mappings
??? Invoke ETL Engine to load initial set of data into the target database
??? Enable easy centralized installation and updates to many end users (Supports Java WebStart technology).
??? The Power*Architect can open multiple

System Requirements:

No special requirements.
Program Release Status:
Program Install Support: Install and Uninstall

Power*Architect Tags:

Click on a tag to find related softwares

Most Popular

windows default icon Bill Scale and Balance Wedge Keyboard 6.0B
Inputs scale and balance data directly into any Windows programs
windows default icon P7S Viewer 3.1
P7S Signer is a standards-based electronic signature solution Signing electronic documents with P7S Signer
windows default icon English to Hindi Character Converter 9.0
English to Hindi typing software. Its works as you speak Hindi language.
windows default icon EX4-TO-MQ4 decompiler 2011
EX4-TO-MQ4 decompiler (support MT4 225 build) - Decompile and protect MQL compiled files Currently I am
windows default icon TickNTick for Windows
TickNTick (Windows Based) Application is a powerful analytical tool with advanced charting features.