Setting up connections to targets
You can connect to targets to facilitate data delivery and various ELT operations, including data registration, data storage, transformations, and data mart creation. Target platforms can be supported as replication targets, data pipeline targets, and in some cases, both.
Target platform use cases and supported versions
The table below summarizes which platforms are supported according to use case and, where applicable, lists the supported versions for each target.
Target platform | Supported as a replication target | Supported as a data pipeline target platform | Supported as a data warehouse staging area | Supports access via a private connection | Version |
---|---|---|---|---|---|
Azure Data Lake Storage |
Yes |
No |
Supported with the following targets:
|
Yes | Not applicable |
Amazon Redshift |
Yes |
Yes | No | Yes | Not applicable |
Amazon S3 |
Yes |
No |
Supported with the following targets:
|
Yes | Not applicable |
Databricks |
Yes |
Yes | No |
On Azure: Yes On Google: Yes On AWS: Not when moving data. Only when registering data and running ELT tasks. |
|
Google BigQuery |
Yes |
Yes | No | Yes | Not applicable |
Google Cloud Storage |
Yes |
No |
Supported with the Databricks target. |
Yes | |
Microsoft Azure Synapse Analytics | No | Yes | No | Yes | Not applicable |
Microsoft Fabric |
Yes |
Yes | No | Yes | Not applicable |
In addition to on-premises support, the following cloud platforms are also supported:
|
Yes | Yes | No | Yes |
2016, 2017, 2019, 2022 |
In addition to on-premises support, the following cloud platforms are also supported:
|
Yes | No | No | Yes |
8.0, 8.1 Information noteWhen MariaDB is the target, the supported versions are 10.4 to 10.11
|
Yes | No | No | Yes |
19.x, 21c Warning noteIf you set the Oracle compatibility parameter, make sure you specify a version supported by Data Movement gateway. For example, if you are working with version 21c, you cannot set an earlier version as the compatibility version.
|
|
In addition to on-premises support, the following cloud platforms are also supported:
|
Yes | No | No | Yes | 12.x, 13.x, 14.x, 15.x, 16.x |
Qlik Cloud | No | Yes | No | Not applicable | Not applicable |
Yes |
Yes | No | Yes | Not applicable |
For more information on the data pipeline use case, see Creating a data pipeline.
For more information on the replication use case, see Creating a data replication task.
For more information on private connections, see Supporting private connections in Qlik Talend Data Integration.