powerDesigner生成phy图

使用版本:v16.1

一、连接数据库

1. 新建pdm

File-》New Model
model types -> physical data model new project

model name: newmodel-phy
dbms: mysql5.0

2. config connect profile

DataBase -> Configure connections
Connection profile Connection profile

3. connect

Database -> connect connect dialog

Flag: “Disconnect” Available

  • dcp文件(mysql5-crm.dcp)
[ConnectionProfile]
ConnectionType=JDBC
Dbms=MySQL
DisableBind=0
Driver=com.mysql.jdbc.Driver
JarFiles=D:\war\mysql-connector-java-5.1.49.jar
LogId=root
TrimSpaces=0
URL=jdbc:mysql://106.14.141.40:3306/crm

二、生成phy图

1. Reverse Engineer

File -> Reverse Engineer->Database
Reverse Engineer 1 Reverse Engineer 2 选择数据库: Reverse Engineer 3 其他数据库全部反选:
例如:
Reverse Engineer 4 最后,点击ok生成phy图。

Tips:如果想从pdm生成CDM,Tools -> Generate Conceptual Data Model