Scenario 1: Deleting data from the Account object in Salesforce – Docs for ESB 6.x
Scenario 1: Deleting data from the Account object in Salesforce 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. Document get from Talend https://help.talend.com Thank you for watching.
How to set schema for the guess query feature of tSalesforceInput – Docs for ESB 6.x
How to set schema for the guess query feature of tSalesforceInput tSalesforceInput allows you to generate SOQL queries, with both standard objects and fields and custom objects and fields, based on the defined module and schema. This section demonstrates how to set the module and schema when generating an SOQL query. There are two types…
Scenario 3: Inserting the Account ID values from an Excel File into the Salesforce Contact object – Docs for ESB 6.x
Scenario 3: Inserting the Account ID values from an Excel File into the Salesforce Contact object 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. Document get from Talend https://help.talend.com Thank you for watching.
Scenario: Recovering deleted data from the Salesforce server – Docs for ESB 6.x
Scenario: Recovering deleted data from the Salesforce server This scenario describes a two-component Job that collects the deleted account data over the past five days from the Salesforce server. Document get from Talend https://help.talend.com Thank you for watching.
Scenario: Extracting data from a Salesforce database using the SOQL query – Docs for ESB 6.x
Scenario: Extracting data from a Salesforce database using the SOQL query This scenario describes a two-component Job used to extract a specific set of data from an object in a Salesforce database. Document get from Talend https://help.talend.com Thank you for watching.
Scenario 4: Upserting the Contact object based on mapping relationships with the external IDs in the Account object – Docs for ESB 6.x
Scenario 4: Upserting the Contact object based on mapping relationships with the external IDs in the Account object This scenario upserts the records in the Contact object based on mapping (matching) against the external IDs in the Account object. Document get from Talend https://help.talend.com Thank you for watching.
Retrieving the external ID values from the Account object – Docs for ESB 6.x
Retrieving the external ID values from the Account object Double-click the first tSalesforceInput component to open its Basic settings view. 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…
Retrieving the emails from the Contact object – Docs for ESB 6.x
Retrieving the emails from the Contact object Double-click the second tSalesforceInput component to open its Basic settings view. 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…
Preparing the bulk loading file – Docs for ESB 6.x
Preparing the bulk loading file Double-click the tFileInputDelimited component to open its Basic settings view. In the File name/Stream field, browse to or enter the path to the input data file. In this example, it is D:/SalesforceAccount.txt. In the Header field, type in 1 to skip the header row in the beginning of the file….
Configuring the source Excel input – Docs for ESB 6.x
Configuring the source Excel input Double-click the tFileInputExcel component to open its Basic settings view. 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: Select…