Defining External Connections

  To define an external connection:

1. On the Home page, select Administer.

2. From New, select External Connection.

3. Enter a name and description.

4. From Object Access, select Standard or System.

5. Select a connection type: Server File, FTP, or Database Table.

6. Do the following:

   • If you selected Server File, enter a UNC path to the server.

     Note:

     The Windows user account used by the Data Relationship Management application server is automatically used for Server File connections. The default Windows user account used for the Oracle DRM Server Processes Windows service is Local System account. The account used for the service must be able to access the UNC path for proper Server File connectivity. Additionally, the UNC path must have the appropriate permissions for the service account to read and write files.

   • If you selected FTP, enter the following information:

     • Host Server

     • User ID

     • User Password

   • If you selected Database Table, do the following:

     • Select the Data Access Provider: Oracle, SqlServer, or OleDb

     • Enter Connection String

     • Enter User ID

     • Enter User Password

     • Click and then select tables from the Available list. Use the arrows to move tables to the Selected list.

7. Click Test Connection.

   Note:

   For Database connection, click Refresh to get the list of tables.