SQL Power Architect An innovative data modeling tool geared specifically for Data Warehouse and Data Mart design
Download

SQL Power Architect Ranking & Summary

SQL Power Architect Tags

Connect model modeling tool warehouse data warehouse

SQL Power Architect Description

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. Reviewed by Cristina Jitaru, last updated on January 12th, 2014

SQL Power Architect Related Software