# 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.

Information noteWhen you connect to targets you may need to add underlying Qlik Cloud IP addresses to your allowlist. For more information, see [Allowlisting domains and IP addresses](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Introduction/qlik-cloud-dns-ip.htm).

## 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.

[](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/TargetConnections/data-project-connections.htm)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](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/TargetConnections/adls-target.htm) | Yes | No | Supported with the following targets:<br><br><ul> <li>Databricks</li> <li>Azure Synapse Analytics</li> <li>Microsoft Fabric</li> </ul> | Yes | Not applicable |
| [Amazon Redshift](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/TargetConnections/redshift-target.htm) | Yes | Yes | No | Yes | Not applicable |
| [Amazon S3](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/TargetConnections/aws-s3-target.htm) | Yes | No | Supported with the following targets:<br><br><ul> <li>Databricks</li> <li>Amazon Redshift</li> </ul> | Yes | Not applicable |
| [Databricks](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/TargetConnections/databricks-target.htm) | Yes | Yes | No | On Azure: Yes<br><br>On Google: Yes<br><br>On AWS: Not when moving data. Only when registering data and running ELT tasks. | <ul> <li> <p>All-purposes (Interactive) cluster:</p> <ul> <li> <p>12.2 LTS</p> </li> <li> <p>13.3 LTS</p> </li> <li> <p>14.3 LTS</p> </li> <li> <p>15.4 LTS</p> </li> </ul> </li> <li> <p>SQL Warehouse cluster</p> </li> <li> <p>Databricks SQL Serverless</p> </li> </ul> |
| [Google BigQuery](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/TargetConnections/bigquery-target.htm) | Yes | Yes | No | Yes | Not applicable |
| [Google Cloud Storage](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/TargetConnections/google-storage-target.htm) | Yes | No | Supported with the Databricks target. | Yes |  |
| [Microsoft Azure Synapse Analytics](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/TargetConnections/azure-target.htm) | No | Yes, except when SaaS connectors are used as sources in data pipeline projects. | No | Yes | Not applicable |
| [Microsoft Fabric](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/TargetConnections/fabric-target.htm) | Yes | Yes | No | Yes | Not applicable |
| [Microsoft SQL Server](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/TargetConnections/sqlserver-target.htm)<br><br>In addition to on-premises support, the following cloud platforms are also supported:<br><br><ul> <li>Amazon RDS for SQL Server</li> <li>Google Cloud for SQL Server</li> <li>Microsoft Azure SQL (Supports both Microsoft Azure Managed Instance and Microsoft Azure Database)</li> </ul> | Yes | Yes | No | Yes | 2016, 2017, 2019, 2022 |
| [MySQL and MariaDB](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/TargetConnections/mysql-target.htm)<br><br>In addition to on-premises support, the following cloud platforms are also supported:<br><br><ul> <li>Amazon Aurora</li> <li>Microsoft Azure Database for MySQL - Flexible Server.</li> <li>Amazon RDS for MariaDB </li> <li>Amazon RDS for MySQL</li> <li>Google Cloud SQL for MySQL.</li> </ul> | Yes | No | No | Yes | 8.0, 8.4<br><br>Information noteWhen MariaDB (on-premises or Amazon RDS) is the target, the supported versions are 10.6 to 10.11, 11.4, and 11.8 |
| [Oracle](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/TargetConnections/oracle-target.htm) | Yes | No | No | Yes | 19.x, 21c, 23ai<br><br>Information note<br><br>Oracle 23ai is certified with Oracle Standard Edition only.<br><br>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](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/TargetConnections/postgresql-target.htm)<br><br>In addition to on-premises support, the following cloud platforms are also supported:<br><br><ul> <li>Amazon Aurora</li> <li>Azure Database for PostgreSQL - Flexible Server</li> <li>Amazon RDS for PostgreSQL</li> <li>Google Cloud SQL for PostgreSQL </li> <li>Google Cloud AlloyDB for PostgreSQL</li> </ul> | Yes | No | No | Yes | 14.x, 15.x, 16.x, 17.x |
| [Teradata](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/TargetConnections/teradata-target.htm) | Yes | No | No | Yes | 17.x, 20.x |
| [Qlik Cloud](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/TargetConnections/aws-target.htm) | No | Yes | No | Not applicable | Not applicable |
| [Snowflake](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/TargetConnections/snowflake-target.htm) | Yes | Yes | No | Yes | Not applicable |
| [Kafka](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/TargetConnections/kafka-target.htm)<br><br>In addition to on-premises support, Amazon MSK is also supported.<br><br>Schema registry servers:<br><br>Certified with Confluent Schema Registry 6.x, and 7.x. | Yes | No | No | Yes | 3.x and 4.0.x |

For more information on the data pipeline use case, see [Creating and managing data pipeline projects](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Introduction/Data-projects.htm).

For more information on the replication use case, see [Creating a replication project](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Replicating/data-replication-task.htm).

For more information on private connections, see [Supporting private connections in Qlik Talend Data Integration](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Gateways/replication-gateway.htm#Supporti).