Share this page

# Generating Database Links (Oracle Object Migration)

OpenText PPM can use database links to communicate with other databases. Usually a database link created and associated with a particular environment in OpenText PPM can be used in situations such as AutoCompleteSQL.

The following are examples of situations in which database links are used:

- Custom object types designed to provide parameter value lists directly from a source or destination database during Deployment Management activities

- Some Deployment Management Extensions, such as the Extension for Oracle E-Business Suite, to facilitate Deployment Management activities

You can define database links on an as-needed basis. For each database link you require (this probably includes a link to the OpenText PPM database), issue an SQL statement similar to the following in the OpenText PPM database schema.

    create database link DEV_LINK

    connect to APPS identified by APPS

    using 'DEV'

For more information about database links, see:

- Deployment Management Extension for Oracle E-Business Suite Guide

- Object Migrator Guide

- Oracle's reference document on the SQL language

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: