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.