Scenario 3: Inserting the Account ID values from an Excel File into the Salesforce Contact object - 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

In this scenario, the Account ID values from an Excel file are inserted into the Salesforce Contact object based on the matching of the LastName and Name fields.

Setting up the Job

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

  2. Link the tFileInputExcel component to the tMap component using a Row > Main connection.

  3. Link the tSalesforceInput component to the tMap component using a Row > Main connection. The connection is automatically changed to a Lookup flow.

  4. Link the tMap component to the tSalesforceOutput component using a Row > *New Output* (Main) connection. In the pop-up dialog box, enter the name of the output connection. In this example, it is out.

Configuring the components

Configuring the source Excel input

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

  2. In the File name/Stream field, browse to or enter the path to the Excel file that contains the Account ID data to be inserted. In this example, it is D:/AccountIdInput.xls. And the content of the file is as follows:

  3. Select the All sheets check box to retrieve the data of the entire Excel file.

  4. In the Header field, enter 1 to skip one row in the beginning of the file.

  5. Click the [...] button next to Edit schema and in the pop-up schema dialog box, define the schema by adding three columns AccountId, LastName and Name of String type.

    Click OK to save the settings and close the dialog box.

Configuring the destination object and the desired operation

  1. Double-click the tSalesforceOutput 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. 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 Contact.

Configuring the lookup source and establishing the mapping relations

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