Skip to main content Skip to complementary content
Qlik Resources

Supported source databases and versions

The table below lists which source database versions are supported by Data Movement gateway and also specifies which connectors need to be configured to connect to the database.

Information noteThe supported database versions always reflect the capabilities of the latest Data Movement gateway version, regardless of whether or not you are using Data Movement gateway to access your data source(s). For information on the versions supported (or no longer supported) with the latest Data Movement gateway version ,see Upgrading and uninstalling Data Movement gateway
Supported data sources
Connector Supported subscription Supported without Data Movement gateway Data source Supported versions Source type

MySQL

For more information, see MySQL.

 All Yes
  • MySQL
  • Amazon Aurora for MySQL
  • Amazon RDS for MySQL
  • Google Cloud SQL for MySQL
  • Percona

8.0, 8.1

 Relational database
 
  • Microsoft Azure Database for MySQL
 8.0, 8.1 Relational database
 
  • MariaDB
 10.4 to 10.11 Relational database
 
  • Amazon RDS for MariaDB
 10.3, 10.4, and 10.5 Relational database

PostgreSQL

For more information, see PostgreSQL

 All Yes
  • PostgreSQL
  • Amazon RDS for PostgreSQL
  • Google Cloud SQL for PostgreSQL
  • Google Cloud AlloyDB for PostgreSQL

12.x, 13.x, 14.x, 15.x, 16.x

 Relational database
 
  • Amazon Aurora Cloud for PostgreSQL
 12.x, 13.x, 14.x, 15.x, 16.x Relational database
 
  • Microsoft Azure Database for PostgreSQL
12.x, 13.x, 14.x, 15.x, 16.x Relational database
 
  • Microsoft Azure Database for PostgreSQL - Flexible Server
N/A Relational database

Oracle

For more information, see Oracle

 Standard, Enterprise, and Premium No
  • Oracle
  • Oracle Amazon RDS for Oracle
  • Oracle on Oracle Cloud

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.
 Relational database

Microsoft SQL Server (log based)

For more information, see On-premises Microsoft SQL Server (log based)

 Standard, Enterprise, and Premium No

Microsoft SQL Server

2016, 2017, 2019, 2022

 Relational database

Microsoft SQL Server (Microsoft CDC based).

For more information, see Microsoft SQL Server (Microsoft CDC based)

 All Yes
  • Microsoft Azure SQL Managed Instance
  • Microsoft Azure SQL Database

2016, 2017, 2019, 2022

 Relational database

IBM DB2 for LUW

For more information, see IBM DB2 for LUW.

 Enterprise No IBM DB2 for LUW

11.1, 11.5

 Relational database

IBM DB2 for z/OS

For more information, see IBM DB2 for z/OS

 Enterprise No IBM DB2 for z/OS

DB2:

12, 12.1 , 13.1

IBM z/OS:

2.4, 2.5

Mainframe

IBM DB2 for iSeries

For more information, see IBM DB2 for iSeries

 Enterprise No IBM DB2 for iSeries 7.2, 7.3, 7.4, and 7.5 Relational database

SAP HANA (Database)

For more information, see SAP HANA (Database)

 Enterprise No SAP HANA 2.0 SAP

SAP ODP

For more information, see SAP ODP

 Enterprise No SAP ODP

The SAP ODP endpoint uses ODP API 2.0 which is available from the following SAP basis levels and above:

  • PI_BASIS 730 SP 14 (part of SAP NetWeaver 7.30 SP 14)

  • PI_BASIS 731 SP 16 (part of SAP NetWeaver 7.03 SP 16 and 7.31 SP 16)

  • PI_BASIS 740 SP 11 (part of SAP NetWeaver 7.40 SP 11)

  • SAP_BW 750 SP 0 (incl. former PI_BASIS packages)

Information noteSAP_BASIS and PI_BASIS are interchangeable. In newer systems, the component name is SAP_BASIS.

For more information, see SAP Note 1931427.

For information on how to release extractors so that they are available for the ODP API, see SAP Note 2232584.

 SAP

Other supported SAP connectors

Information noteThese data sources are supported with an Enterprise subscription only and cannot be accessed without Data Movement gateway.

The following SAP connectors are also supported:

  • SAP Extractor

    For more information, see SAP Extractor

  • SAP (Application)

    For SAP configurations using any of the following backend databases: Oracle, Microsoft SQL Server, IBM DB2 for LUW, IBM DB2 for z/OS, and SAP HANA. For more information, seeSAP (Application)

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