Development > Business intelligence > Datawarehouse update > Datawarehouse synchronization 

This function is used to update a datawarehouse from the data of a live folder. This synchronization can be defined:

  • on a list of table (the tables are checked and ranges are defined if necessary)
  • for all the datawarehouse
  • only for the tables updated in an incremental fashion (only the new lines or the updated lines are regenerated).

In the case of non-incremental updates, it is possible to previously delete all the existing data in the updated tables. It is used to distribute a given situation on the live environment.

Prerequisite

SEEREFERTTO Refer to documentation Implementation

Screen management

Entry screen

Presentation

In addition to the entry of datawarehouse to synchronize, the different technical setups of the synchronization are defined in this tab.

Close

 

Fields

The following fields are present on this tab :

Data warehouse

Used to define the list of data warehouses to be processed.

Options

  • Preliminary purge (field GEN)
  • Detailed log file (field DET)
  • Simulation (field SIMU)
  • Audit backup (field EPUAUD)

BI table selection

  • field TYPVAL

Grid BI table type

  • Type (field TYPDES)

 

  • To process (field TYPSEL)

 

  • from (field TYPSTR)

 

  • To (field TYPEND)

 

Close

 

Batch task

This function can be run in batch mode. The standard task ABIMAJBAS is provided for that purpose.

Specific Buttons

Error messages

The only error messages are the generic ones.

Tables used

SEEREFERTTO Refer to documentation Implementation