August 15, 2023

Configuring the lookup source and establishing the mapping relations – Docs for ESB 6.x

  2. Talend for ESB Docs
  3. Docs 6.x
  4. Configuring the lookup source and establishing the mapping relations – Docs for ESB 6.x

Configuring the lookup source and establishing the mapping relations

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

    use_case_tsalesforceoutput_14.png

  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.

    Click OK to save the settings and close the
    dialog box. In the pop-up dialog box, click Yes
    to propagate the schema to the next component.
  4. Double-click the tMap component to open its
    map editor.

    use_case_tsalesforceoutput_13.png

  5. Select the LastName column from the
    row1 table and drop it to its counterpart
    column in the row2 table.

    Do the same to drop the Name column in the
    row1 table to its counterpart column in
    the row2 table.
    This way, the data from the Excel file will be checked against their
    counterparts in the Contact object.
  6. Select the AccountId column from the
    row1 table and drop it to its counterpart
    column in the out table.

    Do the same to drop the LastName column in
    the row1 table to its counterpart column in
    the out table.
    This way, qualified data from the Excel file will be passed to their
    counterpart fields in the out table.
  7. Click OK to close the map editor.
Document get from Talend https://help.talend.com
Thank you for watching.
Docs 6.x
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x