Replicating data with an IBM Data Replication Access Server connection

Supported database versions

To determine which CDC engines you can use for your solution, review the types of supported source and target data stores, and supported database versions. For details, see Setting up remote CDC replication.

Restrictions

• All replications allocate standard replication mappings for your tables. For details, see Mapping using standard replication in CDC.
• All columns are mapped by the remote data stores.
• Remote data plane engines impose additional restrictions. For details, see Setting up remote CDC replication.

Connecting to IBM Data Replication Access Server in a project

To connect to a remote Change Data Capture replication deployment by using an IBM Data Replication Access Server connection in a project in Cloud Pak for Data, see IBM Data Replication Access Server connection.

Creating a replication asset

To create a Data Replication asset :

1. Click the Assets tab in the project.
2. Click New asset > Replicate data.
3. Enter a name. The name is limited to 30 alphanumeric characters.
4. Select the CDC Subscription business goal.
5. On the Source options page, select an existing Data Replication Access Server connection from the list of connections or click Add connection to create a new connection.
6. Select the source data store for the subscription.
7. Click Select data and select the tables that contain the data you want to replicate.
8. On the Target options page, select the target data store. Select a target table for each source table to be replicated.
   Note: All target tables must be pre-created with similar table structures as the source tables.
9. On the Review page, review the summary, then click Create.

Starting a replication job

When you start replicating data by clicking on the Run replication icon , a CDC subscription is created or modified. The subscription will have the same name as the replication asset, and will have the replication asset ID as the subscription description. Both these elements create a link between the Data Replication service instance and its remote data plane CDC subscription.

All tables are mapped by using standard replication mapping, CDC replication method Mirror, and flagged for Refresh. The subscription is marked as a persistent subscription. All tables are initially refreshed, before transitioning to the Mirror/Active state. For more information about the process, see the following topics in CDC replication documentation:

• Mirroring in CDC
• Starting continuous mirroring in CDC
• Making CDC subscriptions persistent
• Starting a refresh on a CDC subscription

Pausing replication

Pausing a replication job by clicking on the Pause icon ends continuous replication of the remote data plane CDC subscription. For details, see Ending CDC replication.

All tables remain in Mirror/Active. When you resume replication, continuous replication continues from where it left off when it was paused.

Resuming replication

Resuming a replication job by clicking on the Resume icon starts continuous mirroring from where it left off when the job was paused.

Stopping replication

Stopping a replication job by clicking on the Stop icon ends continuous replication of the remote data plane CDC subscription as well as change the replication method for all tables to Refresh/Refresh. For more information about CDC replication methods, see Changing the CDC replication method of a table.

Re-synchronizing data

Stopping a replication job followed by starting the same job transitions all mapped tables through the following combination of replication methods and refreshes the tables:

1. Refresh/Refresh
2. Refresh/Mirror
3. Mirror/Active

After the table data is re-sychronized, continuous mirroring resumes.

Deleting a replication job

Deleting a replication job will delete the remote CDC subscription. The job must be stopped before deleting it.

Parent topic: Supported Data Replication connections