Shulou(Shulou.com)06/01 Report--

This article shares the PowerDesigner15.1 connection oracle11g reverse generation ER diagram for your reference, the specific content is as follows

1. Create dmp

Select the menu File- > New Model, [Model type] select Physical Data Model, [Model name] name freely, [DBMS] select "ORACLE Version 11g", and click OK.

two。 Create a data source

Click to add data source

Select 'system data Source' and next step

Select oracle in OraDb11g_home1 next step

Then click finish to pop up the following dialog box:

Free naming of Data dource Name

TNS Service Name Select ORCL

Click Test Connection to test whether it is successful or not!

Enter the user name and password and click OK

Click OK to confirm the completion of the data source addition.

3. Select DataBase- > Configure Connections to view the new data source.

4. Select the menu Database-Update Model Database, select Using a data source, and click the Select button on the right

Click connect in the following figure.

Then click OK:

You can select the desired table to export the ER diagram.

The above is the whole content of this article, I hope it will be helpful to your study, and I also hope that you will support it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.