Salesforce Delete

The Salesforce Delete step deletes records from Salesforce using the Salesforce web service.

You can delete a batch of records by specifying:

• a starting field that contains the Salesforce ID (Fieldname id)

• the number of records to delete (Batch size)

See also

• Salesforce Input

• Salesforce Insert

• Salesforce Update

• Salesforce Upsert

General

• Step name: Specify the unique name of the Salesforce Delete step on the canvas. You can customize the name or leave it as the default.

Connection

Option	Description
Salesforce webservice URL	URL of the Salesforce web service. The URL depends on the Salesforce API version used by PDI.
Username	User name for authenticating to Salesforce (for example, [email protected]).
Password	Password followed by your security token. For example, if password is PASSWORD and token is TOKEN, enter PASSWORDTOKEN.
Test connection	Verifies that the connection can be made using the configured settings.

Delete settings

Option	Description
Time out	Timeout in milliseconds. Default is 60000.
Use compression	Select to use .gzip compression between PDI and Salesforce.
Rollback all changes on error	Select to roll back changes unless all records process successfully. If selected, records with errors are marked as failed in the results. If cleared, partial success is allowed.
Batch size	Number of records to delete per batch. Default is 10.
Module	Salesforce object/module to delete from (default is Account). This list is populated after a successful Test connection.
Fieldname id	Incoming field that contains the Salesforce ID for records to delete. This list is populated with fields from previous steps (for example, Salesforce Input).

Metadata injection support

All fields of this step support metadata injection. You can use this step with ETL metadata injection to pass metadata to your transformation at runtime.