Tutorial Data Modeling in SQL Power Architect – part. 1 Installation of software

For creating logical or phisical data models is used special software. One is SQL Power Architect, delivered also as Community edition, free to use.

It is very useful and easy to use the tool. It allows you design any database data model phisical or logical and convert it in SQL script or concrete database in any database system like Oracle, MySQL, PostgreSQL, SQL Server. This softwareallows also transform ready database to the logical or phisical model. You can also transform the database from one database engine to another.

In this part we start with installation.

First go to the website of this project

http://www.bestofbi.com

The website similar to this below appears:

SQL Power Architect

Click the COMMUNITYtab. You see the link Download. Click it.

SQL Power Architect

From the list of different edition, choose this free by clicking onFREE DOWNLOAD.

SQL Power Architect

Now you see the list of links for available OSs. Click the link Download. I choose Windows system.

SQL Power Architect

The window appears with the question if you want to save the installation file. Click Save file if you do.

SQL Power Architect

The file with format .jar will be download.

SQL Power Architect

This software required JVM. However the last edition is not enough. Now the 13 version is last, but SQL Power Architect requires 7 or 8 version of Java. therefor it is good to prepare this version Java before the installation of SQL Power Architect.

Now you can run The installator SQL power Architect. First you see Welcome window: 

SQL Power Architect

Click the Next.  In next step you see licence to accept, click theI accept ...

SQL Power Architect

Click on the button Next. The default path to the installation will be seen.

SQL Power Architect

Click theBrowse to change it. my is Desktop path with any folder I written. Of course, on my Desktop isn’t this folder, it will be creating.

SQL Power Architect

Click the Next. You see message window about creating new flder for installation files.

SQL Power Architect

Click the button OK. In next step you see progress of the installation:

SQL Power Architect

If you see Finished, click the button Next.

SQL Power Architect

And another Next.

SQL Power Architect

At the end click the button Done.

Now go to the folder contains installation software:

SQL Power Architect

Run file architect, and you will see Welcome window, you can close it:

SQL Power Architect

For users prefer video, watch it on YouTube:

 

Leave a Reply

Your email address will not be published.

Time limit is exhausted. Please reload CAPTCHA.