Skip to main content

Data Integration: known issues and known limitations

Limitation

Description

Available in
Some SOQL queries are not supported for the guess schema and guess query features of tSalesforceInput.
  • the SOQL query using the aggregate function
  • the SOQL query using the TYPEOF expression
  • the SOQL query using alias
  • Some SOQL queries are not supported for the guess schema andthe prefix in the SOQL query is the same as the module name after FROM

    For example, SELECT Account.Name, (SELECT Contact.LastName FROM Account.Contacts) FROM Account is not supported, while SELECT Name, (SELECT LastName FROM Contacts) FROM Account that performs the same function is supported.

  • the SOQL query with multiple modules after FROM

    For example, SELECT Contact.Firstname, Account.Name FROM Contact,Contact.Account is not supported. However, the child-to-parent and parent-to-child relationship queries are supported, so this query can be improved to SELECT Firstname, Account.Name FROM Contact.

  • the SOQL query using toLabel()
  • the field with the underscore character '_' in its name

All Talend products
Java PSU is not supported. Talend is only supported on Java CPU Versions, not Java PSU.

Some users reported problems using Talend Studio with Java PSU versions (such as jdk8_u92), but when reverting to a Java CPU Version (such as jdk8_u91) the problem was resolved.

See also: http://www.oracle.com/technetwork/java/javase/cpu-psu-explained-2331472.html

All Talend products
Collation limitation with Access Since 6.0, the Access components in Talend Studio support only the General collation mode.

All Talend products
Stats or logs not supported with JDBC generic component for Teradata Stats or logs is not supported with JDBC generic component for Teradata. To store statistics and log data of a Job in a Teradata database, select Teradata from the Db Type drop-down list and provide related parameters for connecting the Teradata database as prompted in the Stats & Logs view of the Job. You can also make the setting globally effective by performing the same configuration in the Job Settings > Stats & Logs pane of the Project Settings dialog box. See the Stats & Logs section in Talend Studio user guide for related information.

All Talend products

tParallelize in the context of Routes and Data Services Jobs

The tParallelize component is designed for Data Integration Jobs. Do not use it in the context of Data Services Jobs or Routes because it is not thread safe between parallel requests and will cause huge memory and CPU consumption. Use a Route if parallel processing is a requirement.

All Talend products with ESB

Issue

Workaround

Available in
If Talend Administration Center works in clustered mode (two Talend Administration Center instances located on different physical servers but connected to the same database), context values may not be available in task execution details.Some SOQL queries are not supported for the guess schema and guess query features of tSalesforceInput. It is recommended to use shared folder in Job Conductor configuration which are available for all works in cluster mode

All Talend products except Talend ESB
Migrating database X to database Y Talend Administration Center database migration related to MetaServlet command migrateDatabase is not supported for now in 7.3.1 but will be supported shortly.

All Talend products except Talend ESB

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!

Leave your feedback here