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

Salesforce Sources in Mapping Tasks

Salesforce Sources in Mapping Tasks

For Salesforce source connections used in template-based
mapping
tasks, you can configure advanced properties in the Sources page of the
Mapping
Task wizard.
You can configure the following properties:
Property
Description
Connection
Name of the source connection.
Source Type
Type of the source connection. Select Single, Multiple, or Query.
Source Object
Name of the source object. You can define a custom query to use as the source object.
Query Options
You can choose from the following options:
  • Filter. Filter condition filters data in Salesforce. Configure a simple or an advanced filter. You cannot use the LIMIT clause in an advanced filter. To limit the number of rows, specify the row limit in the advanced source properties
  • Display technical names instead of labels. Displays technical names instead of business names.
  • Display source fields in alphabetical order. Displays source fields in alphabetical order instead of the order returned by the source system.
Related Objects
Includes related objects in the task. You can join objects with existing relationships for Salesforce connection type.
You can configure the following advanced properties:
Property
Description
SOQL Filter Condition
Enter a filter condition to filter Salesforce source records. You cannot use the LIMIT clause in the filter condition. To limit the number of rows, specify the row limit in the advanced source properties.
If you configure the filter under Query Options as well as the SOQL Filter Condition, the SOQL Filter Condition overrides the filter under Query Options.
CDC Time Limit
Time period, in seconds, that the agent reads changed Salesforce data. When you set the CDC Time Limit to a non-zero value, the agent performs a full initial read of the source data and then captures changes to the Salesforce data for the time period you specify. Set the value to -1 to capture changed data for an infinite period of time. Default is 0.
Flush Interval
Interval, in seconds, at which the agent captures changed Salesforce data. Default is 300. If you set the CDC Time Limit to a non-zero value, the agent captures changed data from the source every 300 seconds. Otherwise, the agent ignores this value.
CDC Start Timestamp
Start date and time for the time period. The agent extracts data added or modified after this time. Must be in the format YYYY-MM-DDTHH:MI:SS.SSSZ. You can also use the $Paramstart mapping variable in a parameter file to specify the CDC start time.
CDC End Timestamp
End date and time for the time period. The agent extracts data added or modified before this time. Must be in the format YYYY-MM-DDTHH:MI:SS.SSSZ. You can also use the $Paramend mapping variable in a parameter file to specify the CDC end time.
Row Limit
The maximum number of rows the agent processes. Default is 0. The default value indicates that there is no row limit, and the agent processes all records.
Use queryAll
Runs a query that returns all rows, including active, archived, and deleted rows that are available in the recycle bin. Otherwise, the agent returns active rows.
The Use queryAll property for Bulk API is available for Salesforce API version 39.0 and later. The Secure Agent ignores this property when you configure the session to perform change data capture.
Use SystemModstamp for CDC
Uses the SystemModstamp as the time stamp for changed records in Salesforce. Otherwise, the agent uses the LastModifiedDate time stamp to identify changed records in Salesforce. Default is to use the LastModifiedDate time stamp.
Enable Bulk Query
Uses the Salesforce Bulk API to read Salesforce source data.
By default, the Secure Agent uses the standard Salesforce API.
Enable Bulk 2.0 Query
Uses the Salesforce Bulk API 2.0 to read large amount of data from Salesforce.
You must configure only one CDC time attribute, either CDC Time Limit or CDC Start and End Timestamp. If you configure both attributes, you might encounter unexpected results.

0 COMMENTS

We’d like to hear from you!