Product Documentation
Abstract
This document shows all the data sources supported by federation capability which is part of Db2 on Cloud, Db2 Warehouse, Db2 Warehouse on Cloud and IBM Db2 Hosted.
Content
The following table includes all the data sources supported by federation capability that is part of Db2 on Cloud, Db2 Warehouse, Db2 Warehouse on Cloud and IBM Db2 Hosted.
Table 1. Supported data sources and versions.
| Data Source | Supported Versions |
| Apache Hive | V1.2.1 and later |
| Apache Spark SQL | V1.5 and later |
| Cloudera Impala | V2.7 and later |
| IBM Big SQL | 3.0 and later |
| IBM® Db2® Warehouse on Cloud (formerly dashDB for Analytics) | (not applicable)1 |
| IBM Db2 on Cloud (formerly dashDB for Transactions) | (not applicable)1 |
| IBM Db2 Warehouse (formerly dashDB Local) | (not applicable)1 |
| IBM Db2 LUW | (9.7, 9.8, 10.1, 10.5, 11.1, 11.5)3 |
| IBM Db2 for IBM i® | 6.1, 7.1 |
| IBM Db2 for z/OS® | 9.x, 10.x, 11.x |
| IBM Db2 Hosted (formerly DB2 On Cloud) | (not applicable)1 |
| IBM Db2 Server for VSE and VM | 7.4, 7.5 |
| IBM Integrated Analytics System | (not applicable)1 |
| IBM PureData System for Analytics (formerly Netezza) | 6.x, 7.x |
| IBM PureData System for Operational Analytics | 1.1 |
| IBM PureData System for Transactions | 10.x |
| Microsoft SQL Server | 2012, 2104, 2016 |
| Oracle MySQL2 | 5.0, 5.1, 5.5, 5.6 |
| Oracle | 11gR1, 11gR2, 12cR1 |
| PostgreSQL | 9.0, 9.1, 9.2, 9.3, 9.4, 9.5, 9.6 |
1 This data source is a managed service that is always at its most current version.
2 Oracle MySQL Commercial and MySQL Enterprise servers are supported.
3 Federation doesn’t support seamless ACR.
Note: For the Db2 on Cloud and Db2 Warehouse on Cloud managed cloud services, support for certain data sources might need to be installed by IBM Support upon request. See the documentation for your managed service offering to determine what pre-installed drivers are present. If not yet supported, it could take up to 90 days for your data source drivers to be made available on your managed service database.
Was this topic helpful?
Document Information
Modified date:
27 February 2023
UID
swg27050561