PowerDesigner configures Oracle Data Source Reverse Project Export PDM File

System: win7 64 bit; Oracle 10g; Powerdesigner 15

The problem, in the control panel =>Management Tools=>Data Source (ODBC) Add “User DNS” configuration driver to oracle can connect successfully, as shown below< /span>

In addition: you can see “Data Source (ODBC )” attribute to see where his target is. The current one is: %windir%\SysWOW64\odbcad32.exe

p>

but just enter Powerdesigner Cannot connect to the database, report the following error

[html] view plain copy print?

1. —– ———————-
2. Testing Connection
3. —————————
4. < span>Unable to connect
5. SQLState=08004
6. [Oracle][ODBC][ Ora]ORA-12154: TNS: Unable to resolve the specified connection identifier
8. — ————————-
9. OK < /li>
10. —————————

---------------------------Testing Connection--------- ------------------Unable to connectSQLState=08004[Oracle][ODBC][Ora]ORA-12154: TNS: Unable to resolve the specified connection identifier ----- ----------------------determine--------------------------- 

Solution: The reason for the installation path of Powerdesigner is found. There should be no special characters such as brackets: The installation path cannot be bracketed, that is, the default path [with (x86)] can not be used< /span>

previously : C:\Program Files (x86)\Sybase\PowerDesigner 15

Now: D:\Sybase\PowerDesigner15

you can connect successfully.

=================== ====Reverse import oracle table structure into pd=======================

Recommended connection: http://wenku .baidu.com/view/fdebcb050740be1e650e9af7.html?re=view

Or: http://wenku.baidu.com/link?url=CasTgdEPk3SI38L99IrqmZQ3g_pp4muOCfJE18A-bzJfCR9h0sfocZ-fuzJfCR9h0sfocZ-fuzJfCR9h0sfocZ-sVOT-sVOT-sVoQ3G-s p>

Method 1: Use ODBC to connect to the database

1. Open Powerdesigner
2. From the menu bar, select File -> Reverse Engineer -> Database in turn.
3. The New Physical Data Model window pops up
4. After using a data source is selected, click the Connect to a Data Souce icon, the Connect to a Data Source window will pop up, and then click Configure to pop up the Configure Data Connections window, click Add Data Source icon, create a new data source, (first select the system data source) to find the oracle item, the next step-complete.
5. After clicking Finish, the Oracle ODBC Drive Configuration window will pop up. In the Connect to a Data Source window, select ODBC machine data source, and then select the data source heloworld just configured from the drop-down menu. (You can also use Powerdesigner to configure the data source here. It is recommended to use the method mentioned in this article)
6. Fill in the user name and password
7. Click the Connect button, in the Database Reverse Engineering Options window, click OK.
8. After clicking OK, an import window will pop up, and you can select the data object you need in it.
9. Generated successfully

Method 2: Using SQL script form, you can generate PD table structure without connecting to the database

1. Open Powerdesigner
2. Select File -> Reverse Engineer -> Database from the menu bar.

3. The New Physical Data Model window pops up

Click OK

=================================

Pd table Structure to generate the database table, it is best to use the script generation method instead of directly generating into the database

[html] view plain copy print?

1. ——————— ——
2. Testing Connection
3. —– ———————-
4. Unable to connect
5. SQLState=08004
6. [Oracle][ODBC][Ora]ORA-12154: TNS: Unable to resolve the specified connection identifier
8. —————————
9. OK
10. ——————- ——–

[html] view plain copy print?