Powerdsigner 16 Reverse engineering import MySQL

Due to the frequent use of powerdesigner in daily data modeling, the use of reverse engineering to generate models more quickly improves efficiency, so the summary is used as follows:

1. Installing the ODBC driver for MySQL

CONNECTOR/ODBC 5.1.13:

Https://dev.mysql.com/downloads/connector/odbc/5.1.html

My machine is win7_x64 system. But one of the questions that comes up later:

The 64-bit MySQL connection pack was installed, and ODBC established the connection, but when the PD was connected, the error was:

PowerDesigner connecting MySQL in the specified DSN, the architecture between the driver and the application does not match SQLSTATE = IM014

Workaround:

I installed both 64-bit and 32-bit at the same time. My machine is 64 bit, must install 64 bits, otherwise ODBC connection will not appear MySQL ODBC.

Install the 32-bit again to solve this problem.

2. Configuring the OBDC Drive connection

Select Control Panel, all Control Panel items, management tools

3. Open PowerDesigner:

1) file--New model

2) database->connect to a Data Source

Fill in the information to connect to the database

4) Start Reverse generation

OK, wait for the build to be ready.

Powerdsigner 16 Reverse engineering import MySQL