1.5 Integration Process

This topic explains the integration process for OBTR and OFSAA integration.

OBTR has pre-defined staging tables required for OFSAA extracts. During EOFI batch, the module wise data is extracted to staging tables in OBTR. OBTR provides a control table to indicate successful data extraction. OFSAA pulls the data from the tables in OBTR using the DIH connector.

The transfer or extraction of data from OBTR to OFSAA differs based on the staging tables as follows:

• Master table - Incremental data between two extraction dates are transferred.
• Maintenance and contract tables - Entire transaction data are transferred in each extraction.
• Transaction table - Data related to the transactions created on the extraction date are transferred.

During data extraction you can check the status of the extraction routines in the table ESTB_TR_JOB_CONTROL. The column STATUS shows whether the routine is in progress (W) or has failed (F) or has completed successfully (S). At the time of extraction all the routines from maintenance table ESTM_TR_DEST_TABLES are inserted to ESTB_TR_JOB_CONTROL for the current extraction date with initial status as W. This status will be updated accordingly when the routine is completed successfully (S) or unsuccessfully (F).

This topic has the following sub-topic:

• Extraction Log
  

1.5.1 Extraction Log

You can have the logs generated as part of EOD for each table. EOD log captures the complete extraction process. The table level extraction log contains the details of each data transfer.

Errors in the data extraction process and the failure reasons are logged in an error data store. These errors are rectified manually and the batch is run again for the failed data.