The powerdesigner I used is version 15.1 and the database is MySQL5.1.57.
(1) create a "PhysicalDataModel" file, and then click "Database"-> "Configure Connections". The "Configure Data Connections" window appears ", and select "Connection Profiles", as shown in: www.2cto.com (2) to create a mysql Connection, as shown in the following window:
Enter the connection information, as shown in. (note the following when entering the relevant information: <1> User name: And Password: the username and Password of the mysql database; <2> JDBC driver jar files: the location of your mysql-connector-java-5.1.13-bin.jar, click the icon to select .) Www.2cto.com. after entering the relevant information, click "Test Connection" in the lower left corner ..." To test whether the connection is successful.
If the connection is successful, the following window is displayed when you click "OK. If the connection is not successful, you need to configure the mysql-connector-java-5.1.13-bin.jar environment variables, the process is as follows: (5) after the connection is successful, click "Database"-> "Update Model from Database (shortcut: CTRL_R) ", the pop-up window" Database Reverse Engineering Options "is displayed, as shown in: Click to configure connections, as shown in: After completing the configuration, the following window is displayed: www.2cto.com select the database or some tables in the database for reverse engineering, and click "OK" to complete reverse engineering operations on the database. (Note: by default, all databases are selected. Therefore, before selecting a database that requires reverse engineering, click "cancel all" to make all databases unselected .)
So far, the connection environment of the reverse engineering of powerdesigner has been fully configured. You only need to select the database or table for reverse engineering and click "OK" to export the PhysicalDataModel diagram of the data.
Author woisnong