Steps and solutions for importing MYSQL database structure in PowerDesigner

Steps and solutions for importing MYSQL database structure in PowerDesigner

We are using PowerDesigner today and want to import the MySql table structure to PowerDesginer,

Follow these steps:

1, first of all to ensure that the machine installed MySql ODBC driver, go to the http://dev.mysql.com/downloads/connector/odbc/5.1.html

Download Connector/ODBC 5.1.13 Windows (x86, 32-bit), MSI Installer installation program, and install it successfully;

2. Add a file DSN to the data source (ODBC) of the system management tool, select MySQL ODBC 5.1 Driver, enter the ip port and other information, and save it as a file;

3. Prepare for import. In PowerDesigner, use the menu File = "Reverse Engineer =" Database ", choose" MySQL5.0 "for DBMS, and click" OK;

4. In the Selection window of the pop-up Database Reverse Engineering Options window, select Using a data source and click the small Database icon on the right,

In the pop-up window, select ODBC file data source, find the DSN file Created in step 1, enter the User ID and Password below, and click Connect

5. Click OK to bring up the database table selection window. Select the database to be imported and the corresponding table, and click OK to start importing data from MySql.

An error occurred during the import process. I started to download and install the 64-bit ODBC driver in step 1. The result is always in step 3, with an error reported.

SQLSTATE=IM002[Microsoft] [ODBC driver manager does not find the data source name and does not specify the Default Driver

I couldn't find the error after searching on the internet, and I couldn't restart my computer. Later I found that PowerDesigner was 32-bit, And I downloaded the 32-bit ODBC driver again.

I have successfully converted the table structure of the database through powerdesigner, but the data has not been imported into the database. Any good method can be used from oracle

If there is not much data, you can use PL/SQL to export the insert SQL statement from oracle, then make a preliminary modification, and then execute it in mysql.
If the data volume is large, you can use datastage to check whether it works. I have never used this tool. If you look at it online, it will be almost feasible. Hope to help you!

The problem of reverse engineering when powerDesigner connects to the mysql database

I have used MySQL and PD, but have not handled problems like you. It may be useful to you to talk about my opinion.
1. All products are from Sybase. We recommend that you install a PowerBuilder with a version later than 9.0. If you can directly access the MySQL database, it indicates that your machine environment is correct, in addition, there is no problem with the product interface. If there is any problem, it is estimated that you have to reinstall the database or client connection tool;
2. interface problems. If you can directly connect to the MySQL client, try not to use ODBC, and Microsoft will be reliable;
3. If you use ODBC connection, you can try to create a table by using ACCESS to import data through ODBC, first confirm the connection validity, and then try the connection of ODBC interface (unreliable or not ).
I do not know whether the train of thought is correct. I hope it will help you.