These properties are used to configure tSalesforceOutput running
in the Standard Job framework.

The Standard
tSalesforceOutput component belongs to the Business and the Cloud families.

The component in this framework is available in all Talend
products.

Basic settings

Advanced settings

Global Variables

Usage

1. Create a new Job and add a tSalesforceConnection
   component, three tSalesforceInput components, four
   tSalesforceOutput components, three
   tFixedFlowInput components, and four
   tLogRow components.
2. Connect the first tSalesforceInput component to the
   first tSalelsforceOutput component using a Row > Main connection.
3. Do the same to connect the first tFixedFlowInput
   component to the second tSalesforceOutput component, the
   second tFixedFlowInput component to the third
   tSalesforceOutput component, the third
   tFixedFlowInput component to the fourth
   tSalesforceOutput component, the second
   tSalesforceInput component to the third
   tLogRow component, and the third
   tSalesforceInput component to the fourth
   tLogRow component.
4. Connect the third tSalesforceOutput component to the
   first tLogRow component using a Row > Main connection and to the second tLogRow
   component using a Row > Reject connection.
5. Connect the tSalesforceConnection component to the first
   tSalesforceInput component using a Trigger > On Subjob Ok connection.
6. Do the same to connect the first tSalesforceInput
   component to the first tFixedFlowInput component, the
   first tFixedFlowInput component to the second
   tFixedFlowInput component, the second
   tFixedFlowInput component to the third
   tFixedFlowInput component, the third
   tFixedFlowInput component to the second
   tSalesforceInput component, and the second
   tSalesforceInput component to the third
   tSalesforceInput component.

1. Double-click the tSalesforceConnection component to open
   its Basic settings view on the
   Component tab.
