Scenario 1: Deleting data from the Account object in Salesforce - 6.3

Talend Open Studio for Big Data Components Reference Guide

EnrichVersion
6.3
EnrichProdName
Talend Open Studio for Big Data
task
Data Governance
Data Quality and Preparation
Design and Development
EnrichPlatform
Talend Studio

This scenario describes a three-component Job that removes the record added into the Salesforce Account object in Scenario: Using OAuth2 to log in to Salesforce.com.

Setting up the Job

  1. Create a new Job and add a tSalesforceConnection component, a tSalesforceInput component and a tSalesforceOutput component by typing their names on the design workspace or dropping them from the Palette.

  2. Link the tSalesforceInput component to the tSalesforceOutput component using a Row > Main connection.

  3. Link the tSalesforceConnection component to the tSalesforceInput component using a Trigger > OnSubjobOk connection.

Configuring the components

  1. Double-click the tSalesforceConnection component to open its Basic settings view.

  2. In the User Id, Password and Security Key fields, enter the user authentication information required to access Salesforce.

  3. Double-click the tSalesforceInput component to open its Basic settings view.

  4. In the drop-down list next to the Property Type drop-down list, select the tSalesforceConnection component to reuse the connection created by it.

    Click the [...] button next to the Module Name field and in the pop-up dialog box, select the object you want to access. In this example, it is Account.

  5. In the Condition field, enter the condition expression used to filter the record to be deleted between double quotation marks. In this example, it is name='Talend', which is used to filter the account record whose name is Talend.

  6. Double-click the tSalesforceOutput component to open its Basic settings view.

  7. In the drop-down list next to the Property Type drop-down list, select the tSalesforceConnection component to reuse the connection created by it.

    Click the [...] button next to the Module Name field and in the pop-up dialog box, select the object you want to access. In this example, it is Account.

  8. From the Output Action drop-down list, select the operation to be carried out. In this example, select DELETE to delete the Talend account retrieved in the previous component.

Executing the Job

  1. Press Ctrl + S to save the Job.

  2. Press F6 to execute the Job.

  3. Go to the Salesforce.com and check the content of the Account object.

    As shown above, the Talend account has already been deleted from the server.