1. CRM Integration to Oracle FLEXCUBE Universal Banking Implementation Guide
  2. Configuring Integration Variables

Configuring Integration Variables

In Oracle Data Integrator, you can create and store the following variables, which can then be used in various projects:

  • Global variables. Use in all projects.

  • Project variables. Use in specific projects.

Oracle Data Integrator variables store single values, for example, a string, a number, or a date, which can be updated at run time. This topic describes how to modify the global and project variables required by the Integration.

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

To configure integration variables

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

  2. Open the Designer navigator, then navigate to Others, and then Global Variables.

  3. Select each of the variables shown in the following table in turn, open the variable, and in the Variable editor screen, set the default value of the variable as indicated in the following table.

    Global Variable Default Value

    FINS_BIB_Enterprise_Server

    Specify the name of the Siebel Enterprise Server, for example, siebel.

    FINS_BIB_Gateway_Server

    Specify the name and port number of the Siebel Gateway.

    FINS_BIB_Log_Path

    Enter the path to the directory where you want to store Server Manager log files for Enterprise Integration Manager jobs.

    FINS_BIB_Username

    The Siebel user name used for connecting to the Siebel Enterprise, for example, SADMIN.

    FINS_BIB_Password

    The password associated with the Siebel user name defined in FINS_BIB_Username.

    FINS_BIB_Siebel_Path

    Enter the full path to the Siebel installation directory that contains the srvrmgr.exe file.

    FINS_BIB_Siebel_Server

    Specify the name of the Siebel Server on which the Siebel Enterprise Integration Manager component runs.

    FINS_BIB_Default_Organization

    Specify the name of the organization for which you want to load data. This variable is applicable for Product and Branch data only.

    FINS_BIB_EIM_ErrorFlags

    Specify the event log level for the Siebel Enterprise Integration Manager component. For additional information on changing log levels, see Siebel Enterprise Integration Manager Administration Guide.

    FINS_BIB_EIM_SQLFlags

    Specify a value of 8 to log all SQL statements that make up the Siebel Enterprise Integration Manager task. For additional information, see Siebel Enterprise Integration Manager Administration Guide.

    FINS_BIB_EIM_TraceFlags

    Specify the trace log level for the Enterprise Integration Manager component. For additional information, see Siebel Enterprise Integration Manager Administration Guide.

  4. In the Designer navigator, navigate to Projects, BIB BRANCH, Variables, and then FINS_BIB_Organization.

  5. In the Variable editor screen, set the default value of the variable to the name of the bank for which branch data is to be loaded.

  6. A Siebel organization must be created for the bank for which branch data is to be loaded before starting the branch data load. To create a Siebel organization, perform the following steps:

    1. Log in to the Siebel Financial Services application.

    2. Navigate to the Administration - Group screen, then the Organizations view.

    3. In the form, add a new record and complete the necessary fields.

    For detailed information on creating organizations and divisions, see Siebel Security Guide.