PowerDesigner connects Mysql, establishing a reverse engineering diagram – Mysql’s ODBC establishment

anywhere else Solved, there was a problem in the last step, and an exception was prompted:

In the legend, programmers like to use powerDesign for database modeling. Usually, the physical model diagram is designed first, and the SQL statements required by the database are converted to generate the database.
However, the legend of “powerDesign reverse engineering” is circulating in the arena. Well, today we will use PowerDesign to establish reverse engineering.

Database based on MySql 5.0 , PowerDesigner12. Mainly divided into these steps.

1> Through windows data Source management, establish ODBC data source.

First, install ODBC patch. Here is the patch file for mySql 3.5.1 and mySql5.1.5. Use them to install.

Open Windows Control panel to open the management tool

Open the data source ( ODBC)

Choose the type of database you want to operate

Enter the database parameters and test the connection

2> Use ODBC data source through powerDesigner to create a data source for PowerDesigner.

Create a new physical model.< /p>

Select Database (DataBase)—Connect.

​

Select the configured ODBC data source.

< p style="margin-top:0px; margin-bottom:10px; padding-top:0px; padding-bottom:0px; line-height:28px; color:rgb(98,106,15); font-family:'Hiragino Sans GB W3','Hiragino Sans GB',Arial,Helvetica,simsun,u5b8bu4f53; font-size:16px; background-color:rgb(244,240,232); text-indent:2em">
Enter the [user name] and [password] for logging in to the database.

​
2> Use PowerDesigner for reverse engineering.

Select Database— -Reverse Engineer Database. Use the configured data source.

< p style="margin-top:0px; margin-bottom:10px; padding-top:0px; padding-bottom:0px; line-height:28px; color:rgb(98,106,15); font-family:'Hiragino Sans GB W3','Hiragino Sans GB',Arial,Helvetica,simsun,u5b8bu4f53; font-size:16px; background-color:rgb(244,240,232); text-indent:2em">

Choose the content you are interested in.

Generate a physical model.

< p style="margin-top:0px; margin-bottom:10px; padding-top:0px; padding-bottom:0px; line-height:28px; color:rgb(98,106,15); font-family:'Hiragino Sans GB W3','Hiragino Sans GB',Arial,Helvetica,simsun,u5b8bu4f53; font-size:16px; background-color:rgb(244,240,232); text-indent:2em"> We waited a little bit, and I showed up what we need Data model. As shown below:

After zooming in

< p style="margin-top:0px; margin-bottom:10px; padding-top:0px; padding-bottom:0px; line-height:28px; color:rgb(98,106,15); font-family:'Hiragino Sans GB W3','Hiragino Sans GB',Arial,Helvetica,simsun,u5b8bu4f53; font-size:16px; background-color:rgb(244,240,232); text-indent:2em">

here, our Reverse engineering is complete.

< p style="margin-top:0px; margin-bottom:10px; padding-top:0px; padding-bottom:0px; line-height:28px; color:rgb(98,106,15); font-family:'Hiragino Sans GB W3','Hiragino Sans GB',Arial,Helvetica,simsun,u5b8bu4f53; font-size:16px; background-color:rgb(244,240,232); text-indent:2em">

I also collected some powerdesign related blog posts:

The second reverse connection of Power Designer encountered sqlstate=37000http://hi.baidu.com/laurel_2010/blog/item/c1ba715314327013367abeb8.html< /p>

In PowerDesigner, modify the column name and Code synchronization problem

http://blog.sina.com.cn/s/blog_4a096c410100azp9.html

< /p>