Supported source database 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.
| Connector | Data source | Supported versions | Source type |
|---|---|---|---|
|
MySQL For more information, see MySQL. |
|
5.7, 8.0 |
Relational database |
|
8.0 | Relational database | |
|
10.4 to 10.11 | Relational database | |
|
10.3, 10.4, and 10.5 | Relational database | |
|
PostgreSQL For more information, see PostgreSQL |
|
10.x, 11.x, 12.x, 13.x, 14.x, 15.x |
Relational database |
|
10.x, 11.x, 12.x, 13.x, 14.x, 15.x | Relational database | |
|
10.x, 11.x, 12.x, 13.x, 14.x, 15.x | Relational database | |
|
N/A | Relational database | |
|
Oracle For more information, see Oracle |
|
12.x, 18.x, 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 12.x, 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) |
Microsoft SQL Server |
2014, 2016, 2017, 2019, 2022 |
Relational database |
|
Microsoft SQL Server (Microsoft CDC based). For more information, see Microsoft SQL Server (Microsoft CDC based) |
|
2014, 2016, 2017, 2019, 2022 |
Relational database |
|
IBM DB2 for LUW For more information, see IBM DB2 for LUW. |
IBM DB2 for LUW |
10.5, and 11.1, and 11.5 Information note
10.5 with fix pack 5 is not supported. |
Relational database |
|
IBM DB2 for z/OS For more information, see IBM DB2 for z/OS |
IBM DB2 for z/OS |
DB2: 12, 12.1 , 13.1 IBM z/OS: 2.3, 2.4, 2.5 |
Mainframe |
|
IBM DB2 for iSeries For more information, see IBM DB2 for iSeries |
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) |
SAP HANA | 2.0 | SAP |
|
SAP ODP For more information, see SAP ODP |
SAP ODP |
The SAP ODP endpoint uses ODP API 2.0 which is available from the following SAP basis levels and above:
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
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)