Development > Business intelligence > Datawarehouse update > Datawarehouse synchronization
Datawarehouse synchronization
Use this function to update a datawarehouse from the data of a live folder. This synchronization can be defined:
- on a list of tables (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
Refer to documentation Implementation
Screen management
Entry screen
Presentation
In addition to the entry of datawarehouse to synchronize, the different technical parameters of the synchronization are defined in this tab.
Close
Fields
The following fields are present on this tab :
Data warehouse
| Use this check box to define the list of datawarehouses to be processed. |
Options
| The datawarehouse synchronization function retrieves the data in the source tables and transfers them to the destination tables. Select this check box to reset the destination tables to zero and populate them again. |
| Select this check box to generate a detailed log of the audit records that have been added to, modified or deleted in the fact and dimension tables. |
| When this check box is selected, the synchronization is not performed, but only simulated. A log file is generated listing the tables that would have been updated if the operation was actually run. |
| Select this check box to retain the records of the audit table. This will allow you to reuse these records for another datawarehouse, for example. |
BI table selection
| Select the List check box to only select the types of BI tables that you need. |
Grid BI table type
|
|
|
|
|
|
|
|
Close