Creating a Configuration for Replicating Data to Multiple Targets
Creating a Configuration for Replicating Data to Multiple Targets
From the Informatica Data Replication Console, you can create a configuration that replicates data to multiple targets.
Data Replication does not support replicating data from a single source to multiple Amazon Redshift
or Apache Kafka targets.
On the
Target Database
tab, select the connection that you previously defined for the primary target on the
Server Manager
tab >
Connections
view. Then add the secondary targets on the
Routing
tab.
Instead of creating a new configuration, you can modify an existing configuration file that has a single target. In this case, you must rename the target schema for each secondary target to a name that matches the schema name of the primary target.
In the
Server Manager
tab >
Configs
view, click
New
on the main toolbar.
On the
Source Database
tab, connect to the source database.
On the
Target Database
tab, in the
Connections
list, select the connection that you defined for the primary target.
Map tables and columns, set the extract range, and enter runtime and logging settings, as usual.
Save the configuration and switch to
Edit
mode.
The
Routing
tab becomes available.
On the
Routing
tab, specify the Server Manager subserver and connection for a secondary target:
Click
New
.
In the
New
dialog box, select the Server Manager subserver and database connection that you previously defined for the target.
Click
OK
.
The target appears in the upper list box on the
Routing
tab.
The following image shows the
Routing
tab with the secondary target:
If the target type uses a recovery table, the Data Replication Console prompts you to specify the recovery table name and schema.
To define a recovery table for a target, enter the schema name and recovery table name in the appropriate fields. Then click
OK
.
When you start the Applier later, it generates the recovery table on the target.
Create a separate recovery table for each target.
Repeat Step 6 for each secondary target. For each secondary target that uses a recovery table, also repeat Step 7.
From the subtabs on the
Routing
tab, you can filter table rows, exclude tables, and override the apply mode and log table schema for a secondary target.