You can replicate Salesforce data to a target using the

replication

task. You might replicate data to back up the data or perform offline reporting. You can replicate data in Salesforce objects to databases or flat files.

A

replication

task can replicate data from one or more Salesforce objects. When you configure the task, you can replicate all available objects through the selected connection, or you can select objects for replication by including or excluding a set of objects. You can also exclude rows and columns from the

replication

task. Associate a schedule with a

replication

task to specify when and how often the task runs.

When you replicate Salesforce sources, you can replicate all current rows in the Salesforce source. You can also replicate deleted and archived rows to preserve or analyze historical data.

When you replicate Salesforce sources to target database tables that do not yet exist, the

replication

task generates a non-unique index for each target table. The

replication

task also generates an index when you replicate Salesforce sources to target database tables when you use the

Create Target

option in the

Replication

Task wizard.