Connecting 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 platform | Supports access via a private connection | Version |
|---|---|---|---|---|
| Azure Data Lake Storage |
Yes Information noteSupported as a target in "Land data in data lake" tasks only.
|
Supported as a cloud staging area for the following data pipeline platforms:
|
Yes | Not applicable |
| Amazon Redshift | No | Yes | Yes | Not applicable |
| Amazon S3 |
Yes Information noteSupported as a target in "Land data in data lake" tasks only.
|
Also supported as a cloud staging area for Databricks and Amazon Redshift targets. | Yes | Not applicable |
| Databricks | No | Yes |
On Azure: Yes On Google: Yes On AWS: Not when landing data. Only when registering data and running ELT tasks. |
|
| Google BigQuery | No | Yes | Yes | Not applicable |
| Google Cloud Storage |
Yes Information noteSupported as a target in "Land data in data lake" tasks only.
|
Supported as a cloud staging area for the Databricks data pipeline platform. | Yes | |
| Microsoft Azure Synapse Analytics | No | Yes | Yes | Not applicable |
| Microsoft Fabric | No | Yes | Yes | Not applicable |
|
In addition to on-premises support, the following cloud platforms are also supported:
|
Yes | Yes | Yes |
2014, 2016, 2017, 2019, 2022 |
|
In addition to on-premises support, the following cloud platforms are also supported:
|
Yes | No | Yes |
5.7, 8.0 Information noteWhen MariaDB is the target, the supported versions are 10.4 to 10.11
|
| Yes | No | Yes |
12.x, 18.x, 19.x, 21c Information noteWhen Oracle on Oracle Cloud is the target, versions earlier than Oracle 12.2 are not supported.
Warning noteIf you set the Oracle compatibility parameter, make sure you specify a version supported by Data Movement gateway.
|
|
|
In addition to on-premises support, the following cloud platforms are also supported:
|
Yes | No | Yes | 11.x, 12.x, 13.x, 14.x, 15.x |
| Qlik Cloud | No | Yes | Not applicable | Not applicable |
| No | Yes | 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 Cloud Data Integration.