# Data Integration: new features

| Feature | Description | Available in |
| --- | --- | --- |
| Online help for components on pressing F1 | Starting from Talend 7.3, by default, pressing F1 on a component will<br>open the relevant documentation on Talend Help Center using the<br>default Web browser.<br><br>To switch to offline help, go to Window &gt; Preferences &gt; Talend &gt; Components and clear the Enable online<br>help for components check box.<br><br>Before using offline help,<br>subscription users need to install the Talend Help package by following<br>the instructions when switching to offline help, or going to<br>Help &gt; Install Additional Packages.<br><br>![](https://help.qlik.com/talend/en-US/release-notes/Resources/images/release_notes_studio_online_help.png) | <ul>Available in:<li>Big Data</li><li>Big Data Platform</li><li>Cloud API Services Platform</li><li>Cloud Big Data</li><li>Cloud Big Data Platform</li><li>Cloud Data Fabric</li><li>Cloud Data Integration</li><li>Cloud Data Management Platform</li><li>Data Fabric</li><li>Data Integration</li><li>Data Management Platform</li><li>Data Services Platform</li><li>ESB</li><li>MDM Platform</li><li>Real-Time Big Data Platform</li></ul><br><br>All Talend<br>products |
| Rotating encryption keys | Talend Studio now allows you to rotate the following two<br>encryption keys by adding a new version of the key with an empty value<br>in the encryption key configuration file.<br><br><ul> <li>the system encryption key: for encrypting                                properties and nexus passwords</li> <li>the routine encryption key: for encrypting                                passwords of generated Jobs</li> </ul><br><br>![](https://help.qlik.com/talend/en-US/release-notes/Resources/images/release_notes_studio_rotate_encryption_keys.png) | <ul>Available in:<li>Big Data</li><li>Big Data Platform</li><li>Cloud API Services Platform</li><li>Cloud Big Data</li><li>Cloud Big Data Platform</li><li>Cloud Data Fabric</li><li>Cloud Data Integration</li><li>Cloud Data Management Platform</li><li>Data Fabric</li><li>Data Integration</li><li>Data Management Platform</li><li>Data Services Platform</li><li>ESB</li><li>MDM Platform</li><li>Real-Time Big Data Platform</li></ul><br><br>All Talend products<br>with Talend Studio |
| New update mechanism | Talend Studio has improved the patch mechanism to handle<br>monthly updates. You will be able to apply cumulative patches for bug<br>fixes, new components, and new features provided by Talend.<br><br>After your administrator accepts a patch for Talend Studio in Talend Administration Center, Talend Studio will detect the<br>new update automatically when opening a remote project.<br><br>Note that all Talend Studio clients connected to the same project must<br>install the same patch. Otherwise, you cannot connect to the project<br>successfully. | <ul>Available in:<li>Big Data</li><li>Big Data Platform</li><li>Cloud API Services Platform</li><li>Cloud Big Data</li><li>Cloud Big Data Platform</li><li>Cloud Data Fabric</li><li>Cloud Data Integration</li><li>Cloud Data Management Platform</li><li>Data Fabric</li><li>Data Integration</li><li>Data Management Platform</li><li>Data Services Platform</li><li>ESB</li><li>MDM Platform</li><li>Real-Time Big Data Platform</li></ul><br><br>All Talend products<br>with Talend Studio |
| Log4j 2 support | Talend Studio now supports Apache logging utility Log4j 2 in<br>components and allows you to enable or disable Log4j 2 loggers and<br>customize the configuration globally for the project.<br><br>![](https://help.qlik.com/talend/en-US/release-notes/Resources/images/release_notes_studio_log4j.png)<br><br>Information noteNote: If you need to deploy your Jobs to Talend Cloud, the<br>use of Log4j 2 requires Talend Remote Engine 2.8.1 or higher. Otherwise, no log will<br>be shown for those Jobs with Log4j 2 enabled. | <ul>Available in:<li>Big Data</li><li>Big Data Platform</li><li>Cloud API Services Platform</li><li>Cloud Big Data</li><li>Cloud Big Data Platform</li><li>Cloud Data Fabric</li><li>Cloud Data Integration</li><li>Cloud Data Management Platform</li><li>Data Fabric</li><li>Data Integration</li><li>Data Management Platform</li><li>Data Services Platform</li><li>ESB</li><li>MDM Platform</li><li>Real-Time Big Data Platform</li></ul><br><br>All Talend<br>products |
| Nexus Proxy settings | Talend Studio now allows you to configure a proxy for your<br>artifact repository in the General &gt; Artifact Proxy Setting view in the Project<br>Settings dialog box if you are using a supported version<br>of artifact repository instead of Talend Artifact Repository embedded with<br>your Talend<br>product.<br><br>![](https://help.qlik.com/talend/en-US/release-notes/Resources/images/release_notes_studio_nexus_proxy.png) | <ul>Available in:<li>Big Data</li><li>Big Data Platform</li><li>Cloud API Services Platform</li><li>Cloud Big Data</li><li>Cloud Big Data Platform</li><li>Cloud Data Fabric</li><li>Cloud Data Integration</li><li>Cloud Data Management Platform</li><li>Data Fabric</li><li>Data Integration</li><li>Data Management Platform</li><li>Data Services Platform</li><li>ESB</li><li>MDM Platform</li><li>Real-Time Big Data Platform</li></ul><br><br>All Talend products<br>with Talend Studio |
| Redshift SSO support with Ping Federate in metadata<br>wizard | The Login and<br>Password fields have been<br>added in the Database Connection<br>metadata wizard for Redshift SSO.<br><br>![](https://help.qlik.com/talend/en-US/release-notes/Resources/images/release_notes_studio_redshift_sso_in_wizard.png) | <ul>Available in:<li>Big Data</li><li>Big Data Platform</li><li>Cloud API Services Platform</li><li>Cloud Big Data</li><li>Cloud Big Data Platform</li><li>Cloud Data Fabric</li><li>Cloud Data Integration</li><li>Cloud Data Management Platform</li><li>Data Fabric</li><li>Data Integration</li><li>Data Management Platform</li><li>Data Services Platform</li><li>ESB</li><li>MDM Platform</li><li>Real-Time Big Data Platform</li></ul><br><br>All Talend<br>products |
| Metadata Bridge version upgrade | The version of Talend Metadata Bridge has been updated to 10.1. | <ul>Available in:<li>Big Data</li><li>Big Data Platform</li><li>Cloud API Services Platform</li><li>Cloud Big Data</li><li>Cloud Big Data Platform</li><li>Cloud Data Fabric</li><li>Cloud Data Integration</li><li>Cloud Data Management Platform</li><li>Data Fabric</li><li>Data Integration</li><li>Data Management Platform</li><li>Data Services Platform</li><li>ESB</li><li>MDM Platform</li><li>Real-Time Big Data Platform</li></ul><br><br>All Talend products<br>with Talend Studio |
| New components available | Two new components are now available: tSnowflakeCommit<br>and tSnowflakeRollback. | <ul>Available in:<li>Big Data</li><li>Big Data Platform</li><li>Cloud API Services Platform</li><li>Cloud Big Data</li><li>Cloud Big Data Platform</li><li>Cloud Data Fabric</li><li>Cloud Data Integration</li><li>Cloud Data Management Platform</li><li>Data Fabric</li><li>Data Integration</li><li>Data Management Platform</li><li>Data Services Platform</li><li>ESB</li><li>MDM Platform</li><li>Real-Time Big Data Platform</li></ul><br><br>All Talend<br>products |
| New component available | A new component, tWorkdayInput, is available in this<br>release. | <ul>Available in:<li>Big Data</li><li>Big Data Platform</li><li>Cloud API Services Platform</li><li>Cloud Big Data</li><li>Cloud Big Data Platform</li><li>Cloud Data Fabric</li><li>Cloud Data Integration</li><li>Cloud Data Management Platform</li><li>Data Fabric</li><li>Data Integration</li><li>Data Management Platform</li><li>Data Services Platform</li><li>ESB</li><li>MDM Platform</li><li>Real-Time Big Data Platform</li></ul><br><br>All Talend products<br>with Talend Studio |
| New option available: Connection timeout | The Connection<br>timeout option is added to the Advanced settings view.<br><br>Components concerned:<br><br><ul> <li>tFTPFileExist, tFTPPut, tFTPConnection, tFTPDelete,                                tFTPFilelist, tFTPFileProperties, tFTPGet, tFTPRename</li> </ul><br><br>![](https://help.qlik.com/talend/en-US/release-notes/Resources/images/connection_timeout.png) | <ul>Available in:<li>Big Data</li><li>Big Data Platform</li><li>Cloud API Services Platform</li><li>Cloud Big Data</li><li>Cloud Big Data Platform</li><li>Cloud Data Fabric</li><li>Cloud Data Integration</li><li>Cloud Data Management Platform</li><li>Data Fabric</li><li>Data Integration</li><li>Data Management Platform</li><li>Data Services Platform</li><li>ESB</li><li>MDM Platform</li><li>Real-Time Big Data Platform</li></ul><br><br>All Talend<br>products |
| Excel 2007 xlsm support | This feature enables accesses to Excel 2007 files (with<br>the extensions of .xlsx and<br>.xlsm) through the Read excel2007 file format (xlsx /<br>xlsm) and the Write<br>excel2007 file format (xlsx / xlsm) options.<br><br>Components concerned:<br><br><ul> <li>tFileInputExcel, tFileOutputExcel</li> </ul> | <ul>Available in:<li>Big Data</li><li>Big Data Platform</li><li>Cloud API Services Platform</li><li>Cloud Big Data</li><li>Cloud Big Data Platform</li><li>Cloud Data Fabric</li><li>Cloud Data Integration</li><li>Cloud Data Management Platform</li><li>Data Fabric</li><li>Data Integration</li><li>Data Management Platform</li><li>Data Services Platform</li><li>ESB</li><li>MDM Platform</li><li>Real-Time Big Data Platform</li></ul><br><br>All Talend<br>products |
| Excel 2007 password support | This feature allows the tFileInputExcel component to<br>read password-protected Excel 2007 (and later) files given that the<br>passwords are available; it also allows the tFileOutputExcel component<br>to set passwords for Excel 2007 (and later) files.<br><br>Components concerned:<br><br><ul> <li>tFileInputExcel, tFileOutputExcel</li> </ul><br><br>![](https://help.qlik.com/talend/en-US/release-notes/Resources/images/tfileinputexcel_password.png)<br><br><br><br>![](https://help.qlik.com/talend/en-US/release-notes/Resources/images/tfileoutputexcel_password.png) | <ul>Available in:<li>Big Data</li><li>Big Data Platform</li><li>Cloud API Services Platform</li><li>Cloud Big Data</li><li>Cloud Big Data Platform</li><li>Cloud Data Fabric</li><li>Cloud Data Integration</li><li>Cloud Data Management Platform</li><li>Data Fabric</li><li>Data Integration</li><li>Data Management Platform</li><li>Data Services Platform</li><li>ESB</li><li>MDM Platform</li><li>Real-Time Big Data Platform</li></ul><br><br>All Talend<br>products |
| tSetProxy: Https proxy with authentication | This feature allows for connections to a basic<br>authentication-enabled Https proxy server through the Use authentication, Proxy user, Proxy password, and Enable<br>Basic Authentication Header (in the Advanced settings view) options.<br><br>Component concerned:<br><br><ul> <li>tSetProxy</li> </ul><br><br>![](https://help.qlik.com/talend/en-US/release-notes/Resources/images/tsetproxy_https_auth_1.png)<br><br><br><br>![](https://help.qlik.com/talend/en-US/release-notes/Resources/images/tsetproxy_https_auth_2.png) | <ul>Available in:<li>Big Data</li><li>Big Data Platform</li><li>Cloud API Services Platform</li><li>Cloud Big Data</li><li>Cloud Big Data Platform</li><li>Cloud Data Fabric</li><li>Cloud Data Integration</li><li>Cloud Data Management Platform</li><li>Data Fabric</li><li>Data Integration</li><li>Data Management Platform</li><li>Data Services Platform</li><li>ESB</li><li>MDM Platform</li><li>Real-Time Big Data Platform</li></ul><br><br>All Talend<br>products |
| tJDBCInput: prepared statements | This feature enables you to query a database using a<br>prepared statement through the Use<br>PreparedStatement option in the Advanced settings view.<br><br>Component concerned:<br><br><ul> <li>tJDBCInput</li> </ul><br><br>![](https://help.qlik.com/talend/en-US/release-notes/Resources/images/tjdbcinput_preparedstat.png) | <ul>Available in:<li>Big Data</li><li>Big Data Platform</li><li>Cloud API Services Platform</li><li>Cloud Big Data</li><li>Cloud Big Data Platform</li><li>Cloud Data Fabric</li><li>Cloud Data Integration</li><li>Cloud Data Management Platform</li><li>Data Fabric</li><li>Data Integration</li><li>Data Management Platform</li><li>Data Services Platform</li><li>ESB</li><li>MDM Platform</li><li>Real-Time Big Data Platform</li></ul><br><br>All Talend<br>products |
| AWS server-side encryption (SSE) for SQS queues | Components concerned:<br><br><ul> <li>tSQSConnection, tSQSInput,                                    tSQSMessageChangeVisibility, tSQSMessageDelete, tSQSOutput,                                    tSQSQueueAttributes, tSQSQueueCreate, tSQSQueueDelete,                                    tSQSQueueList, tSQSQueuePurge</li> </ul> | <ul>Available in:<li>Big Data</li><li>Big Data Platform</li><li>Cloud API Services Platform</li><li>Cloud Big Data</li><li>Cloud Big Data Platform</li><li>Cloud Data Fabric</li><li>Cloud Data Integration</li><li>Cloud Data Management Platform</li><li>Data Fabric</li><li>Data Integration</li><li>Data Management Platform</li><li>Data Services Platform</li><li>ESB</li><li>MDM Platform</li><li>Real-Time Big Data Platform</li></ul><br><br>All Talend<br>products |
| tPostgresqlOutput: new option available | The tPostgresqlOutput component provides the Convert column and table to lowercase<br>option in the Advanced settings<br>view, to put column names of newly created Postgres tables in lower<br>case.<br><br>![](https://help.qlik.com/talend/en-US/release-notes/Resources/images/tpostgresqloutput_lowercase.png) | <ul>Available in:<li>Big Data</li><li>Big Data Platform</li><li>Cloud API Services Platform</li><li>Cloud Big Data</li><li>Cloud Big Data Platform</li><li>Cloud Data Fabric</li><li>Cloud Data Integration</li><li>Cloud Data Management Platform</li><li>Data Fabric</li><li>Data Integration</li><li>Data Management Platform</li><li>Data Services Platform</li><li>ESB</li><li>MDM Platform</li><li>Real-Time Big Data Platform</li></ul><br><br>All Talend<br>products |
| tServiceNowInput: combined filtering conditions | This feature allows for combined filtering conditions<br>(combined with AND and OR operators) for retrieving data from<br>ServiceNow through the Advanced<br>Query field in the Advanced<br>settings view.<br><br>![](https://help.qlik.com/talend/en-US/release-notes/Resources/images/tservicenowinput_combined_condition.png) | <ul>Available in:<li>Big Data</li><li>Big Data Platform</li><li>Cloud API Services Platform</li><li>Cloud Big Data</li><li>Cloud Big Data Platform</li><li>Cloud Data Fabric</li><li>Cloud Data Integration</li><li>Cloud Data Management Platform</li><li>Data Fabric</li><li>Data Integration</li><li>Data Management Platform</li><li>Data Services Platform</li><li>ESB</li><li>MDM Platform</li><li>Real-Time Big Data Platform</li></ul><br><br>All Talend<br>products |
| tRunJob: customizable Child Job JVM argument | This feature provides the following two ways in the<br>Advanced settings view for<br>setting JVM arguments for the Job to be called or processed (Use dynamic job needs to be selected in<br>the Basic settings view).<br><br><ul> <li> <span>Use child job JVM                                        arguments</span> </li> <li> <span>Overwrite child job                                        JVM arguments</span> </li> </ul><br><br>![](https://help.qlik.com/talend/en-US/release-notes/Resources/images/trunjob_jvm_argument.png) | <ul>Available in:<li>Big Data</li><li>Big Data Platform</li><li>Cloud API Services Platform</li><li>Cloud Big Data</li><li>Cloud Big Data Platform</li><li>Cloud Data Fabric</li><li>Cloud Data Integration</li><li>Cloud Data Management Platform</li><li>Data Fabric</li><li>Data Integration</li><li>Data Management Platform</li><li>Data Services Platform</li><li>ESB</li><li>MDM Platform</li><li>Real-Time Big Data Platform</li></ul><br><br>All Talend<br>products |
| tJDBCSCDELT: End date configurable | This feature allows you to set the End date for type 2<br>SCD.<br><br>![](https://help.qlik.com/talend/en-US/release-notes/Resources/images/tjdbcscdelt_end_date.png) | <ul>Available in:<li>Big Data</li><li>Big Data Platform</li><li>Cloud API Services Platform</li><li>Cloud Big Data</li><li>Cloud Big Data Platform</li><li>Cloud Data Fabric</li><li>Cloud Data Integration</li><li>Cloud Data Management Platform</li><li>Data Fabric</li><li>Data Integration</li><li>Data Management Platform</li><li>Data Services Platform</li><li>ESB</li><li>MDM Platform</li><li>Real-Time Big Data Platform</li></ul><br><br>All Talend<br>products |
| Access control list for S3 components | This feature allows you to set access control list (ACL)<br>for the current component through the Access<br>control option in the Advanced settings view.<br><br>Components concerned:<br><br><ul> <li>tS3Put</li> <li>tS3BucketCreate</li> </ul><br><br>![](https://help.qlik.com/talend/en-US/release-notes/Resources/images/ts3_acl.png) | <ul>Available in:<li>Big Data</li><li>Big Data Platform</li><li>Cloud API Services Platform</li><li>Cloud Big Data</li><li>Cloud Big Data Platform</li><li>Cloud Data Fabric</li><li>Cloud Data Integration</li><li>Cloud Data Management Platform</li><li>Data Fabric</li><li>Data Integration</li><li>Data Management Platform</li><li>Data Services Platform</li><li>ESB</li><li>MDM Platform</li><li>Real-Time Big Data Platform</li></ul><br><br>All Talend<br>products |
| Redshift Bulk components: reuse S3 connection | This feature enables Redshift components to reuse<br>existing S3 connections.<br><br>Components concerned:<br><br><ul> <li>tRedshiftUnload, tRedshiftOutputBulk,                                    tRedshiftOutputBulkExec, tRedshiftBulkExec</li> </ul><br><br>![](https://help.qlik.com/talend/en-US/release-notes/Resources/images/redshift_bulk_reuse_s3_connection.png) | <ul>Available in:<li>Big Data</li><li>Big Data Platform</li><li>Cloud API Services Platform</li><li>Cloud Big Data</li><li>Cloud Big Data Platform</li><li>Cloud Data Fabric</li><li>Cloud Data Integration</li><li>Cloud Data Management Platform</li><li>Data Fabric</li><li>Data Integration</li><li>Data Management Platform</li><li>Data Services Platform</li><li>ESB</li><li>MDM Platform</li><li>Real-Time Big Data Platform</li></ul><br><br>All Talend<br>products |
| tSetProxy: three new options provided for using<br>proxy | The tSetProxy components provides the following three<br>new options.<br><br><ul> <li> <span>Use Java Virtual                                        Machine Proxy Configuration</span> </li> <li> <span>URIs to use                                        proxy</span> </li> <li> <span>Thread isolated                                        proxy</span> (in the <span>Advanced settings</span> view)</li> </ul><br><br>See Talend Components Reference Guide for related<br>information.<br><br>![](https://help.qlik.com/talend/en-US/release-notes/Resources/images/tsetproxy_proxy_using_1.png)<br><br><br><br>![](https://help.qlik.com/talend/en-US/release-notes/Resources/images/tsetproxy_proxy_using_2.png) | <ul>Available in:<li>Big Data</li><li>Big Data Platform</li><li>Cloud API Services Platform</li><li>Cloud Big Data</li><li>Cloud Big Data Platform</li><li>Cloud Data Fabric</li><li>Cloud Data Integration</li><li>Cloud Data Management Platform</li><li>Data Fabric</li><li>Data Integration</li><li>Data Management Platform</li><li>Data Services Platform</li><li>ESB</li><li>MDM Platform</li><li>Real-Time Big Data Platform</li></ul><br><br>All Talend<br>products |
| Setting Kafka connections and configuring Azure EventHub<br>as Kafka cluster | This feature enables you to set Kafka connections and<br>configure an Azure EventHub as Kafka cluster. | <ul>Available in:<li>Big Data</li><li>Big Data Platform</li><li>Cloud API Services Platform</li><li>Cloud Big Data</li><li>Cloud Big Data Platform</li><li>Cloud Data Fabric</li><li>Cloud Data Integration</li><li>Cloud Data Management Platform</li><li>Data Fabric</li><li>Data Integration</li><li>Data Management Platform</li><li>Data Services Platform</li><li>ESB</li><li>MDM Platform</li><li>Real-Time Big Data Platform</li></ul><br><br>All Talend<br>products |
| Using a schema other than the schema of the<br>connection | Through the Use alternate<br>schema option in the Advanced settings view, this feature enables you to use<br>a schema other than the one specified by the component that establishes<br>the database connection (Use an existing<br>connection needs to be selected in the Basic settings view).<br><br>Components concerned:<br><br><ul> <li>tAmazonOracleOutput</li> <li>tRedshiftOutput</li> <li>tGreenplumOutput</li> <li>tDB2Output</li> <li>tInformixOutput</li> <li>tMSSqlOutput</li> <li>tOracleOutput</li> <li>tParAccelOutput</li> <li>tPostgreSQLOutput</li> <li>tPostgresPlusOutput</li> <li>tSAPHanaOutput</li> <li>tSybaseOutput</li> <li>tVerticaOutput</li> </ul><br><br>![](https://help.qlik.com/talend/en-US/release-notes/Resources/images/alternate_schema.png) | <ul>Available in:<li>Big Data</li><li>Big Data Platform</li><li>Cloud API Services Platform</li><li>Cloud Big Data</li><li>Cloud Big Data Platform</li><li>Cloud Data Fabric</li><li>Cloud Data Integration</li><li>Cloud Data Management Platform</li><li>Data Fabric</li><li>Data Integration</li><li>Data Management Platform</li><li>Data Services Platform</li><li>ESB</li><li>MDM Platform</li><li>Real-Time Big Data Platform</li></ul><br><br>All Talend<br>products |
| tSnowflakeConnection: key pair authentication | The tSnowflakeConnection component provides the key pair<br>authentication.<br><br>![](https://help.qlik.com/talend/en-US/release-notes/Resources/images/tsnowflakeconnection_key_pair_auth.png) | <ul>Available in:<li>Big Data</li><li>Big Data Platform</li><li>Cloud API Services Platform</li><li>Cloud Big Data</li><li>Cloud Big Data Platform</li><li>Cloud Data Fabric</li><li>Cloud Data Integration</li><li>Cloud Data Management Platform</li><li>Data Fabric</li><li>Data Integration</li><li>Data Management Platform</li><li>Data Services Platform</li><li>ESB</li><li>MDM Platform</li><li>Real-Time Big Data Platform</li></ul><br><br>All Talend<br>products |
| Customizing SET clause | This feature generates SET clauses for update operations<br>based on the columns you selected in the Clause SET table in the Advanced settings view (Update needs to be selected from the Action on data drop-down list in the<br>Basic settings view).<br><br>Components concerned:<br><br><ul> <li>tELTTeradataOutput</li> <li>tELTOutput</li> </ul><br><br>![](https://help.qlik.com/talend/en-US/release-notes/Resources/images/clause_set.png) | <ul>Available in:<li>Big Data</li><li>Big Data Platform</li><li>Cloud API Services Platform</li><li>Cloud Big Data</li><li>Cloud Big Data Platform</li><li>Cloud Data Fabric</li><li>Cloud Data Integration</li><li>Cloud Data Management Platform</li><li>Data Fabric</li><li>Data Integration</li><li>Data Management Platform</li><li>Data Services Platform</li><li>ESB</li><li>MDM Platform</li><li>Real-Time Big Data Platform</li></ul><br><br>All Talend<br>products |
| Extending AWS ECS role support to other components | This feature makes instance profile credential valid<br>both on Amazon EC2 instances and AWS ECS instances. | <ul>Available in:<li>Big Data</li><li>Big Data Platform</li><li>Cloud API Services Platform</li><li>Cloud Big Data</li><li>Cloud Big Data Platform</li><li>Cloud Data Fabric</li><li>Cloud Data Integration</li><li>Cloud Data Management Platform</li><li>Data Fabric</li><li>Data Integration</li><li>Data Management Platform</li><li>Data Services Platform</li><li>ESB</li><li>MDM Platform</li><li>Real-Time Big Data Platform</li></ul><br><br>All Talend<br>products |
| SHA2 support | SFTP connection now supports SHA2 authentication<br>algorithm.<br><br>Components concerned:<br><br><ul> <li>tFTPConnection</li> <li>tFTPDelete</li> <li>tFTPFileExist</li> <li>tFTPFileList</li> <li>tFTPFileProperties</li> <li>tFTPGet</li> <li>tFTPPut</li> <li>tFTPRename</li> <li>tFTPTruncate</li> </ul> | <ul>Available in:<li>Big Data</li><li>Big Data Platform</li><li>Cloud API Services Platform</li><li>Cloud Big Data</li><li>Cloud Big Data Platform</li><li>Cloud Data Fabric</li><li>Cloud Data Integration</li><li>Cloud Data Management Platform</li><li>Data Fabric</li><li>Data Integration</li><li>Data Management Platform</li><li>Data Services Platform</li><li>ESB</li><li>MDM Platform</li><li>Real-Time Big Data Platform</li></ul><br><br>All Talend<br>products |
| New Amazon S3 region options | The following new Amazon S3 region options are<br>provided:<br><br><ul> <li>US East (Ohio)</li> <li>Asia Pacific (Hong Kong)</li> <li>Asia Pacific (Seoul)</li> <li>Canada (Central)</li> <li>China (Ningxia)</li> <li>EU (London)</li> <li>EU (Paris)</li> <li>EU (Stockholm)</li> </ul><br><br>Components concerned:<br><br><ul> <li>tRedshiftOutputBulk, tRedshiftOutputBulkExec</li> <li>tS3BucketCreate, tS3BucketDelete, tS3BucketExist,                                tS3BucketList, tS3Connection, tS3Copy, tS3Delete, tS3Get, tS3List,                                tS3Put</li> </ul> | <ul>Available in:<li>Big Data</li><li>Big Data Platform</li><li>Cloud API Services Platform</li><li>Cloud Big Data</li><li>Cloud Big Data Platform</li><li>Cloud Data Fabric</li><li>Cloud Data Integration</li><li>Cloud Data Management Platform</li><li>Data Fabric</li><li>Data Integration</li><li>Data Management Platform</li><li>Data Services Platform</li><li>ESB</li><li>MDM Platform</li><li>Real-Time Big Data Platform</li></ul><br><br>All Talend<br>products |
| New Amazon S3 region options | The following new Amazon S3 region options are provided:<br><br><ul> <li>US East (Ohio)</li> <li>Asia Pacific (Hong Kong)</li> <li>Asia Pacific (Seoul)</li> <li>Canada (Central)</li> <li>EU (London)</li> <li>EU (Paris)</li> <li>EU (Stockholm)</li> </ul><br><br>Components concerned: tSnowflakeOutputBulk,<br>tSnowflakeOutputBulkExec, and tSnowflakeBulkExec | <ul>Available in:<li>Big Data</li><li>Big Data Platform</li><li>Cloud API Services Platform</li><li>Cloud Big Data</li><li>Cloud Big Data Platform</li><li>Cloud Data Fabric</li><li>Cloud Data Integration</li><li>Cloud Data Management Platform</li><li>Data Fabric</li><li>Data Integration</li><li>Data Management Platform</li><li>Data Services Platform</li><li>ESB</li><li>MDM Platform</li><li>Real-Time Big Data Platform</li></ul><br><br>All Talend<br>products |
| tRedshiftBulkExec: the Assume Role option available to other data source types<br>besides S3 | For the tRedShiftBulkExec component, in addition to S3<br>data sources, the Assume Role<br>option is now available to these data sources: EMR, DynamoDB, and Remote<br>host. You can thus set IAM role ARN chains for these four types of data<br>sources.<br><br>![](https://help.qlik.com/talend/en-US/release-notes/Resources/images/tredshiftbulkexec_assume_role.png) | <ul>Available in:<li>Big Data</li><li>Big Data Platform</li><li>Cloud API Services Platform</li><li>Cloud Big Data</li><li>Cloud Big Data Platform</li><li>Cloud Data Fabric</li><li>Cloud Data Integration</li><li>Cloud Data Management Platform</li><li>Data Fabric</li><li>Data Integration</li><li>Data Management Platform</li><li>Data Services Platform</li><li>ESB</li><li>MDM Platform</li><li>Real-Time Big Data Platform</li></ul><br><br>All Talend<br>products |
| tSQLTemplateMerge: the Database Type drop-down list provides the Snowflake option | The tSQLTemplateMerge component now provides the<br>Snowflake option in the<br>Database Type drop-down<br>list. In addition, the following system SQL templates are provided:<br><br><ul> <li>SnowflakeCreateSourceTable</li> <li>SnowflakeCreateTargetTable</li> <li>SnowflakeDropSourceTable</li> <li>SnowflakeDropTargetTable</li> <li>SnowflakeMerge</li> </ul><br><br>![](https://help.qlik.com/talend/en-US/release-notes/Resources/images/tsqltemplatemerge_snowflake_option.png) | <ul>Available in:<li>Big Data</li><li>Big Data Platform</li><li>Cloud API Services Platform</li><li>Cloud Big Data</li><li>Cloud Big Data Platform</li><li>Cloud Data Fabric</li><li>Cloud Data Integration</li><li>Cloud Data Management Platform</li><li>Data Fabric</li><li>Data Integration</li><li>Data Management Platform</li><li>Data Services Platform</li><li>ESB</li><li>MDM Platform</li><li>Real-Time Big Data Platform</li></ul><br><br>All Talend<br>products |
| tAmazonEMRManage: cluster version upgrade | The tAmazonEMRManage component now supports the cluster<br>version EMR 5.15.0, which is the default cluster version when<br>configuring the component.<br><br>Besides, the support for EMR 4.2.0, EMR 4.1.0, and EMR<br>4.0.0 is dropped. | <ul>Available in:<li>Big Data</li><li>Big Data Platform</li><li>Cloud API Services Platform</li><li>Cloud Big Data</li><li>Cloud Big Data Platform</li><li>Cloud Data Fabric</li><li>Cloud Data Integration</li><li>Cloud Data Management Platform</li><li>Data Fabric</li><li>Data Integration</li><li>Data Management Platform</li><li>Data Services Platform</li><li>ESB</li><li>MDM Platform</li><li>Real-Time Big Data Platform</li></ul><br><br>All Talend<br>products |
| ActiveMQ 5.15.10 support | Components concerned:<br><br><ul> <li>tMomCommit, tMomConnection, tMomInput,                                tMomMessageIdList, tMomOutput, tMomRollback</li> <li>tSAPADSOInput, tSAPBApi, tSAPBWInput, tSAPCommit,                                tSAPConnection, tSAPDataSourceOutput, tSAPDataSourceReceiver,                                tSAPDSOInput, tSAPDSOOutput, tSAPIDocInput, tSAPIDocOutput,                                tSAPIDocReceiver, tSAPInfoCubeInput, tSAPInfoObjectInput,                                tSAPInfoObjectOutput, tSAPODPInput, tSAPRollback,                                tSAPTableInput</li> </ul> | <ul>Available in:<li>Big Data</li><li>Big Data Platform</li><li>Cloud API Services Platform</li><li>Cloud Big Data</li><li>Cloud Big Data Platform</li><li>Cloud Data Fabric</li><li>Cloud Data Integration</li><li>Cloud Data Management Platform</li><li>Data Fabric</li><li>Data Integration</li><li>Data Management Platform</li><li>Data Services Platform</li><li>ESB</li><li>MDM Platform</li><li>Real-Time Big Data Platform</li></ul><br><br>All Talend<br>products |
| Snowflake JDBC driver 3.11.x support | Components concerned in Standard Jobs:<br><br><ul> <li>tSnowflakeBulkExec, tSnowflakeClose,                                tSnowflakeConnection, tSnowflakeInput, tSnowflakeOutput,                                tSnowflakeOutputBulk, tSnowflakeOutputBulkExec, tSnowflakeRow</li> </ul> | <ul>Available in:<li>Big Data</li><li>Big Data Platform</li><li>Cloud API Services Platform</li><li>Cloud Big Data</li><li>Cloud Big Data Platform</li><li>Cloud Data Fabric</li><li>Cloud Data Integration</li><li>Cloud Data Management Platform</li><li>Data Fabric</li><li>Data Integration</li><li>Data Management Platform</li><li>Data Services Platform</li><li>ESB</li><li>MDM Platform</li><li>Real-Time Big Data Platform</li></ul><br><br>All Talend<br>products |
| Redshift JDBC driver 1.23.7.1061 support | Components concerned in Standard Jobs:<br><br><ul> <li>tRedshiftBulkExec, tRedshiftClose, tRedshiftCommit,                                tRedshiftConnection, tRedshiftInput, tRedshiftOutput,                                tRedshiftOutputBulk, tRedshiftOutputBulkExec, tRedshiftRollback,                                tRedshiftRow, tRedshiftUnload</li> </ul> | <ul>Available in:<li>Big Data</li><li>Big Data Platform</li><li>Cloud API Services Platform</li><li>Cloud Big Data</li><li>Cloud Big Data Platform</li><li>Cloud Data Fabric</li><li>Cloud Data Integration</li><li>Cloud Data Management Platform</li><li>Data Fabric</li><li>Data Integration</li><li>Data Management Platform</li><li>Data Services Platform</li><li>ESB</li><li>MDM Platform</li><li>Real-Time Big Data Platform</li></ul><br><br>All Talend<br>products |
| MySQL driver 8.0.18 support (MySQL 4 support<br>dropped) | Components concerned in Standard Jobs:<br><br><ul> <li>tMysqlCDC, tMysqlClose, tMysqlColumnlist,                                tMysqlCommit, tMysqlConnection, tMysqlInput, tMysqlInvalidRows,                                tMysqlLastInsertId, tMysqlOutput, tMysqlOutputBulk,                                tMysqlOutputBulkExec, tMysqlRollback, tMysqlRow, tMysqlSCD,                                tMysqlSCDELT, tMysqlSP,tMysqlTableList, tMysqlValidRows</li> </ul> | <ul>Available in:<li>Big Data</li><li>Big Data Platform</li><li>Cloud API Services Platform</li><li>Cloud Big Data</li><li>Cloud Big Data Platform</li><li>Cloud Data Fabric</li><li>Cloud Data Integration</li><li>Cloud Data Management Platform</li><li>Data Fabric</li><li>Data Integration</li><li>Data Management Platform</li><li>Data Services Platform</li><li>ESB</li><li>MDM Platform</li><li>Real-Time Big Data Platform</li></ul><br><br>All Talend<br>products |
| Vertica DB 9.3.1 support | Components concerned:<br><br><ul> <li>tVerticaBulkExec, tVerticaClose, tVerticaCommit,                                tVerticaConnection, tVerticaInput, tVerticaOutput,                                tVerticaOutputBulk, tVerticaOutputBulkExec, tVerticaRollback,                                tVerticaRow, tVerticaSCD</li> </ul> | <ul>Available in:<li>Big Data</li><li>Big Data Platform</li><li>Cloud API Services Platform</li><li>Cloud Big Data</li><li>Cloud Big Data Platform</li><li>Cloud Data Fabric</li><li>Cloud Data Integration</li><li>Cloud Data Management Platform</li><li>Data Fabric</li><li>Data Integration</li><li>Data Management Platform</li><li>Data Services Platform</li><li>ESB</li><li>MDM Platform</li><li>Real-Time Big Data Platform</li></ul><br><br>All Talend<br>products |
| Postgres 12.1 support | Components concerned:<br><br><ul> <li>tPostgresqlCDC, tPostgresqlClose,                                tPostgresqlCommit, tPostgresqlConnection, tPostgresqlInput,                                tPostgresqlInvalidRows, tPostgresqlOutput, tPostgresqlOutputBulk,                                tPostgresqlOutputBulkExec, tPostgresqlRollback, tPostgresqlRow,                                tPostgresqlSCD, tPostgresqlSCDELT, tPostgresqlValidRows</li> </ul> | <ul>Available in:<li>Big Data</li><li>Big Data Platform</li><li>Cloud API Services Platform</li><li>Cloud Big Data</li><li>Cloud Big Data Platform</li><li>Cloud Data Fabric</li><li>Cloud Data Integration</li><li>Cloud Data Management Platform</li><li>Data Fabric</li><li>Data Integration</li><li>Data Management Platform</li><li>Data Services Platform</li><li>ESB</li><li>MDM Platform</li><li>Real-Time Big Data Platform</li></ul><br><br>All Talend<br>products |
| MariaDB 10.x support (MariaDB JDBC driver upgraded to<br>2.5.3) | Components concerned in Standard Jobs:<br><br><ul> <li>tCreateTable</li> <li>tELTMysqlMap</li> <li>tMysqlBulkExec, tMysqlConnection, tMysqlInput,                                tMysqlOutput, tMysqlOutputBulkExec, tMysqlRow, tMysqlSCD,                                tMysqlSCDELT, tMysqlSP, tMysqlCDC</li> <li>tJDBCClose, tJDBCColumnList, tJDBCCommit,                                tJDBCConnection, tJDBCInput, tJDBCOutput, tJDBCRollback, tJDBCRow,                                tJDBCSCDELT, tJDBCSP, tJDBCTableList</li> </ul> | <ul>Available in:<li>Big Data</li><li>Big Data Platform</li><li>Cloud API Services Platform</li><li>Cloud Big Data</li><li>Cloud Big Data Platform</li><li>Cloud Data Fabric</li><li>Cloud Data Integration</li><li>Cloud Data Management Platform</li><li>Data Fabric</li><li>Data Integration</li><li>Data Management Platform</li><li>Data Services Platform</li><li>ESB</li><li>MDM Platform</li><li>Real-Time Big Data Platform</li></ul><br><br>All Talend<br>products |
| Salesforce version updated to v47 | Salesforce v47 is now supported in Talend components. | <ul>Available in:<li>Big Data</li><li>Big Data Platform</li><li>Cloud API Services Platform</li><li>Cloud Big Data</li><li>Cloud Big Data Platform</li><li>Cloud Data Fabric</li><li>Cloud Data Integration</li><li>Cloud Data Management Platform</li><li>Data Fabric</li><li>Data Integration</li><li>Data Management Platform</li><li>Data Services Platform</li><li>ESB</li><li>MDM Platform</li><li>Real-Time Big Data Platform</li></ul><br><br>All Talend<br>products |
| Default Salesforce endpoint updated | The default Salesforce endpoint updated as:<br>https://login.salesforce.com/services/Soap/u/47.0<br>. | <ul>Available in:<li>Big Data</li><li>Big Data Platform</li><li>Cloud API Services Platform</li><li>Cloud Big Data</li><li>Cloud Big Data Platform</li><li>Cloud Data Fabric</li><li>Cloud Data Integration</li><li>Cloud Data Management Platform</li><li>Data Fabric</li><li>Data Integration</li><li>Data Management Platform</li><li>Data Services Platform</li><li>ESB</li><li>MDM Platform</li><li>Real-Time Big Data Platform</li></ul><br><br>All Talend<br>products |
| Netsuite endpoint updated | Netsuite endpoint updated as:<br>https://webservices.netsuite.com/services/NetSuitePort\_2019\_2<br>(API version 2019.2<br>required). | <ul>Available in:<li>Big Data</li><li>Big Data Platform</li><li>Cloud API Services Platform</li><li>Cloud Big Data</li><li>Cloud Big Data Platform</li><li>Cloud Data Fabric</li><li>Cloud Data Integration</li><li>Cloud Data Management Platform</li><li>Data Fabric</li><li>Data Integration</li><li>Data Management Platform</li><li>Data Services Platform</li><li>ESB</li><li>MDM Platform</li><li>Real-Time Big Data Platform</li></ul><br><br>All Talend<br>products |

## Talend Administration Center

| Feature | Description | Available in |
| --- | --- | --- |
| Monthly update support | Apart from the patches that Talend delivers to fix<br>issues in the Studio, you can now get monthly update patches which contain<br>cumulative patches delivered throughout the month.<br>![](https://help.qlik.com/talend/en-US/release-notes/Resources/images/tac-software_update-patch.png) | <ul>Available in:<li>Big Data</li><li>Big Data Platform</li><li>Cloud API Services Platform</li><li>Cloud Big Data</li><li>Cloud Big Data Platform</li><li>Cloud Data Fabric</li><li>Cloud Data Integration</li><li>Cloud Data Management Platform</li><li>Data Fabric</li><li>Data Integration</li><li>Data Management Platform</li><li>Data Services Platform</li><li>MDM Platform</li><li>Real-Time Big Data Platform</li></ul><br><br>All Talend products<br>except Talend ESB |
| Configurable technical/business log | You can now configure the technical/business log by<br>file limitation and file lifetime in Talend Administration Center.<br>![](https://help.qlik.com/talend/en-US/release-notes/Resources/images/logs.png) | <ul>Available in:<li>Big Data</li><li>Big Data Platform</li><li>Cloud API Services Platform</li><li>Cloud Big Data</li><li>Cloud Big Data Platform</li><li>Cloud Data Fabric</li><li>Cloud Data Integration</li><li>Cloud Data Management Platform</li><li>Data Fabric</li><li>Data Integration</li><li>Data Management Platform</li><li>Data Services Platform</li><li>MDM Platform</li><li>Real-Time Big Data Platform</li></ul><br><br>All Talend products<br>except Talend ESB |
| Second level cache support | You can now enable second level cache in Talend Administration Center to optimize the GUI<br>performance. | <ul>Available in:<li>Big Data</li><li>Big Data Platform</li><li>Cloud API Services Platform</li><li>Cloud Big Data</li><li>Cloud Big Data Platform</li><li>Cloud Data Fabric</li><li>Cloud Data Integration</li><li>Cloud Data Management Platform</li><li>Data Fabric</li><li>Data Integration</li><li>Data Management Platform</li><li>Data Services Platform</li><li>MDM Platform</li><li>Real-Time Big Data Platform</li></ul><br><br>All Talend products<br>except Talend ESB |
| MSSQL official driver support | In addition to the jTDS driver, MSSQL official driver<br>is now supported for Azure SQL and SQL server databases. | <ul>Available in:<li>Big Data</li><li>Big Data Platform</li><li>Cloud API Services Platform</li><li>Cloud Big Data</li><li>Cloud Big Data Platform</li><li>Cloud Data Fabric</li><li>Cloud Data Integration</li><li>Cloud Data Management Platform</li><li>Data Fabric</li><li>Data Integration</li><li>Data Management Platform</li><li>Data Services Platform</li><li>MDM Platform</li><li>Real-Time Big Data Platform</li></ul><br><br>All Talend products<br>except Talend ESB |
| POST operation support to call MetaServlet | It is now supported to use POST operation to call<br>MetaServlet for additional security. | <ul>Available in:<li>Big Data</li><li>Big Data Platform</li><li>Cloud API Services Platform</li><li>Cloud Big Data</li><li>Cloud Big Data Platform</li><li>Cloud Data Fabric</li><li>Cloud Data Integration</li><li>Cloud Data Management Platform</li><li>Data Fabric</li><li>Data Integration</li><li>Data Management Platform</li><li>Data Services Platform</li><li>MDM Platform</li><li>Real-Time Big Data Platform</li></ul><br><br>All Talend products<br>except Talend ESB |