2. Select Basic from the Connection
   type drop-down list to connect to Salesforce using your
   Salesforce account username, password, and security token.

   In this example, you connect to Salesforce using the basic connection type.
   You can also connect to Salesforce using the OAuth JWT (JSON Web Token) Flow
   type. For more information, see the related description of how to
   connect to Salesforce using OAuth JWT Flow on Talend Help Center (https://help.talend.com).

3. In the User Id field, enter your Salesforce
   username.
4. Click the […] button next to the
   Password field and in the pop-up dialog box, enter
   your Salesforce password between double quotation marks.
5. Click the […] button next to the Security
   Token field and in the pop-up dialog box, enter your Salesforce
   security token between double quotation marks.

   You can use the Salesforce metadata wizard to create a connection to your
   Salesforce system, save the connection in the Repository, and then reuse the
   connection configuration defined in the metadata wizard in Salesforce
   components. For more information, see the related description of
   centralizing Salesforce metadata.

1. Double-click the first tSalesforceInput component to
   open its Basic settings view on the
   Component tab.
2. Select the component that will create the Salesforce connection from the
   Connection Component drop-down list,
   tSalesforceConnection_1 in this example.
3. Click the […] button next to the Module
   Name field and in the pop-up dialog box, select the object whose
   data will be deleted, Account in this example. The schema
   of the Account object will be automatically filled.
4. Click OK to save the changes and in the pop-up dialog
   box, click Yes to propagate the schema to the next
   tSalesforceOutput component.
5. Select Query from the Query Mode
   drop-down list and specify the condition used to filter data to be deleted. In
   this example, it is talendlena__Account_External_ID__c like
   '%talend%'.

   All Salesforce Account records whose
   talendlena__Account_External_ID__c field contains
   talend will be deleted.

6. Double-click the first tSalesforceOutput component to
   open its Basic settings view on the
   Component tab.
7. Select the component that will create the Salesforce connection from the
   Connection Component drop-down list,
   tSalesforceConnection_1 in this example.
8. Click the […] button next to the Module
   Name field and in the pop-up dialog box, select the object whose
   data will be deleted, Account in this example.
9. Select DELETE from the Output
   Action drop-down list to perform the delete operation on the
   Account objects filtered by the first tSalesforceInput
   component.

1. Double-click the second tSalesforceOutput component to
   open its Basic settings view on the
   Component tab.
2. Select the component that will create the Salesforce connection from the
   Connection Component drop-down list,
   tSalesforceConnection_1 in this example.
3. Click the […] button next to the Module
   Name field and in the pop-up dialog box, select the object into
   which data will be inserted, Account in this example. The
   schema of the Account object will be automatically filled.
4. Click the […] button next to Edit
   schema and in the pop-up dialog box, remove all schema columns
   except the two columns Name and
   talendlena__Account_External_ID__c. Then click to copy these two
   columns to the first tFixedFlowInput component. When
   done, click OK to close the dialog box.
5. Select INSERT from the Output
   Action drop-down list.
6. Double-click the first tFixedFlowInput component to open
   its Basic settings view on the
   Component tab.
   

7. In the Mode area, select Use Inline
   Table and in the table displayed, enter the data to be inserted
   into the Salesforce Accout object. In this example, the following two records
   will be inserted.
   account_talend;account_talend_exid account_talend_doc;account_talend_doc_exid

   1 2	account_talend;account_talend_exid account_talend_doc;account_talend_doc_exid

   You can also select Use Inline Content, and then copy
   and paste the input data into the Content field
   displayed.

1. Double-click the third tSalesforceOutput component to
   open its Basic settings view on the
   Component tab.
2. Select the component that will create the Salesforce connection from the
   Connection Component drop-down list,
   tSalesforceConnection_1 in this example.
3. Click the […] button next to the Module
   Name field and in the pop-up dialog box, select the object into
   which data will be inserted, Contact in this example. The
   schema of the Contact object will be automatically filled. When done, click
   OK to save the changes and in the pop-up dialog box,
   click Yes to propagate the schema to the next two
   tLogRow components.
4. Click the […] button next to Edit
   schema and in the pop-up dialog box, remove all schema columns
   except the three columns LastName,
   FirstName, and
   talendlena__Contact_Talend_ID__c. Then add another
   column Account_External_ID of String type and copy these
   four columns to the second tFixedFlowInput component.
   When done, click OK to close the dialog box and in the
   pop-up dialog box, click Yes to propagate the schema to
   the next two tLogRow components.
   

5. Select UPSERT from the Output
   Action drop-down list and
   talendlena__Contact_Talend_ID__c from the
   Upsert Key Column drop-down list displayed.
6. Go to the Advanced settings view and in the
   Relationship mapping for upsert table, specify the
   relationship mapping for the column Account_External_ID
   by adding one row and setting the value for each table column. In this example,
   the column Account_External_ID is mapped with the
   external ID field talendlena__Account_External_ID__c of
   the Account object, so the value for Column name of Talend
   Schema is Account_External_ID, the value
   for Lookup relationship field name and Module
   name is Account, and the value for
   External id name is
   talendlena__Account_External_ID__c.
   

7. Clear the Extend Insert and Die on
   Error check boxes so that erroneous data can be gathered via the Row > Reject connection.
8. Double-click the second tFixedFlowInput component to
   open its Basic settings view on the
   Component tab.
   

9. In the Mode area, select Use Inline
   Table and in the table displayed, enter the data to be inserted
   into the Salesforce Contact object. In this example, the input data is as
   follows.
   Beckham;David;2018010001;account_talend_exid Taylor;Swift;2018010002;account_talend_exid ;;2018010003;account_talend_exid

   1 2 3

   Beckham;David;2018010001;account_talend_exid Taylor;Swift;2018010002;account_talend_exid ;;2018010003;account_talend_exid

   You can also select Use Inline Content, and then copy
   and paste the input data into the Content field
   displayed.

10. Double-click the first tLogRow component and on its
    Basic settings view, select
    Table in the Mode area to
    display the result in a table.
11. Do the same to configure the second tLogRow
    component.

1. Double-click the fourth tSalesforceOutput component to
   open its Basic settings view on the
   Component tab.
2. Select the component that will create the Salesforce connection from the
   Connection Component drop-down list,
   tSalesforceConnection_1 in this example.
3. Click the […] button next to the Module
   Name field and in the pop-up dialog box, select the object into
   which data will be inserted, Contact in this example. The
   schema of the Contact object will be automatically filled.
4. Click the […] button next to Edit
   schema and in the pop-up dialog box, remove all schema columns
   except the three columns Phone,
   Email, and
   talendlena__Contact_Talend_ID__c. Then add another
   column Account_External_ID of String type and copy these
   four columns to the second tFixedFlowInput component.
   When done, click OK to close the dialog box.
5. Select UPSERT from the Output
   Action drop-down list and
   talendlena__Contact_Talend_ID__c from the
   Upsert Key Column drop-down list displayed.
6. Go to the Advanced settings view and in the
   Relationship mapping for upsert table, specify the
   relationship mapping for the column Account_External_ID
   by adding one row and setting the value for each table column. In this example,
   the column Account_External_ID is mapped with the
   external ID field talendlena__Account_External_ID__c of
   the Account object, so the value for Column name of Talend
   Schema is Account_External_ID, the value
   for Lookup relationship field name and Module
   name is Account, and the value for
   External id name is
   talendlena__Account_External_ID__c.
7. Double-click the third tFixedFlowInput component to open
   its Basic settings view on the
   Component tab.
   

8. In the Mode area, select Use Inline
   Table and in the table displayed, enter the data used to update
   the two records inserted into the Salesforce Contact object. In this example,
   the updated data is as follows. The phone and email values will be added for
   both two records and the Account external ID value for the second record is
   updated to account_talend_doc_exid.
   +86 13666666666;beckham.david@talend.com;2018010001;account_talend_exid +86 13888888888;taylor.swift@talend.com;2018010002;account_talend_doc_exid

   1 2	+86 13666666666;beckham.david@talend.com;2018010001;account_talend_exid +86 13888888888;taylor.swift@talend.com;2018010002;account_talend_doc_exid

   You can also select Use Inline Content, and then copy
   and paste the input data into the Content field
   displayed.

1. Double-click the second tSalesforceInput component to
   open its Basic settings view on the
   Component tab.
2. Select the component that will create the Salesforce connection from the
   Connection Component drop-down list,
   tSalesforceConnection_1 in this example.
3. Click the […] button next to the Module
   Name field and in the pop-up dialog box, select the object from
   which data will be retrieved, Account in this example.
   The schema of the Account object will be automatically filled.
4. Click the […] button next to Edit
   schema and in the pop-up dialog box, remove all schema columns
   except the three columns Id, Name,
   and talendlena__Account_External_ID__c. When done, click
   OK to save the changes and in the pop-up dialog box,
   click Yes to propagate the schema to the next
   tLogRow component.
5. Select Query from the Query Mode
   drop-down list and specify the condition used to filter data to be retrieved. In
   this example, it is Name like '%talend%'.

   All Salesforce Account records whose Name field
   contains talend will be retrieved.

6. Double-click the third tLogRow component and on its
   Basic settings view, select
   Table in the Mode area to
   display the result in a table.

1. Double-click the third tSalesforceInput component to
   open its Basic settings view on the
   Component tab.
2. Select the component that will create the Salesforce connection from the
   Connection Component drop-down list,
   tSalesforceConnection_1 in this example.
3. Click the […] button next to the Module
   Name field and in the pop-up dialog box, select the object from
   which data will be retrieved, Contact in this example.
   The schema of the Contact object will be automatically filled.
4. Click the […] button next to Edit
   schema and in the pop-up dialog box, remove all schema columns
   except the four columns Name,
   Phone, Email, and
   talendlena__Contact_Talend_ID__c.
   

5. Add another two columns to retrieve name and external ID of the linked Account
   object, Contact_Account_Name and
   Contact_Account_talendlena__Account_External_ID__c in
   this example.

   To retrieve data of a linked object column, it is necessary to define the
   name of the column in a particular manner in the schema editor. The correct
   syntax is NameofCurrentObject_NameofLinkedObject_NameofColumnofInterest.
   If this syntax is not respected, data from the linked object will not be
   returned. For more information about how to set schema for the relationship
   query, see How to set schema for the guess query feature of tSalesforceInput.

6. Click OK to save the changes. In the pop-up dialog box,
   click Yes to propagate the schema to the next
   tLogRow component.
7. Select Query from the Query Mode
   drop-down list.
8. Select the Manual Query check box and click the
   Guess query button to generate the SOQL query based
   on the defined module name and schema columns. The generated SOQL query will
   look like below.
   SELECT Name, Phone, Email, talendlena__Contact_Talend_ID__c, Contact.Account.Name, Contact_Account_talendlena__Account_External_ID__c FROM Contact

   1 2	SELECT Name, Phone, Email, talendlena__Contact_Talend_ID__c, Contact.Account.Name, Contact_Account_talendlena__Account_External_ID__c FROM Contact

9. In the generated SOQL query string, replace each underscore character after the
   object name in the column name
   Contact_Account_talendlena__Account_External_ID__c
   with a dot character. Then add the WHERE condition clause used to filter data to
   be retrieved at the end of the generated SOQL query. In this example, it is
   talendlena__Contact_Talend_ID__c like '201801%' and
   all Salesforce Contact records whose
   talendlena__Contact_Talend_ID__c field begins with
   201801 will be retrieved. The updated SOQL query will
   look like below.
   SELECT Name, Phone, Email, talendlena__Contact_Talend_ID__c, Contact.Account.Name, Contact.Account.talendlena__Account_External_ID__c FROM Contact WHERE talendlena__Contact_Talend_ID__c like '201801%'

   1 2 3

   SELECT Name, Phone, Email, talendlena__Contact_Talend_ID__c, Contact.Account.Name, Contact.Account.talendlena__Account_External_ID__c FROM Contact WHERE talendlena__Contact_Talend_ID__c like '201801%'

10. Double-click the fourth tLogRow component and on its
    Basic settings view, select
    Table in the Mode area to
    display the result in a table.

1. Press Ctrl + S to save your Job.
2. Press F6 to execute your Job.
   

   As shown above, two Account records account_talend and
   account_talend_doc are successfully inserted, two
   Contact records Beckham David and Taylor
   Swift are successfully inserted and updated based on the
   mapping relationship with the external IDs in the Account object, and
   another Contact record missing the value for the required field
   LastName is not inserted.

   You can also go to the Salesforce website to double-check the Job execution
   result.