Configuring the lookup source and establishing the mapping relations - 6.4

Salesforce

author
Talend Documentation Team
EnrichVersion
6.4
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 ESB
Talend Open Studio for MDM
Talend Real-Time Big Data Platform
task
Data Governance > Third-party systems > Business applications > Salesforce components
Data Quality and Preparation > Third-party systems > Business applications > Salesforce components
Design and Development > Third-party systems > Business applications > Salesforce components
EnrichPlatform
Talend Studio

Procedure

  1. Double-click the tSalesforceInput component to open its Basic settings view.
  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.
  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.