PowerDesigner Connecting Oracle and exporting table structures

Environment: Oracle 11G (remote) + win32_11gr2_client + PowerDesigner 15

First, download, install, configure 1,

Win32_11gr2_client Client:

Https://pan.baidu.com/s/1c2N0GPa

Version of Oracle for Windows:

Http://pan.baidu.com/s/1kUQubC7

Linux version oracle11g:

Http://download.oracle.com/otn/linux/oracle11g/R2/linux.x64_11gR2_database_1of2.zip

Http://download.oracle.com/otn/linux/oracle11g/R2/linux.x64_11gR2_database_2of2.zip

Note: PowerDesigner is a win 32 program, the connection database will default to 32-bit system ODBC, so the 64-bit system oracle11g driver cannot be used

So you need to download the 32-bit system client Win32_11gr2_client.zip that installs oracle11g, and then connect the Oracle with the client's provider

2. Installation

Install PowerDesigner and Oracle clients locally, and follow the instructions when installing.

Note: Install win32_11gr2_client Select admin mode, the installation version of 1.1G

3. Configure client TNS

Copy the Product\11.2.0\dbhome_1\network\adminlistener.ora and Tnsnames.ora files from the Oracle installation directory to the respective client product\11.2.0\ Under the Client_1\network\admin.

4. Configure the data source

(1) Open ODBC 32 version C:\Windows\SysWOW64\odbcad32.exe, click Add, select Oracle in Oracleclient_home

(2) Configure the data source, enter the user name account, test the connection success

　　　　Note: The account added here is PowerDesigner connected object, if you need to add a connection object later, you can configure it here

(3) Open PowerDesigner, in the Database drop-down menu Select Click Connect, select the ODBC that was just right

II. exporting table Structure 1, creating a data model

Files--New model

2. Configure the data source

Using the C:\Windows\SysWOW64\odbcad32.exe tool, add, select an administrator-installed Oracle Client,

Add the data source connection name, instance name, user name, click OK

At this point, the data source is set up.

3. Using Data sources

(1) In the menu bar, select: Database-->configure connections Bring up the following window, where you can see the data sources that have been configured

(2) Select the menu bar: Database-->connect, select the configured data source, fill in the corresponding user and password, Connect

(3) Select menu: Database-->update Model from Databases,

By default, you can determine

Select the tables you want to export and configure additional parameters, OK, to start exporting, and export the results as follows:

Reference:

Http://www.cnblogs.com/wangyt223/p/4253241.html

http://blog.csdn.net/zhengxiangwen/article/details/46008657

PowerDesigner Connecting Oracle and exporting table structures