1, MySQL database connection (JDBC mode) The configuration of JDBC requires some basic environment and preparation, but also very simple, that is, the JDK and MySQL connection jar package, no longer elaborated here. 1.1 Create a new Pdm,dbms select MySQL
1.2 Database-connect Select a database connection
1.3 Configuring connection Information database connection here is a configuration file to get the connection information, the first word because there is no, so we need to choose Configure to configure. 1.4 Fill in the configuration information, select Add Database resources, appear as above, the relevant instructions are as follows:
- Connection profile NAME:JDBC configuration file name, can be filled in freely
- Directory: Configuration File Save path
- Description: Configuration file description, can be filled according to the actual use
- Connection Type: Connection mode, here we choose JDBC
- DBMS Type: Database types, which provide most of the major database choices, we choose MySQL
- User name: Username of login Database
- JDBC Driver Class: Specifies the driver class, using the default Com.mysql.jdbc.Driver
- JDBC connection url: Connection URL, format jdbc:mysql://serverip/hostname:port/database
- JDBC driver jar files: specifying the path to a connected jar package
1.5 connection test and configuration save fill in the information after completion, click on the bottom left of the test Connection, the successful prompt indicates that the connection is feasible: if the test connection does not pass, and the Non SQL error:could not load class Com.mysql.jd Bc. Drive error, and the specified jar package is not problematic, it is because PowerDesigner cannot find the driver generated. The workaround is to configure the system's Classpath path, specifying the path to the jar package. After successful connection, we go all the way to save this configuration file, you can end up in the folder you specify (there is no limit, the directory can be customized, here I was built in a userconf folder under the installation file) to see this saved file: 2, Reverse engineer a table from an existing Database 2.1 menu selection, update model 2.2 from database Select Database connection profile 2.3 Select the database involved and the table you want to export 2.4 done 3, reference link:
- PowerDesigner connecting MySQL Database
- powerdesigner16.5 reverse engineering, export PDM from remote ORACLE11G database
- Non SQL error:could not load class com.mysql.jdbc.Drive when connecting to database using PowerDesigner
PowerDesigner connecting MySQL and reverse engineering diagrams
