Database Links (Oracle)

A database link is a schema object in one database that enables you to access objects on another database.

Database links are supported for Oracle 11g and higher. PowerDesigner models database links as extended objects with a stereotype of <<Database Link>>.

Creating a Database Link

You can create a database link in any of the following ways:

  • Select Model > Database links to access the List of Database links, and click the Add a Row tool.

  • Right-click the model (or a package) in the Browser, and select New > Database link.

Database Link Properties

You can modify an object's properties from its property sheet. To open a database link property sheet, double-click its Browser in the Database links folder.

The following extensions are available on the General tab:

Name

Description

Public

Specifies whether the database link is available to all users. If False, then the database link is private and is available only to you.

Scripting name: Public

The following extended attributes are available on the Oracle tab:

Name

Description

Shared

Specifies the use of a single network connection to create a public database link that can be shared among multiple users. If selected, you must also specify a user name and password for the target instance on the remote server.

Scripting names: Shared, AuthenticatedBy, AuthenticationPassword

Connect to

Specifies the user name and password used to connect to the remote database using a fixed user database link.You need to specify CURRENT_USER to create a current user database link. The current user must be a global user with a valid account on the remote database. If you do not specify a value, then the database link uses the user name and password of each user who is connected to the database.

Scripting names: Username, Password

Service name

Specifies the service name of a remote database. If you specify only the database name, then Oracle Database implicitly appends the database domain to the connect string to create a complete service name.

Scripting name: ServiceName

Physical data model

Specifies the PowerDesigner model that contains the objects of the remote database. Use the buttons to the right of the field to create, delete, select, or view the property sheet of the model.

Scripting name: LinkModel