Powerdesign and MySQL Connection

The data preprocessing phase is temporarily over, now look at how to design the association between tables. Therefore, we need some special tools to design and deal with the relationship between tables, here we use tool PowerDesigner. Since I use the database is MySQL, the other database is similar, the following is a detailed description of how to import the MySQL database structure into the powerdesigner.

The first step, need to install MySQL CONNECTOR/ODBC, because like PowerDesigner connection MySQL, need intermediate link, MySQL connector/odbc equivalent to middleman, can not only like MySQL communication, You can also communicate with PowerDesigner. : http://dev.mysql.com/downloads/connector/odbc/5.1.html, recommended to download 32-bit, 64-bit will be an error.

In the second step, you need to add the User DSN to the ODBC data source, here are the detailed steps:

Double-click Open, then click "Add", then a list of drivers for installing the data source appears, select MySQL ODBC 5.1 Driver, and add as follows:

Here to special emphasis on the "TCP/IP Server" Choice, the general we will add IP, if clicked "Test", will appear the connection success information, but in the back PowerDesigner connection MySQL process will error, reported "unknown MySQL server host "does not have the ability to parse out the IP, but using localhost does not exist with this problem.

The third step is to import the MySQL database into the PowerDesigner as follows:
In PowerDesigner, use the menu file= "Reverse engineer=" Database,dbms Select MySQL5.0, click OK

In the selection of the Database Reverse Engineering Options window that pops up, select using a data source, click the Small database icon on the right, and in the pop-up window, select ODBC file data source. Select the user DSN that we have created before and connect.

Then we will have the infrastructure of the data table we want in the PowerDesigner blank panel, instead of having to create it manually. Thus it is convenient for us to create an association between tables.

Powerdesign and MySQL Connection