Scenario: Recovering deleted data from the Salesforce server - 6.1

Talend Open Studio for Big Data Components Reference Guide

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

This scenario describes a two-component Job that collects the deleted data over the past 5 days from the Salesforce server.

Setting up the Job

  1. Drop tSalesforceGetDeleted and tLogRow from the Palette onto the design workspace.

  2. Connect the two components together using a Row > Main connection.

Setting up the connection to the Salesforce server

  1. Double-click tSalesforceGetDeleted to display its Basic settings view and define the component properties.

  2. In the Salesforce WebService URL filed, use the by-default URL of the Salesforce Web service or enter the URL you want to access.

  3. In the Username and Password fields, enter your login and password for the Web service.

  4. From the Module list, select the object you want to access, Account in this example.

Setting the search condition

  1. From the Schema list, select Repository and then click the three-dot button to open a dialog box where you can select the repository schema you want to use for this component. If you have not defined your schema locally in the metadata, select Built-in from the Schema list and then click the three-dot button next to the Edit schema field to open the dialog box where you can set the schema manually.

  2. In the Start Date and End Date fields, enter respectively the start and end dates for collecting the deleted data using the following date format: "yyyy-MM-dd HH:mm:ss". You can collect deleted data over the past 30 days. In this example, we want to recover deleted data over the past 5 days.

Job execution

  1. Double-click tLogRow to display its Basic settings view and define the component properties.

  2. Click Sync columns to retrieve the schema from the preceding component.

  3. In the Mode area, select Vertical to display the results in a tabular form on the console.

  4. Press Ctrl+S to save your Job and press F6 to execute it.

    Deleted data collected by the tSalesforceGetDeleted component is displayed in a tabular form on the console.