POWERDESIGNER15 Connection oracle11g Service (non-native, LAN Server), reverse engineering

Database service on the LAN server, now the machine installed POWERDESIGNER15, need to connect to the server database, and reverse generated entity Object Model diagram, online posts are also many, according to their actual operation here to record

1, connect to the remote database server, new Data source Toolbar Options Database---"Configure Connections

Pop-up Create Data Source window select System Data source, next

Select the driver, select Microsoft Odbc for Oracle here, and click Next to finish

In the data source setting that pops up, fill in the server information

Data source Name, description is free to write, user name is connected to Oracle login user name, the server is the remote service address, after completion, you can test whether the connection is successful, pop-up box input password can verify whether the connection is successful

2 after connecting to the server, you can reverse generate the data model, File--->new model

After creating a new model, the toolbar database--"Update model from database, pop-up box select the previously configured data source, enter the password and connect to the database

After the connection is successful, all the table information will be ejected from this user, select the table that needs to be generated in reverse, OK.

By the end of the reverse engineering, the resulting data Model diagram will also show the relationships of the tables! Ok....

POWERDESIGNER15 Connection oracle11g Service (non-native, LAN Server), reverse engineering