Sync properties can be defined on an LU schema, LU table, or Table Population level.
A Sync property contains the following settings:
Timeout (sec) |
The timeout in seconds for syncing the LUI. |
Sync Method |
None, Time Interval, Inherited and Decision function. |
Parameters |
Settings of the selected sync method. For more details see the Sync Methods section below. |
Delete Instance if Not Exists |
When marked as True, Fabric deletes the LUI if the LUI is not found in the source system. When marked as False (default), the instance is retained in Fabric even if the instance is not found in the source system. |
Click for more information about Set Timeout for Sync.
Sync Method |
None |
Description |
Do not sync |
Parameters |
N/A |
Click for more information about LU Sync Levels
Fabric 6.5.9 adds the Delete Mode property to the LU table. This property replaces the previous Truncate Before Sync LU table's property. The Delete Mode defines the policy regarding the deletion of the previous records (populated prior to the current sync) from the LU table by the current sync. Therefore, there is a logical dependency between the delete mode and the sync mode. The Delete Mode can be set either on the LU table or on the table's populations:
The Delete Mode property is set on the LU table and defines the delete mode of the previous records in the LU table (populated prior to the current sync). The values are All (default value), Off or NonUpdated:
Notes:
A table population object that is based on a source object contains the following property: Truncate Before Sync.
This property is set on the LU table population target properties. The Truncate Before Sync = True is equivalent to the All value in the Delete Mode LU table's property.
Notes:
A new Broadway actor has been added in Fabric 6.5.9: SyncDeleteMode. This actor is automatically added to the generated Broadway flow with Off value.
The actor can have one of the following values:
Notes:
In general, the Delete Mode is set on the LU table. However, the Delete Mode can be overridden by the LU table population if the LU table's Delete Mode is not set to All as detailed in the table below:
When is a sync method selected? |
|
None |
The source either does not change or becomes unavailable, and therefore requires a one-time load only. After it is loaded, Fabric becomes the System of Record for the data and may get update transactions on the data. For example: adding a new payment. |
Time Interval |
Syncs every X times to ensure the data is up-to-date. |
Requires a specific logic to check whether the data needs to be synced from the source. |
Sync properties can be defined on an LU schema, LU table, or Table Population level.
A Sync property contains the following settings:
Timeout (sec) |
The timeout in seconds for syncing the LUI. |
Sync Method |
None, Time Interval, Inherited and Decision function. |
Parameters |
Settings of the selected sync method. For more details see the Sync Methods section below. |
Delete Instance if Not Exists |
When marked as True, Fabric deletes the LUI if the LUI is not found in the source system. When marked as False (default), the instance is retained in Fabric even if the instance is not found in the source system. |
Click for more information about Set Timeout for Sync.
Sync Method |
None |
Description |
Do not sync |
Parameters |
N/A |
Click for more information about LU Sync Levels
Fabric 6.5.9 adds the Delete Mode property to the LU table. This property replaces the previous Truncate Before Sync LU table's property. The Delete Mode defines the policy regarding the deletion of the previous records (populated prior to the current sync) from the LU table by the current sync. Therefore, there is a logical dependency between the delete mode and the sync mode. The Delete Mode can be set either on the LU table or on the table's populations:
The Delete Mode property is set on the LU table and defines the delete mode of the previous records in the LU table (populated prior to the current sync). The values are All (default value), Off or NonUpdated:
Notes:
A table population object that is based on a source object contains the following property: Truncate Before Sync.
This property is set on the LU table population target properties. The Truncate Before Sync = True is equivalent to the All value in the Delete Mode LU table's property.
Notes:
A new Broadway actor has been added in Fabric 6.5.9: SyncDeleteMode. This actor is automatically added to the generated Broadway flow with Off value.
The actor can have one of the following values:
Notes:
In general, the Delete Mode is set on the LU table. However, the Delete Mode can be overridden by the LU table population if the LU table's Delete Mode is not set to All as detailed in the table below:
When is a sync method selected? |
|
None |
The source either does not change or becomes unavailable, and therefore requires a one-time load only. After it is loaded, Fabric becomes the System of Record for the data and may get update transactions on the data. For example: adding a new payment. |
Time Interval |
Syncs every X times to ensure the data is up-to-date. |
Requires a specific logic to check whether the data needs to be synced from the source. |