Add Clinical One remote locations

Database links are used to load data and metadata from Clinical One to DMW.

When defined here, the remote location automatically populates in the Clinical One Configuration interface after a tenant has been selected.

Tip:

To ensure that the list of available studies is current and available for selection on the Clinical One Configuration interface in Study Configuration, you may need to use Refresh Clinical One Studies for a new or updated remote location.

1. Click Navigation from the navigation bar and then click Administration.
2. Make sure the Data Sources tab is selected, then click the Remote Locations subtab.
3. Click Add and select Add Clinical One RL or clickModify to update an existing remote location.
4. Enter:

   • Name: A name for the Clinical One database. It cannot contain spaces, slashes, or special characters other than underscore (_). This is displayed for study configurators.

     Tip:

     Include the Clinical One tenant in the name to make it easy for the study configurator to select.

   • ConnectString: The text of the Using clause of the Create Database Link SQL statement. This is normally the same as the Description Clause of a TNSNAMES definition—for example:

     (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=host_name.company_domain.com)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=trial_name.world)))

     Tip:

     It cannot contain spaces.

   • Username: The name of the DMW read-only access account in the Clinical One database for this remote location. The system will use this account to connect.

   • Password: Enter the password of the account. The system changes and encrypts the password after creating the database link.

5. Click Test Connection to make sure it is set up correctly.
6. Click OK.