EDI project, the use of relevant tools PowerDesigner, just one of our projects on the data design phase when the relevant documents are not well preserved, to find a Powderdesigner related documents, using reverse engineering, Generate the PDM data model from the MySQL database. Create a database description document with other tools
Tools/Materials
- powderdesigner15.0
- mysql5.1
- Pdmreader
- Mysql-connector-odbc-5.1.5-win32.msi
Method/Step
To configure an ODBC data source, install Mysql-connector-odbc-5.1.5-win32.msi
Open PowerDesigner. Select File--->reverse engineer--->database
In the popup dialog box new Physic data Model fill in your own modelname, select DBMS for MYSQL5 Click OK
In the popup database reverse engineer selection, select using a data source and click Connect to a data source to eject the connect to a Data Source dialog box.
Select data source for the ODBC machine data source and select the MySQL data source you just configured to enter the user password click Connect to return to the database reverse engineer options and click OK.
5.1 Click Modify to add an ODBC data source configured on Windows to test if PD can connect to database 5.2 If you do not need to re-configure and add a data source, click Config in the previous step to configure the data source
6. The Database Reverse engineer dialog box pops up at this point. Select the table you want to generate click OK
PowerDesigner reverse automatic generation MySQL documentation, PDM