使用版本:v16.1
一、连接数据库
1. 新建pdm
File-》New Model
model types -> physical data model
model name: newmodel-phy
dbms: mysql5.0
2. config connect profile
DataBase -> Configure connections
Connection profile
3. connect
Database -> connect
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
选择数据库:
其他数据库全部反选:
例如:
最后,点击ok生成phy图。
Tips:如果想从pdm生成CDM,Tools -> Generate Conceptual Data Model