How to set schema for generating the simple query - 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

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.