PowerDesigner connection to the MySQL database

(1). Create a new MYSQL.DPC file on the desktop, which can contain nothing.

(2). Open the PowerDesigner and proceed as follows:

(3). Select the MYSQL.DCP file:

(4). Establish Connection properties:

(5). Test the connection:

Connection TYPE:JDBC
DBMS Type:mysql
User Name:root
password:123456
JDBC Driver Class:com.mysql.jdbc.Driver
JDBC Connection url:jdbc:mysql://localhost:3306/test_01
JDBC driver Jar File:d:\etl\data-integration\lib\mysql-connector-java-5.1.15-bin.jar

PowerDesigner connection to the MySQL database