Defining Connections

A Connection provides a username and password that Oracle Life Sciences Data Hub uses to access a remote database.

Oracle LSH encrypts the passwords.

To use a Remote Location, there must be at least one Connection defined for it. You, the administrator, can define shared Connections available to all users with normal security access to the defined Remote Location. In addition, any Oracle LSH user with an account and password on the remote location can define his or her own Connection through the Preferences link (see "Setting Preferences" in the Oracle Life Sciences Data Hub User's Guide for instructions). User-defined Connections are available only to the user who defined them.

To define a Connection:

1. In the main screen for the Remote Location for which you want to create a Connection, click Create Connection. The Create Connection screen opens.
2. Enter values in the following fields:
   • Name. Enter a name for the Connection.
   • Description. Enter a description of the Connection.
   • User Name. Enter a valid user name for an account on the remote location. Oracle LSH will use this user name to connect to the remote location.
   • Password. Enter the password required for the same user account. Oracle LSH encrypts the password for security.
   • Connection Type. Select the Connection Type from the drop-down list.
     • User. The User option allows only the person who creates the Connection to use it.
     • Shared. The Shared option allows multiple users to use the Connection. Security is determined by user group assignment to the Connection.
   • Remote Location. The system populates the field with the name of the Remote Location for which you are defining this Connection. See Defining Remote Locations .
3. In the Classification section, select the following for both the definition and the instance:

   • Subtype. Select a subtype according to your company's policies.

   • Classification Values. Specify classifications according to your company's policies, to enable users to search for the Connection by classification. For instructions, see "Classifying Objects" in the Oracle Life Sciences Data Hub Application Developer's Guide.

4. Click Apply to save your work. The system displays the main screen for the new Connection.

You can change the security and classifications of the Connection through the items in the Actions drop-down list. By default, the Connection inherits the user group assignments of the Remote Location. If the user group assignments for the Remote Location and Connection are different, the user must have access to both in order to use the Remote Location/Connection combination.