PowerDesigner establish a connection to the database to generate the database and generate it from the database into PD

The first step, open PD15, find "Database",:

In the second step, click the New button to create a new ODBC connection.

The third step is to select the system data source and select the Oracle

Fourth, note that the server needs to write the service name of the Oracle client configuration, which is the name used for PL/SQL connections. is not an IP address.

5th step, test if the connection is successful.

At this point, the database has been linked, can be disconnected, can also be connected, but also for the database of forward engineering and reverse engineering.

Reverse engineering file-"Reverse engineer--" DataBase

Select the database type in the DBMS

such as Microsoft SQL Server2008.

Click OK;

Select Using a data source, and then select Connect to data sources

In DataSource, select ODBC machine Data source, and in the drop-down list below, choose the data source you created, such as Canyoung (SQL Server), from the previous step.

Enter the database user name and password in login below.

Click "Connect", if successful, see:

Look under the table name is not the same as the table name in their database, the following on their own choice!!!

PowerDesigner establish a connection to the database to generate the database and generate it from the database into PD