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>>.
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 |