Reverse engineering--oracle to Powerdesigner____oracle

This time the practice of the implementation of the reverse engineering in PD, write a screenshot of the document, upload screenshots inconvenient, do not pass.

Here's how to export a specified database structure from Oracle to PowerDesigner (PD) To do the truth:

Prerequisites:

1. Existing Oracle database sun880, which contains a number of data tables, a sun880 username sgsj, and a password of SGSJ.

2. The PD version is 11.

Formal steps:

1. From the menu bar, select File-> Reverse Engineer-> Database, pop-up new physical Data model window.

2. Click OK, pop-up database Reverse Engineering window.

3. Click the Connect to ODBC icon to pop up the Connect to an ODBC Data source window, click the Add key, select the System DSN tab in the ODBC Source Manager window that pops up, click Add button, and choose Oracle in OraHome92 Options

4. After clicking the completion button, the Oracle ODBC Drive Configuration window will pop up and fill in the following criteria:

Data Source name--sun880 (can be any name)

description--Blank

TNS Service name--sun880 (services name)

User--sgsj

5. Click Test Connection, enter PASSWORD--SGSJ in the pop-up Oracle ODBC Driver Connect window and click OK. Click OK on the Oracle ODBC Driver Configuration window.

6. Click OK to return and select sun880 (Oracle in OraHome92) from machine data source in the connect to an ODBC data source window and fill in the SGSJ in UserID. Enter SGSJ in password to check the Save password item

7. Click the Connect button, return to the Database Reverse Engineering window, click OK will pop up the import window, in which select the desired table.