4. Synchronizing the Reporting Datamart with the HOPEX Repository content
To keep your Reporting Datamart up-to-date with HOPEX repository updates, you can synchronize it with HOPEX Repository content thanks to the following provided triggers:
Incremental synchronizationCalculated MetaAttribute synchronizationDiagram synchronization Although, if needed, you can modify the Reporting Datamart data, these modifications are never synchronized with the HOPEX repository. Synchronization is only one way: from HOPEX repository to Reporting Datamart.
4.1. Synchronization frequency
The schedule policy of these synchronization triggers depends on the object volume in the HOPEX Repository and on the up-to-date data level you want to deliver to the Reporting Datamart users.
If you need a perfect synchronization between data, calculated MetaAttributes and Diagrams you can daily run the corresponding triggers at the same time.
 |
Synchronization scheduling use: once scheduled the trigger launch the synchronization on all the repositories and for all their Reporting Datamarts.
To trigger the action on a specific repository for a specific Reporting Datamart, see HOPEX Power Studio > All about starting with APIs > Initializing and synchronizing a Reporting Datamart.
|
4.2. Launching an incremental synchronization
|
|
The HOPEX repository log must be activated (default value for an RDMS repository).
|
Launch an incremental synchronization to update the Reporting Datamart with all the dispatches performed after the last synchronization.
You can:
at any time, manually launch an incremental synchronization define a scheduled trigger for the incremental synchronizationTrigger: Reporting Datamart Synchronization
Frequency: you can schedule the incremental synchronization with a high frequency (i.e.: every 10').
For information regarding the scheduling, see HOPEX Power Studio > Using the Scheduler > Scheduler.
To manually launch an incremental synchronization:
1) Launch HOPEX Administration application.
2) Connect to the environment concerned.
3) In the Repositories folder, expand the repository folder concerned.
4) In the Reporting Datamart folder, right-click the Reporting Datamart concerned and select Synchronize > Incremental update.
To define the scheduled trigger for an incremental synchronization:
1) Launch HOPEX Administration application.
2) Connect to the environment concerned.
3) In the Repositories folder, expand the repository folder concerned.
4) Right-click Scheduler and select Manage triggers.
5) (If needed) In the System Triggers tab, right-click Reporting Datamart Synchronization and select Update Scheduling to modify the scheduling according to your needs.
6) In the System Triggers tab, right-click Reporting Datamart Synchronization and select Activate.
The Reporting Datamart Synchronization is scheduled as defined (by default every 10').
4.3. Launching a calculated MetaAttribute synchronization
Launch a calculated MetaAttribute synchronization to scan all the objects and links of the HOPEX repository that can have calculated MetaAttribute values and put their values in the Reporting Datamart.
Do not launch or schedule a calculated MetaAttribute synchronization if you do not use the values of calculated MetaAttributes from the Reporting Datamart.
To exclude specific MetaAtribute values from this synchronization, see Excluding MetaAttribute values from the Reporting Datamart.
You can:
manually launch a calculated MetaAttribute synchronization define a scheduled trigger for the diagram synchronizationTrigger: Reporting Datamart Synchronization (Calculated MetaAttribute)
Frequency: The synchronization may take time according to the HOPEX Repository calculated MetaAttribute volume. You should first manually launch a calculated MetaAttribute synchronization once to check the synchronization duration, so as to determine the synchronization scheduling frequency.
|
|
When you schedule a “Reporting Datamart Synchronization (Calculated MetaAttribute)” the trigger is launched on all the repositories and for all their Reporting Datamarts.
To trigger the action on a specific repository for a specific Reporting Datamart, see HOPEX Power Studio > All about starting with APIs > Initializing and synchronizing a Reporting Datamart.
|
For information regarding the scheduling, see HOPEX Power Studio > Using the Scheduler > Scheduler.
To manually launch a calculated MetaAttribute synchronization:
1) Launch HOPEX Administration application.
2) Connect to the environment concerned.
3) In the Repositories folder, expand the repository folder concerned.
4) In the Reporting Datamart folder, right-click the Reporting Datamart concerned and select Synchronize > Attributes calculated.
To define the scheduled trigger for a calculated MetaAttribute synchronization:
1) Launch HOPEX Administration application.
2) Connect to the environment concerned.
3) In the Repositories folder, right-click Scheduler and select Manage triggers.
4) In the System Triggers tab, right-click Reporting Datamart Synchronization (Calculated MetaAttribute) and select Execute
Check the synchronization duration.
5) In the System Triggers tab, right-click Reporting Datamart Synchronization (Calculated MetaAttribute) and select Update Scheduling.
6) Modify the scheduling according to your needs.
7) Click OK.
8) In the System Triggers tab, right-click Reporting Datamart Synchronization (Calculated MetaAttribute) and select Activate.
The Reporting Datamart Synchronization (Calculated MetaAttribute) is scheduled as defined.
4.4. Launching a diagram synchronization
Launch a diagram synchronization to scan all the HOPEX repository diagrams and update the Reporting Datamart with their drawing representation in the SVG format.
Do not launch or schedule a diagram synchronization if you do not use diagrams.
You can:
manually launch a diagram synchronization define a scheduled trigger for the diagram synchronizationTrigger: Reporting Datamart Synchronization (Diagrams)
Frequency: The synchronization may take time according to the HOPEX Repository diagram volume. You should first manually launch a diagram synchronization once to check the synchronization duration, so as to determine the synchronization scheduling frequency.
|
|
When you schedule a “Reporting Datamart Synchronization (Diagrams)” the trigger is launched on all the repositories and for all their Reporting Datamarts.
To trigger the action on a specific repository for a specific Reporting Datamart, see HOPEX Power Studio > All about starting with APIs > Initializing and synchronizing a Reporting Datamart.
|
For information regarding the scheduling, see HOPEX Power Studio > Using the Scheduler > Scheduler.
To manually launch a diagram synchronization:
1) Launch HOPEX Administration application.
2) Connect to the environment concerned.
3) In the Repositories folder, expand the repository folder concerned.
4) In the Reporting Datamart folder, right-click the Reporting Datamart concerned and select Synchronize > Diagrams.
To define the scheduled trigger for a diagram synchronization:
1) Launch HOPEX Administration application.
2) Connect to the environment concerned.
3) In the Repositories folder, right-click Scheduler and select Manage triggers.
4) In the System Triggers tab, right-click Reporting Datamart Synchronization (Diagrams) and select Execute.
Check the synchronization duration.
5) In the System Triggers tab, right-click Reporting Datamart Synchronization (Diagrams) and select Update Scheduling.
6) Modify the scheduling according to your needs.
7) Click OK.
8) In the System Triggers tab, right-click Reporting Datamart Synchronization (Diagrams) and select Activate.
The Reporting Datamart Synchronization (Diagrams) is scheduled as defined.