SQL Power Architect icon

SQL Power Architect

3.4/5 17
Certified 100% FREE GPL   

An innovative data modeling tool geared specifically for database administrators and analysts who need to design DW data models with ease. #Data Warehouse  #Data Mart  #Modeling Tool  #Warehouse  #Connect  #Model  

Softpedia Review

specifications

changelog

Free Download

Review by:
4.0/5

SQL Power Architect is a reliable and practical software solution worth having when you need to simplify your data modeling efforts, while maximizing the use of all the available resources.

Specially designed for data architects, database administrators, analysts and designers, the utility allows you connect to multiple databases and access them via JDBC. The right-click menu provides you with the possibility of adding new connections effortlessly.

The application sports a simple, intuitive and user-friendly interface since it comes with a tree-view panel that makes it easy to navigate through databases. The left section displays all the available connections and allows you to expand each table to view its fields.

Irrespective of which database type you choose to connect to, be it Oracle, SQL Server, PostgreSQL or MySQL, you are required to specify the host name and the port number to which your database will connect.

Whether you are building a new data warehouse or using data rules in order to communicate business rules, SQL Power Architect automates your modeling tasks with useful and intuitive features including OLAP schema.

What’s more, you are able to reverse-engineer code between two random databases using the Tools menu of the application.

An important function of SQL Power Architect is that it allows you to compare data models effortlessly. Simply choose two different projects or physical databases, change the output format, then compare them. It automatically displays all the differences and similarities between the selected databases.

The Data Profiling feature (which can be accessed from the Profile menu) is very useful for exploring unfamiliar databases. This way, you are able to view details about the size of the data in each column.

Another key feature that sets the application apart from other data modeling utilities is that it is capable of generating source-to-target data mappings.

To wrap it up, SQL Power Architect is a reliable and useful ERD drawing tool that provides you with a complete view of all required database structures using an intuitive environment.

User Comments
This enables Disqus, Inc. to process some of your data. Disqus privacy policy

SQL Power Architect 1.0.8

add to watchlist add to download basket send us an update REPORT
  runs on:
Windows All
  file size:
25 MB
  filename:
SQL-Power-Architect-Setup-Windows-jdbc-1.0.8.exe
  12 screenshots:
SQL Power Architect - With the help of the application you have the possibility to compare data models and database structuresSQL Power Architect - From the context menu you are able to add a new source connection, remove the connection and access the propertiesSQL Power Architect - You can navigate to the File menu if you want to start a new project, open an existing one and export to HTML formatSQL Power Architect - screenshot #4SQL Power Architect - screenshot #5SQL Power Architect - screenshot #6SQL Power Architect - screenshot #7SQL Power Architect - screenshot #8SQL Power Architect - screenshot #9SQL Power Architect - screenshot #10SQL Power Architect - screenshot #11SQL Power Architect - screenshot #12
  main category:
Internet
  developer:
  visit homepage