Siebel CRM Integration to Oracle FLEXCUBE Universal Banking Implementation Guide > Installing and Configuring the Integration >

Installing Oracle Data Integrator

Before you can deploy the Integration files, you must install and configure Oracle Data Integrator. For general information on these tasks, see Oracle® Fusion Middleware Installation Guide for Oracle Data Integrator 11g Release 1. This topic describes the specific installation and configuration tasks required for Siebel CRM Integration to Oracle FLEXCUBE Universal Banking.

This task is a step in Roadmap for Installing and Configuring the Integration.

To install Oracle Data Integrator

1. Perform the following preinstallation tasks:
   • Create a database schema to store the Oracle Data Integrator work repository and master repository.
   • Ensure that the schema owners of the Oracle FLEXCUBE Universal Banking and Siebel databases are assigned the following privileges:
     • Create and drop table
     • Create and drop synonym
     • Insert, update, and delete table
     • Create and drop view
     • Create and drop procedure
     • Create and drop sequence
     • Create and drop triggers
     • Create and drop DB Links
     • Create and drop functions
     • Create and drop packages
2. Install Oracle Data Integrator as described in Oracle® Fusion Middleware Installation Guide for Oracle Data Integrator. Select the following installation options:
   • In the Select Installation Type screen, select ODI Studio (with local agent). You can optionally choose to install the Standalone Agent.
   • In the Repository Configuration screen, select the Skip Repository Configuration option.
3. After the installation process has completed, configure a connection between Oracle Data Integrator and the master repository as follows:
   1. Start ODI Studio.
   2. From the ODI menu, choose File, and then the New menu item.
   3. In the New Gallery window, select ODI from the General category, then select the option, Create a New ODI Master Login.
   4. In the Repository Connection Information window, enter ODI and database connection information using values similar to that shown in the following table.

      Section	Parameter	Value
      Oracle Data Integrator Connection	Login Name	Enter a connection alias, for example, Master Repository.
      	User	Enter the value SUPERVISOR for the ODI supervisor user name.
      	Password	Enter the value SUPERVISOR for the password associated with the supervisor user.
      Database Connection (Master Repository)	User	Enter the user ID of the owner of the tables created for the master repository.
      	Password	Enter the password associated with the table owner user ID.
      	Driver List	Select the driver required to connect to the database where the master repository is defined, for example, Oracle JDBC Driver.
      	Driver Name	Enter the driver name, for example, oracle.jdbc.driver.OracleDriver.
      	URL	Enter the complete path of the data server hosting the master repository.
      Work Repository	Master Repository Only	Select this option.

   5. Click the Test button to verify that the connection is working.
   6. Click OK.