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.

When you connect to targets you may need to add underlying Qlik Cloud IP addresses to your allowlist. For more information, see Allowlisting domain names and IP addresses.

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 use cases and supported versions
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: Databricks Azure Synapse Analytics Microsoft Fabric	Yes	Not applicable
Amazon Redshift	Yes	Yes	No	Yes	Not applicable
Amazon S3	Yes	No	Supported with the following targets: Databricks Amazon Redshift	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.	All-purposes (Interactive) cluster: 10.4 LTS 11.3 LTS 12.2 LTS 13.3 LTS 14.3 LTS SQL Warehouse cluster Databricks SQL Serverless
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
Microsoft SQL Server In addition to on-premises support, the following cloud platforms are also supported: Amazon RDS for SQL Server Google Cloud for SQL Server Microsoft Azure SQL (Supports both Microsoft Azure Managed Instance and Microsoft Azure Database)	Yes	Yes	No	Yes	2016, 2017, 2019, 2022
MySQL and MariaDB In addition to on-premises support, the following cloud platforms are also supported: Amazon Aurora Microsoft Azure Database for MySQL - Flexible Server. Amazon RDS for MariaDB Amazon RDS for MySQL Google Cloud SQL for MySQL. Microsoft Azure Database for MySQL	Yes	No	No	Yes	8.0, 8.1 Information noteWhen MariaDB is the target, the supported versions are 10.4 to 10.11
Oracle	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.
PostgreSQL In addition to on-premises support, the following cloud platforms are also supported: Amazon Aurora Azure Database for PostgreSQL - Flexible Server Amazon RDS for PostgreSQL Google Cloud SQL for PostgreSQL Google Cloud AlloyDB for PostgreSQL Microsoft Azure Database for PostgreSQL	Yes	No	No	Yes	12.x, 13.x, 14.x, 15.x, 16.x
Qlik Cloud	No	Yes	No	Not applicable	Not applicable
Snowflake	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.

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 – let us know how we can improve!

Leave your feedback here