Transform replication data

Rversion finale: Australia

Mis à jour 12 mars 2026

3 minutes de lecture

Transform producer instance data for tables or table columns that are named differently on consumer instances in Instance Data Replication (IDR).

Avant de commencer

Create and activate a producer replication set.
Create, activate, and seed one or more consumer replication sets.
Role required: idr_admin or admin

Pourquoi et quand exécuter cette tâche

The replicated data from producer tables and table columns goes into tables and table columns of the same name on consumer instances. You can map the producer data into any table or table column on consumer instances. If existing tables or table columns have different names, you can replicate the data to a different table or table column. Adapters modify the data before storing it on consumer instances. For example, adapters can localize data from the producer instance before it is consumed by the consumer instance.

You can also use adapters to modify the producer data during replication. For example, you can localize the data or populate the data that has been labeled differently in consumer tables.

Transformations have the following limitations:

sys_created, sys_created_by, sys_domain, sys_updated_by, sys_id, sys_mod_count, and other systems are automatically mapped to the consumer and can't be remapped.
No other sys_ fields can be replicated.
Adapters can't operate on the sys_journal field type such as Comments or Worknotes columns in a Task table.
Calculated fields won't be transformed.
A calculated field, such as the name field from sys_user, will replicate but cannot be transformed. Allowing a transformation breaks the calculation for the resulting field.
Remarque :
Calculated fields will not show as an option to transform.

Procédure

Choose a producer or consumer instance and navigate to the replication set.

Option	Description
Consumer Instance	Navigate to Instance Data Replication > Consumer Replication Sets and click a consumer replication set.
Producer instance	Navigate to Instance Data Replication > Producer Replication Sets and click a producer replication set.

Choose an inbound or outbound entry.

Option	Description
Consumer Instance	On the Inbound Entries tab, click an inbound entry.
Producer instance	On the Outbound Entries tab, click an outbound entry.

An entry appears.

Select the Enable Transform option.
In the Target Table Name list, select the table into which you want to replicate the source table data and click Update.
On the Inbound Entries or the Outbound Entries tab, click the same entry.
Click the lock icon next to Transform Map to unlock it.
The image shows a Transform Map, with the field names from the source table appearing in the left column. The middle column shows matching field names in the target table. All fields that do not have the same names in both tables appear in the – choose source field – or – choose target field – lists.

Remarque :
If a table in a producer replication set is not on a consumer instance, the consumer instance will fill the first column with the producer schema definition sent during synchronization.
Map a producer column to a consumer column that has a different name:
1. Click – choose source field – and select the source field that you want to map.
2. Click – choose target field –, select the target field into which you want to map the data, and then click Add.
3. If you want to remove a field from replicating the producer instance to the consumer instance, click the X at the end of the row to delete the field.
To modify the producer data before replicating it in the consumer instance, click Add Adapter.
The image shows the type of Adapter rules that you can create.
Click the adapter that you want to use and then configure it.
For more information about configuring adapters, see Adapter descriptions.
Remarque :
Adapters do not modify the data on the producer instance.