Siebel CRM Integration to Oracle FLEXCUBE Universal Banking Implementation Guide > Installing and Configuring the Integration > Process of Configuring Oracle Data Integrator in a Development Environment >

Connecting to the Oracle FLEXCUBE Universal Banking and Siebel CRM Databases

In order for Oracle Data Integrator to perform bulk data uploads, it must be configured to connect to the Oracle FLEXCUBE Universal Banking and Siebel databases. This involves:

1. Creating a database link.
2. Configuring Oracle Data Integrator to connect to the Oracle FLEXCUBE database.
3. Configuring Oracle Data Integrator to connect to the Siebel database.

Each of these tasks is described in the following topics.

This task is a step in Process of Configuring Oracle Data Integrator in a Development Environment.

Creating the Database Link

Database links are used to transfer data between the Oracle FLEXCUBE Universal Banking and Siebel databases. Use SQL*Plus or any other database tool to create the database link in the Siebel database to access data from the source Oracle FLEXCUBE Universal Banking database.

The following procedure describes how to create the database link.

To create the database link

1. Enter the following command:

   CREATE DATABASE LINK database link name

   {CONNECT TO oracle user ID

   IDENTIFIED BY remote oracle user's password}

   USING 'dbstring';

   where:

   • database link name is the name you assign to the database link
   • oracle user id is the user ID used to connect to the remote Oracle FLEXCUBE database
   • remote oracle user's password is the password associated with the oracle user ID
   • dbstring is the name of the service used to connect to the database
2. Use the following query to verify that the database link is successfully created:

   SELECT DB_LINK FROM ALL_DB_LINKS

For example, the following SQL statements create a database link in the local Siebel database that connects to the AAADEV2 database, with the FCDEV116 user ID, using the service name AAADEV2.

CREATE DATABASE LINK AAADEV2

CONNECT TO FCDEV116

IDENTIFIED BY FCDEV116

USING '(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP) (HOST = 10.184.74.142)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = AAADEV2 )

)

)'

Configuring Oracle Data Integrator to Connect to the Oracle FLEXCUBE Universal Banking Database

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

To configure Oracle Data Integrator to connect to the Oracle FLEXCUBE 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 FC Server.
3. Select Oracle FC Server, then click the Definition tab.
4. Specify values for the following Data Server definition parameters:
   • In the Instance/dblink (Data Server) field, enter the name assigned to the database link you created in Creating the Database Link.
   • In the User and Password fields, enter the user name and password that are used to connect to the remote Oracle FLEXCUBE Universal Banking database. Enter the same user and password values as those specified when creating the database link.
5. Click the JDBC tab, then specify values for the following parameters:
   • In the JDBC Driver field, select the driver used to access the Oracle FLEXCUBE database, for example, the Oracle JDBC driver.
   • In the JDBC URL field, enter the complete path to the Oracle FLEXCUBE Universal Banking database.
6. On the Topology Navigator, expand Oracle FC Server, select the FLEXCUBE data server, and select the Definition tab to view the Physical Schema definition details.
7. In the Physical Schema screen, do the following:
   • Enter the name of the Oracle FLEXCUBE 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 4 must have privileges to both.

   • Click the Default button.

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:
   • In the Instance/dblink (Data Server) field, enter the name of the Siebel database.
   • 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:
   • In the JDBC Driver field, select the driver used to access the Siebel database, for example, the Oracle JDBC driver.
   • 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:
   • 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.

   • Click the Default button.