Rules and guidelines for configuring replication tasks
Rules and guidelines for configuring
replication
tasks
Consider the following rules and guidelines for configuring
replication
tasks:
The names of source tables and fields can contain at most 79 characters.
You cannot configure a
replication
task with the same source and target objects. If the source and target connections are the same, you must enter a target prefix to distinguish the source and target objects.
You cannot replicate data to a Salesforce target.
You cannot configure multiple
replication
tasks to replicate the same source object to the same target object. For example, you cannot configure two
replication
tasks to write Salesforce Account data to the SF_ACCOUNT Oracle database table.
You cannot simultaneously run multiple
replication
tasks that write to the same target table.
When you configure a
replication
task to run on a schedule, include a repeat frequency to replicate the data at regular intervals.
The index is generated based on the Salesforce ID field. Indexes are not generated for Salesforce sources that do not include a Salesforce ID field.
You cannot simultaneously run
replication
tasks that replicate the same Salesforce object. If you simultaneously run two
replication
tasks that replicate the same object, the
replication
task that starts first obtains a lock on the Salesforce object, and the other
replication
task fails with the following error:
replication
task failed to run.
replication
task name> is currently replicating the same objects.
If you configured the
replication
tasks to run on schedules, schedule the
replication
tasks to run at different times. If you run the
replication
tasks manually, wait until one completes before your run the other.
You can load data from Salesforce fields of any datatype, except binaries, into a flat file target.
There must be a time difference of at least 60 seconds between two consecutive runs of a
replication
task with incremental load.
To adjust the database target column when the data type, precision, or scale of a Salesforce source field changes, you can set the AutoAlterColumnType custom configuration property. Set this property for the Secure Agent that runs the replication task. In the Secure Agent properties, select the type as Tomcat and the subtype as INFO. Then, enter AutoAlterColumnType as the name and set its value to yes to turn on this property.