Changing the Remote Subscription Type

You can change the remote subscription type for real-time replication for an active DataSource. You can switch from one remote subscription type to another, select an additional remote subscription type, or deactivate real-time replication. Note, however, that such changes can affect data extraction and direct access.

You can change the selection for real-time replication for an active DataSource in the DataSource editor if the data provisioning adapter used by the DataSource supports real-time replication. You can use the Change Remote Subscription Type pushbutton on the Extraction tab page to do this. When you choose this pushbutton, a wizard opens in which you make the change in the first step. In the next step, the wizard shows the effects of the change on an existing delta extraction (data transfer process) or direct access (Open ODS view) if the DataSource is activated with the changes. The change is not made until you have confirmed this step by choosing Finish.

Changing the remote subscription type can result in changes to the delta process of the DataSource. This affects the data transfer process and, therefore, data extraction. Changing the remote subscription type can also result in data access to another table of the DataSource. This means that another table is accessed directly by Open ODS views.

Example: Changing remote subscription type UPSERT to remote subscription types UPSERT and INSERT

Data transfer processes for which the source is a DataSource whose remote subscription type has been changed from UPSERT to UPSERT and INSERT are set to inactive. This is because the delta process of the DataSource is changed from AIMD After images with deletion indicator to ABR Complete delta update with deletion indicator as a result of the change. To transfer the entire delta history to the data target, you perform a delta initialization. When the data transfer process is reactivated, the system checks whether the changed delta process of the DataSource is compatible with the target of the data transfer process.

Alternative to Changing the Replication Method

As an alternative to changing the remote subscription type, you can create an additional DataSource on the remote source object and connect this DataSource to the same data target. Note that any existing data transfer process in extraction mode Delta on the original DataSource must be terminated to avoid duplicate records in the data target. The switch from the original delta DataSource and original data transfer process to the new delta DataSource and new data transfer process must be made with care to ensure delta consistency in the data target.