Scenario 2: Gathering erroneous data while inserting data to a module at Salesforce.com - 6.1

Talend Components Reference Guide

EnrichVersion
6.1
EnrichProdName
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Open Studio for Big Data
Talend Open Studio for Data Integration
Talend Open Studio for Data Quality
Talend Open Studio for ESB
Talend Open Studio for MDM
Talend Real-Time Big Data Platform
task
Data Governance
Data Quality and Preparation
Design and Development
EnrichPlatform
Talend Studio

In this scenario, data in a local file is inserted to the AdditionalNumber module. Meanwhile, erroneous data in that file is collected via a Row > Reject link.

Dragging and dropping components and linking them together

  1. Drag and drop the following components from the Palette onto the workspace: tFileInputDelimited, tSalesforceOutput and two tLogRow components.

  2. Rename tFileInputDelimited as DataToInsert, tSalesforceOutput as InsertToSalesforce, and the two tLogRow components as DataInserted as well as DataRejected respectively.

  3. Link DataToInsert to InsertToSalesforce using a Row > Main connection.

  4. Link InsertToSalesforce to DataInserted using a Row > Main connection.

  5. Link InsertToSalesforce to DataRejected using a Row > Reject connection.

    Note

    Deselect the Extended Output and Die on error check boxes in the Advanced settings view of the tSalesforceOutput component so that the Reject link is available .

Configuring the components

Configuring the data source

  1. Double-click DataToInsert to open its Basic settings view in the Component tab.

  2. In the Property Type drop-down list, select Built-In.

    Note

    You can select Repository from the Property Type drop-down list to fill in the relevant fields automatically if the relevant metadata has been stored in the Repository. For more information about Metadata, see the Talend Studio User Guide.

  3. In the File name/Stream field, type in the path of the source file, for example, E:/salesforceout.csv.

  4. In the Header field, type in 1 to retrieve the column names. Keep the default settings for other fields.

Configuring the module for data insertion

  1. Double-click InsertToSalesforce to open its Basic settings view in the Component tab.

  2. In the Username field, enter your username, for example, cantoine@talend.com.

  3. In the Password field, enter your password, for example, talendehmrEvHz2xZ8f2KlmTCymS0XU.

  4. In the Action drop-down list, select insert.

  5. In the Module drop-down list, select AdditionalNumber.

    Note

    When linking the components earlier, the Extended Output and Die on error check boxes have been deselected in the Advanced settings view so that the Reject link can appear.

  6. Keep the default settings for other fields.

Configuring the console display

  1. Double-click DataInserted to open its Basic settings view in the Component tab.

  2. In the Mode area, select Table (print values in cells of a table) for a better view.

  3. Perform the same operation for DataRejected.

  4. Press Ctrl+S to save your Job.

Executing the Job

  • Press F6 to run the Job and you can find the erroneous data (if any) is displayed in the Run view.

    As shown above, there are two Call Center ID fields that have incorrect data.