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:

   1. In the Instance/dblink (Data Server) field, enter the name assigned to the database link you created in Creating the Database Link.

   2. 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:

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

   2. 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:

   1. 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.

   2. Click the Default button.