Data Replication Overview

A Data Replication task can replicate data from one or more Oracle objects. When you configure a task, you can replicate all available objects through the selected connection. You can also select objects for replication by including or excluding a set of objects. You can exclude rows and columns from the Data Replication task. Associate a schedule with a Data Replication task to specify when and how often the task runs.

When you replicate Oracle sources, you can replicate all current rows in the Oracle source. You can also replicate deleted and archived rows to preserve or analyze historical data. The names of source tables and fields can contain at most 30 characters.

For example, the Data Replication task creates a column name in an Oracle database based on the following 40-character field name:

The Data Replication task truncates the column name to the first 30 characters:

If the truncation causes duplicate column names, the Data Replication task replaces the last character of the duplicate column names with sequential numbers. The Data Replication task also replaces the last character of duplicate table names from the same task.

You cannot configure multiple Data Replication tasks to replicate the same source object to the same target object. For example, you cannot configure two Data Replication tasks to write Salesforce Account data to the SF_ACCOUNT Oracle database table.