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 lookup objects in mappings

Salesforce lookup objects in mappings

You can retrieve data from a Salesforce lookup object based on the specified lookup condition.
When you configure a lookup in Salesforce, you select the lookup connection and lookup object. You also define the behavior when a lookup condition returns more than one match.
Salesforce lookup works only with the Salesforce Standard API.
For an uncached lookup, you cannot configure logical operators, such as <, >, <=, and >= in the lookup condition.
You can parameterize the Salesforce lookup objects at run time with values specified in a parameter file in a mapping.
The following table describes the Salesforce lookup object properties that you can configure in a Lookup transformation:
Property
Description
Connection
Name of the lookup connection.
Object Type
Type of the lookup object. Select one of the following object types:
  • Single Object
  • Query
  • Parameter
Default is Single Object.
Lookup Object
Name of the lookup object for the mapping.
Parameter
This property appears only if you select parameter as the object type.
A placeholder to dynamically assign values at run time for the lookup object without the requirement to edit the task.
Select an existing parameter for the lookup object or click
New Parameter
to define a new parameter for the lookup object.
To overwrite the parameter at run time, select the
Allow parameter to be overridden at run time
option.
Multiple Matches
Behavior when the lookup condition returns multiple matches. You can return first row, last row, any row, all rows, or report an error.
If you choose all rows and there are multiple matches, the Lookup transformation is an active transformation. If you choose any row, the first row, or the last row and there are multiple matches, the Lookup transformation is a passive transformation.
The Data Integration service uses case sensitive approach when performing lookups. For Salesforce lookups, the case sensitive comparison depends on the Salesforce support.

0 COMMENTS

We’d like to hear from you!