Siebel CRM Integration to Oracle FLEXCUBE Universal Banking Implementation Guide > Performing Batch Data Loading and Synchronization >

Performing Batch Data Loading

This topic describes how to perform the initial batch loading of data from Oracle FLEXCUBE Universal Banking to Siebel CRM.

To perform the initial batch loading of data

1. Set up Oracle FLEXCUBE Universal Banking for the batch data integration as follows:
   • Create a user with read-only access to the staging tables from which Oracle Data Integrator extracts the data to be uploaded to Siebel CRM.
   • The staging tables are populated with data by batch programs after the end-of-day process is run, so ensure the following events have occurred:
     • The batch programs are configured in Oracle FLEXCUBE Universal Banking.
     • The end-of-day process is completed.

       For information on these tasks, see Siebel CRM Integration Interface User Manual.

2. Locate the Siebel EIM configuration files provided with the Integration; the EIM configuration file extension is .ifb.

   These files are located in Siebel\8.2\Tools_1\REPPATCH\ACR548.zip, where Siebel\8.2\Tools_1 is the Siebel Tools 8.2 installation directory. For additional information, see Accessing the Integration Files.

   The Siebel EIM configuration files specify the type of EIM process to perform, data import in this case, define the data to import, and indicate the batch numbers to use. For additional information on Siebel EIM configuration files, see Siebel Enterprise Integration Manager Administration Guide.

3. Place the Siebel EIM configuration files in the SIEBSRVR_ROOT\ADMIN directory, where SIEBSRVR_ROOT is the Siebel Server installation directory on the computer where the Siebel Server is installed.
4. Run the Oracle Data Integrator integration scenarios to start the batch data loading.

   To start the batch loading of data from Oracle FLEXCUBE Universal Banking to Siebel CRM, run each of the following scenarios that you generated in Generating Scenarios for Integration Packages:

   • FINS_BIB_PRODUCT_PKG
   • FINS_BIB_PRODUCT_RATE_PKG
   • FINS_BIB_LIMIT_PKG
   • FINS_BIB_MANDATE_PKG
   • FINS_BIB_CONTRACT_PKG
   • FINS_BIB_BRANCH_PKG

     You can run scenarios using one of the following methods:

   • From the ODI Studio
   • From a command line
   • From the Standalone Agent if it is installed
   • From the ODI scheduler
   • From an external scheduler

     For information on the various methods available for running scenarios, see Oracle® Fusion Middleware Developer's Guide for Oracle Data Integrator 11g Release 1.

5. After performing the batch data loading, check the following log files for errors:
   • Log table BIB_ODI_ERROR_LOG.
   • Siebel EIM log files.

     The EIM log files are Server Manager error log files which are located in the directory specified by the FINS_BIB_Log_Path variable.

     For information on these log files, see Siebel Log Files During Batch Data Loading.

6. After importing data into the Siebel Financial Services application, use the business service simulator to run the ISS Authoring Import Export Service to release the imported data so it can be used in the Siebel application. Perform the following steps:
   1. Log in to the Siebel Financial Services application.
   2. Navigate to the Administration - Business Service screen, then the Simulator view.
   3. In the Simulator list, click the New tab.
   4. In the Service Name field, select ISS Authoring Import Export Service.
   5. In the Method Name field, type the value Post_EIM_Upgrade. This method is hidden.
   6. In the Input Arguments list, create a new record.
   7. Set the Test Case# field to 1.
   8. In the Property Name field, create a new property with the following values:
      • Property Name: ReportOnly
      • Property Value: FALSE
   9. Click the Run tab to run the service.