PowerDesigner16.5逆向工程导入

矫情吗；* 2023-10-04 11:48 89阅读 0赞

> 通过已有数据库或者sql,逆向导入PowerDesigner

##### 1.下载并安装PowerDesigner16.5(32位)，内有教程 #####

###### 下载地址及教程详见下载包 ######

###### [百度网盘][Link 1] ######

链接:https://pan.baidu.com/s/1eemv8GbUCpnRJ15PuZj6lg 密码:qzwu

###### [CSDN资源][CSDN] ######

链接:[https://download.csdn.net/download/baidu\_25986059/18142828][CSDN]

--------------------

##### 2.安装对应的mysql的ODBC驱动 #####

> 双击mysql-connector-odbc-8.0.24-winx64.msi进行无脑安装

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JhaWR1XzI1OTg2MDU5_size_16_color_FFFFFF_t_70]

> 本狗的MYSQL是8.0版，可**根据自身版本需要**到官网下载，[MYSQL官网地址][MYSQL]。  
> 本狗提供的是**64位**的**mysql-connector-odbc-8.0.24-winx64**

###### [百度网盘][Link 2] ######

链接: [https://pan.baidu.com/s/1jYHGpqHy-DfDs8fZfwiVyQ][Link 2] 密码:o7qv

###### [CSDN资源][CSDN 1] ######

链接: [https://download.csdn.net/download/baidu\_25986059/17832719][CSDN 1]

--------------------

##### 3.配置OBDC驱动连接(windows) #####

*  进入**控制面板\\所有控制面板项\\管理工具** 目录  
    ![控制面板\\所有控制面板项\\管理工具][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JhaWR1XzI1OTg2MDU5_size_16_color_FFFFFF_t_70 1]
 *  点击**ODBC 数据源(64 位)**  
    ![ODBC 数据源(64 位)][ODBC _64]
 *  添加**新数据源**，选择刚才安装的OBDC驱动，点击完成  
    ![添加新数据源][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JhaWR1XzI1OTg2MDU5_size_16_color_FFFFFF_t_70 2]
 *  填写**MySQL Connector/ODBC Data Source Configuration**  
    ![MySQL Connector/ODBC Data Source Configuration][MySQL Connector_ODBC Data Source Configuration]

> 关键点红线圈出，填完用户名密码可点击Test测试是否连通

*  **Data Source Name** :数据源名称(根据个人情况随意填写)
 *  **Description** :描述(随意填写)
 *  **TCP/IP Server**:服务器地址(我写的本地) Port:端口号
 *  **User**: 用户名
 *  **Password**: 密码
 *  **Database**: 具体数据库

##### 4.打开**PowerDesign16.5**，点击 **文件**，》**反向工程**，》**database** #####

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JhaWR1XzI1OTg2MDU5_size_16_color_FFFFFF_t_70 3]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JhaWR1XzI1OTg2MDU5_size_16_color_FFFFFF_t_70 4]

##### 5.**选择脚本文件**，因本人是**32位**，但jdk配置64位，不匹配，**无法建立数据库连接，只能使用脚本文件导入**，选择对应sql，点击确定即可 #####

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JhaWR1XzI1OTg2MDU5_size_16_color_FFFFFF_t_70 5]

##### 6.**查看成功导入的逆向工程** #####

![查看成功导入的逆向工程][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JhaWR1XzI1OTg2MDU5_size_16_color_FFFFFF_t_70 6]

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JhaWR1XzI1OTg2MDU5_size_16_color_FFFFFF_t_70 7]

[Link 1]: https://pan.baidu.com/s/1eemv8GbUCpnRJ15PuZj6lg
[CSDN]: https://download.csdn.net/download/baidu_25986059/18142828
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JhaWR1XzI1OTg2MDU5_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/202104251411408.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JhaWR1XzI1OTg2MDU5,size_16,color_FFFFFF,t_70
[MYSQL]: https://dev.mysql.com/downloads/connector/odbc/
[Link 2]: https://pan.baidu.com/s/1jYHGpqHy-DfDs8fZfwiVyQ
[CSDN 1]: https://download.csdn.net/download/baidu_25986059/17832719
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JhaWR1XzI1OTg2MDU5_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20210425142516188.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JhaWR1XzI1OTg2MDU5,size_16,color_FFFFFF,t_70
[ODBC _64]: https://img-blog.csdnimg.cn/20210425142619166.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JhaWR1XzI1OTg2MDU5,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JhaWR1XzI1OTg2MDU5_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/20210425160859615.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JhaWR1XzI1OTg2MDU5,size_16,color_FFFFFF,t_70
[MySQL Connector_ODBC Data Source Configuration]: https://img-blog.csdnimg.cn/20210426151822316.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JhaWR1XzI1OTg2MDU5,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JhaWR1XzI1OTg2MDU5_size_16_color_FFFFFF_t_70 3]: https://img-blog.csdnimg.cn/2021042615413651.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JhaWR1XzI1OTg2MDU5,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JhaWR1XzI1OTg2MDU5_size_16_color_FFFFFF_t_70 4]: https://img-blog.csdnimg.cn/20210426154303514.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JhaWR1XzI1OTg2MDU5,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JhaWR1XzI1OTg2MDU5_size_16_color_FFFFFF_t_70 5]: https://img-blog.csdnimg.cn/20210426154456523.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JhaWR1XzI1OTg2MDU5,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JhaWR1XzI1OTg2MDU5_size_16_color_FFFFFF_t_70 6]: https://img-blog.csdnimg.cn/20210426154645767.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JhaWR1XzI1OTg2MDU5,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JhaWR1XzI1OTg2MDU5_size_16_color_FFFFFF_t_70 7]: https://img-blog.csdnimg.cn/20210426155438556.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JhaWR1XzI1OTg2MDU5,size_16,color_FFFFFF,t_70