Data Integration Connectors
- Data Integration Connectors
- All Products
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:
|
Related Objects
| Includes related objects in the task. You can join objects with existing relationships for Salesforce connection type.
|
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.
|