Hi, I'm Ask INFA!
What would you like to know?
ASK INFAPreview
Please to access Ask INFA.

Table of Contents

Search

  1. Preface
  2. Introduction to Salesforce Connector
  3. Connections for Salesforce
  4. Synchronization tasks with Salesforce
  5. Mappings and mapping tasks with Salesforce
  6. Replication tasks with Salesforce
  7. Masking tasks with Salesforce
  8. Common configuration
  9. Troubleshooting
  10. Appendix A: Data type reference

Salesforce Connector

Salesforce Connector

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.

0 COMMENTS

We’d like to hear from you!