About Remote Locations and Connections

To use an Oracle-technology source data system adapter (the general Oracle Tables and Views adapter and the Oracle Clinical adapters) you must create a database link and define one or more Remote Locations in the Oracle Life Sciences Data Hub user interface for each actual remote location, and define one or more Connections giving a valid username and password for each Remote Location. All passwords are encrypted in Oracle LSH.

A user must select both a Remote Location and Connection to define and to run an Oracle-technology Load Set.

There are two types of Connections:

• User Connections are created by users to external databases for which they have a valid username and password. Users can see and use only the User Connections they have created.
• Shared Connections are created by an administrator. They also require a valid username and password to the external database, but are available for use to any user who belongs to a user group assigned to the Adapter Area for which the Remote Location is defined.

All the users in a user group assigned to an Adapter Area have access to any Remote Locations defined for that adapter. They can then define their own User Connection based on their personal username and password on the external database, or use a Shared Connection that the administrator has defined; see Defining Connections.

For example, if a user is a member of a user group assigned to the general Oracle Tables and Views Adapter Area and the user has Read privileges on a particular Oracle database, then the user can create a Connection to the Remote Location defined for that database. The user can also use any shared Connections the administrator has defined for the same Remote Location.

The CDR_SYS_ADMIN function role is required to define Remote Locations and Connections.

You can add Remote Locations and Connections at any time.

This section contains the following topic:

• Security
  Remote Locations and Connections are defined objects with the same security requirements as other defined objects.