Datawarehouse synchronization - Implementation

Prerequisite

Activity codes

The following activity codes (sorted by type) may have an impact on the way the function operates :

  ABI :  Business intelligence

Tables used

This function updates the datawarehouse data from the dictionary, and does not update the tables of the ERP, except for the AUDITH audit table if the sequential update mode is used. In that specific case, database triggers automatically trigger the creation of lines to process by the BI module, referencing the table lines managed in sequential update mode that have been created, modified or deleted. During the resynchronization processing, a flag used to know that these lines have been processed is updated.