PowerExchange for Salesforce User Guide for PowerCenter

10.5.9
- 10.5.8
- 10.5.7
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5.1
- 10.5
- 10.4.1
- 10.4.0

Back Next

Salesforce Targets

You can perform insert, update, delete, and upsert operations on a Salesforce target.

The PowerCenter Integration Service determines whether records are new, existing, or deleted based on the record ID. You can use the following types of IDs to identify records in Salesforce objects:

Salesforce ID. By default, Salesforce generates IDs for each new record.

External ID. External IDs are IDs that are generated outside of Salesforce. You cannot use external IDs to identify records for update or deletion from a Salesforce target.

You can also configure the PowerCenter Integration Service to replace existing values in a record in a Salesforce target with null values during an update or upsert operation. By default, the PowerCenter Integration Service does not replace existing values with null values.

Salesforce Sources and Targets

Time Zones for Salesforce Targets

Determining Possible Update Strategies for a Salesforce Target

Rules and Guidelines for the Salesforce Target Update Strategy

Handling Null Values in Update and Upsert Operations

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal