How to use the MySQL export database structure for the World tool and how to use PowerDesigner to map the database model one, through PowerDesigner configuration Ojdbc
1, install and open PowerDesigner, create a new model document, such as
2. Select "Database", "Update model from database"
3. After the pop-up window, select "Using a Data Cource", click on the right icon
4. Select "Configure ..."
5. Select icon
6. Select " user data source (for current machine only)" à " next "
7. Select "MySQL ODBC 5.3 Unicode Driver" à "next"
Note: It can also be another version, if you do not install OJDBC to the official website to download the installation can also use other tools to configure the OJDBC drive connection
8, click "Finish" will be configured OJDBC pop-up window
9, configure the OJDBC connection information, then click OK to complete the configuration
Ii. using the "Dbexportdoc V1.0 for MySQL" map to generate the database world document
1. Office Enable macros
Example: Offic 2010:----------------trust Center----trust Center--Enable all macros "tick Trust access to the VBA project object Model"
2, select "Trust Center" à "Trust Center Settings"
3. Select "Macro Settings" à "Enable all macros (not recommended: Potentially dangerous code may run) (E)"
and tick "Trust access to the VBA project object Model"
4. Click "OK" to complete the setup, then you can use "Dbexportdoc V1.0 for MySQL" to generate the database world document
Iii. Creating a World document
1, double-click "Dbexportdoc V1.0 for MySQL" will pop up the window, connect the database
2. Select "New Connection ..."
3, select the red section below the OJDBC drive
4. Select "Use data source name" as configured in PowerDesigner, then "Test Connection" after entering user name password
5, "OK" after the connection and select the table to be generated, such as, click "Export",
The default is to open the world using the shortcut key to save the selected location.
Export database table for World document description, already powerdesigner export table structure PDM design document