1. CRM Integration to Oracle FLEXCUBE Universal Banking Implementation Guide
  2. Configuring Oracle Data Integrator to Connect to the Siebel Database

Configuring Oracle Data Integrator to Connect to the Siebel Database

The procedure in this topic describes how to configure Oracle Data Integrator to connect to the Siebel database.

To configure Oracle Data Integrator to connect to the Siebel database

  1. Start ODI Studio and connect to the ODI work repository you created previously, for example, WORKREP1.

  2. Open the Topology Navigator, then navigate to Physical Architecture, Technologies, Oracle, and then Oracle Release Server.

  3. In the Data Server editor, specify values for the following Data Server definition parameters:

    1. In the Instance/dblink (Data Server) field, enter the name of the Siebel database.

    2. In the User and Password fields, enter the user name and password that are used to connect to the Siebel database.

  4. Click the JDBC tab, then specify values for the following parameters:

    1. In the JDBC Driver field, select the driver used to access the Siebel database, for example, the Oracle JDBC driver.

    2. In the JDBC URL field, enter the complete path to the Siebel database.

  5. Click the Test Connection button to verify that the connection settings are correct.

  6. In the Topology Navigator, expand Oracle Release Server, select the Siebel data server, and open the Physical Schema definition.

  7. In the Physical Schema screen, do the following:

    1. Enter the name of the Siebel database in the Schema (Schema) and Schema (Work Schema) fields.

      The Work Schema is a temporary store for objects required at run time. Depending on how you have implemented Oracle Data Integrator, the Schema and Work Schema can be the same or different. If these schemas are different, the user specified in Step 3 must have privileges to both.

    2. Click the Default button.