How to set schema for the guess query feature of tSalesforceInput - 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
tSalesforceInput allows you to generate SOQL queries, with both standard objects and fields and custom objects and fields, based on the defined module and schema. This section demonstrates how to set the module and schema when generating an SOQL query.

There are two types of SOQL queries: simple query and relationship query.

Simple query retrieves data from only one object. For more information about how to set the module and schema for generating simple queries, see How to set schema for generating the simple query.

Relationship query retrieves data from more than a single type of object, including child-to-parent and parent-to-child relationship queries.

For more information about how to set the module and schema for generating child-to-parent relationship queries, see How to set schema for generating the child-to-parent relationship query.

For more information about how to set the module and schema for generating parent-to-child relationship queries, see How to set schema for generating the parent-to-child relationship query.

Note that before setting the module name and schema columns for generating the relationship query in the Basic settings view of tSalesforceInput, you need to first identify the relationship type (child-to-parent or parent-to-child) of the query to be generated, because the methods of setting the schema column names for these two kinds of relationship queries are somewhat different. The main difference between the child-to-parent and parent-to-child relationship queries is that the parent-to-child relationship query is specified by using the subquery enclosed in parentheses, while the child-to-parent relationship query is not. For more information about the relationship queries in SOQL and how to identify the relationship queries, see Relationship Queries.