Modes of Data Extraction

The Data Extractor feature enables you to extract data in two different modes depending upon the type of the business object. The two different data extraction modes are:

• Batch Mode - The batch mode enables you to extract data from the ORMB application by executing or scheduling C1-DTEX batch. It enables you to extract full or incremental data created using a business object. It checks the data extract type specified in the data extract request type. If the data extract type is set to Full, the batch extracts the entire data from all the tables associated with the respective maintenance object. However, if the data extract type is set to Incremental, the batch extracts the delta (i.e., data which is added or updated since the last extraction) from all the tables associated with the respective maintenance object. On executing the C1-DTEX batch, the system extracts the data in multiple files and initially assigns the .part extension indicating that the data extraction is still in progress. Once the data extraction is completed, the extension changes to .csv confirming successful completion of the data extraction process.
• Online Mode - The online mode enables you to extract incremental data created using a business object. Note that the online mode is supported only for non-transactional business objects that are User Interface (UI) based. To enable the online mode data extraction, you need to attach an algorithm created using the DTEXBOPSTALG algorithm type to the Post-Processing system event of the respective non-transactional business object. In the online mode, the system extracts the data immediately when it is added or updated through the user interface. The data is extracted in the CSV file at the predefined location. Note that the deleted records are not extracted in the CSV file. For example, when you configure online mode data extraction for the C1_​PERSON_​BO business object, the system immediately extracts the person record that is added or updated in the CSV file. You can schedule a time slot for online mode data extraction by setting the DTEXSCH feature configuration. This feature configuration enables you to maintain a single file for each table with consolidated records added or updated during the day in the online mode instead of creating multiple files for each table throughout the day. For more information, see Creating the DTEXSCH Feature Configuration

If any error occurs while extracting data, the errors are stored in the following file, which is created along with the CSV files:

<Data_Extract_Request_Type>_<MO>_ERROR_<Extraction_Date>_<Batch_Run_No>.csv 

The summary of the extracted files is maintained in the CI_​DATA_​EX_​REQ table. The data created using the transactional business objects can only be extracted in the batch mode. However, the data created using the non-transactional business objects can be extracted in the batch mode as well as in the online mode. The system supports full data extraction only through the batch mode and not in the online mode. However, the system supports incremental data extraction in both online and batch modes.