Deliver Instance Synchronization

Note: This article is intended for database administrators. Ensure the following tasks are completed by someone with the appropriate database administration privileges.

Note: Relates to Jet Analytics Data Integration 6024.1 and later versions.

This article describes how to synchronize a Deliver instance when the data type of a field in the Prepare instance has changed, and how to remap fields in the Deliver instance when a Prepare instance table has been replaced by a new table.

Synchronize for a data type change

If the data type of a field in the Prepare instance has been changed and that field is used in the Deliver instance, synchronize the Deliver instance to keep the data types aligned.

For example, suppose a field called location_id is defined as bigint in the Prepare instance and has been added to the Deliver instance.

The field is then changed in the Prepare instance from bigint to Numeric (Decimal(38,2)) by right-clicking the field and selecting Edit Field.

The field in the Deliver instance is still bigint. To update the Deliver instance field to match, right-click the Deliver instance model and select Synchronize.

A notification confirms that the data type change has been auto-resolved.

The field is now updated to Numeric (Decimal(38,2)) in the Deliver instance.

Synchronize for remapping tables and fields

Use Synchronize with Remapping to map Deliver instance tables and fields to a different source table in the Prepare instance — for example, when a table has been replaced by a new one.

Right-click the Deliver instance model, select Synchronize with Remapping, then select the replacement table and fields.

If the source table in the Prepare instance has already been deleted, right-click the Deliver instance model and select Synchronize. The following dialog appears, indicating that the Deliver instance tables need to be remapped.

Select the replacement schema, table, and fields from the dropdowns. If the names of the tables and fields in the new source match those in the Deliver instance, they will be automatically selected.

Click OK to complete the remapping.