How to set schema for generating the simple query - Cloud - 8.0

Salesforce

Version
Cloud
8.0
Language
English
Product
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 Real-Time Big Data Platform
Module
Talend Studio
Content
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
Last publication date
2024-03-21

This section demonstrates how to set the module name and schema columns for generating the simple query.

The following two simple query examples will be used for demonstration purpose in the following steps.

  • SELECT Id, Name, BillingCity FROM Account, a simple query with standard object and fields, and

  • SELECT Name__c, LastName__c FROM Mother__c, a simple query with custom object and fields.

Procedure

  1. Set the module name with the name of the object specified in the FROM clause, Account and Mother__c for above examples.
  2. Create a column for each field in the field list (separated by commas) after SELECT in the schema dialog box and set the column name with the field name.

    For the first example, you need to create three columns Id, Name, and BillingCity for the three fields.

    For the second example, you need to create two columns Name__c and LastName__c for the two fields.