Detailed System Requirements
Abstract
This page lists the remote data sources that can be accessed using the built-in federation capability of Db2 LUW V11.1.
Content
When configuring a wrapper, a software layer (driver, SDK, or standalone program) is required that handles the vendor-specific communication with the data source. This layer may be built in to Federation, provided by IBM on the media with Db2 for Linux, Unix and Windows, or in some cases, provided by the vendor of the data source or other third party.
The first table shows which data sources require vendor-supplied software to complete the wrapper. This software must be acquired separately and installed on the same system as Federation for the data sources that you want to access.
The second table shows the availability of wrappers on 32-bit and 64-bit operating systems. Certain wrappers are not available on all operating systems due to the availability of dependent data source software.
Table 1. Supported data sources, versions, and software requirements.
| Data Source | Supported Versions | Dependent Data Source Software or Service |
| Apache Hive |
Hive with CDH 5.7, 5.109, 5.119, 5.129, 5.139
Hive with HDP 2.4, 2.59, 2.69
|
IBM Branded ODBC driver package3 |
| Apache Spark SQL | V1.6.2, V1.6.3, V2.0.09, V2.1.19 | IBM Branded ODBC driver package3 |
| BioRS | 5.2, 5.3 | None17 |
| Cloudera Impala | V2.7.0 | IBM Branded ODBC driver package3 |
| CouchDB | 2.0.014, 2.1.014, 2.2.014 | None15 |
| Greenplum | 5.014 | IBM Branded ODBC driver package3 |
| IBM Big SQL | 3.0 and later | None1 |
| IBM® Db2® Warehouse on Cloud (formerly dashDB for Analytics) | (not applicable)7 | None1 |
| IBM Db2 on Cloud (formerly dashDB for Transactions) | (not applicable)7 | None1 |
| IBM Db2 Warehouse (formerly dashDB Local) | (not applicable)7 | None1 |
| IBM Db2 LUW | 9.7, 9.8, 10.1, 10.5, 11.1 | None1 |
| IBM Db2 for IBM i® | 6.1, 7.1, 7.29, 7.39 | None1 |
| IBM Db2 for z/OS® | 9.x, 10.x, 11.x | None1 |
| IBM Db2 Hosted (formerly DB2 on Cloud) | (not applicable)7 | None1 |
| IBM Db2 Server for VSE and VM | 7.4, 7.5 | None1 |
| IBM Integrated Analytics System | (not applicable)7 | None1 |
| IBM MQ® | 7, 7.01, 8.x | None4 |
| IBM PureData System for Analytics (formerly Netezza) | 6.x, 7.x | Netezza ODBC driver2 IBM Branded ODBC driver package3 |
| IBM PureData System for Operational Analytics | 1.1 | None1 |
| IBM PureData System for Transactions | 10.x | None1 |
| Informix® | 11.5, 11.7, 12.10 | Informix Client SDK version 3.0 or higher |
| MariaDB | V10.x9 | IBM Branded ODBC driver package3 and MariaDB ODBC Driver10 |
| Microsoft Azure SQL Database | (not applicable)7,14 | IBM Branded ODBC driver package3 |
| Microsoft SQL Server | 2012, 2104, 20165 | IBM Branded ODBC driver package3 |
| MongoDB | 3.09, 3.29, 3.49 | Eve RESTful service deployed with MongoDB |
| Oracle MySQL8 | 5.06, 5.16, 5.56, 5.66 | IBM Branded ODBC driver package3 |
| Oracle11 | 11gR2, 12cR1, 12cR213 |
IBM Branded ODBC driver package3 or Oracle Database Client Software12 |
| Parquet on Hadoop | 2.9.014 | None15 |
| PostgreSQL | 9.06, 9.16, 9.26, 9.36, 9.46, 9.56, 9.66, 10.x6 | IBM Branded ODBC driver package3 |
| SAP HANA | 2.014 | IBM Branded ODBC driver package3 and SAP HANA ODBC Driver16 |
| SAP Sybase | Sybase ASE 15.5, 15.7, 16.014 | Sybase Open Client12 |
| Teradata | 13, 14, 15, 169 |
|
| Web Services |
WSDL 1.0, 1.1
SOAP 1.0, 1.1
|
None17 |
| XML | XML 1.0, XML 1.1 | None17 |
1 Db2 Connect is included as a supporting program for the purpose of accessing this data source.
2 Manual installation required for a) Db2 V11.1 GA and, b) Db2 V11.1 fixpack 1 (V11.1.1.1) on Linux PPCLEx64, c) Db2 V11.1 Mod Pack 3 and Fix Pack 3 (V11.1.3.3) and earlier on zLinux64. d) 64-bit Windows platform.
3 IBM branded ODBC driver package is included in Db2 LUW starting from V11.1 fixpack 1 (V11.1.1.1) on x86_64 Linux and AIX, V11.1 Mod Pack 2 and Fix Pack 2 (V11.1.2.2) on Linux PPCLEx64, and V11.1 Mod Pack 4 and Fix Pack 4 (V11.1.4.4) on zLinux64. Customers use earlier versions need to download and install branded ODBC driver from this site . Customers on Windows servers are recommended to download and install ODBC driver manager from Microsoft and specified ODBC driver from data source vendors. Besides, GA users on AIX should download and install special build 35791 . GA users on X86_64 Linux should download and install special build 36035 .
4 Required MQ software is included as a supporting program.
5 Supported by Db2 V11.1 fixpack 1 (V11.1.1.1) or later.
6 Supported by Db2 V11.1 Mod Pack 2 and Fix Pack 2 (V11.1.2.2) or later.
7 This data source is a managed service that is always at its most current version.
8 Oracle MySQL Commercial and MySQL Enterprise servers are supported.
9 Supported by Db2 V11.1 Mod Pack 3 and Fix Pack 3 (V11.1.3.3) or later.
10 Required MariaDB ODBC driver version 2.0.15 is included in Db2 LUW starting from V11.1 fixpack 3 (V11.1.1.3) on x86_64 Linux.
11 Support both NET8 and ODBC wrappers to access this data source.
12 You are recommended to keep the server and client software at the same release number to ensure the maximum compatibility, and you also need to get the support from the data source provider to find the support matrix for different versions of the client and server software.
13 For ODBC wrapper, required IBM branded ODBC Oracle 8.0 driver is bundled in Db2 V11.1 Mod Pack 4 and Fix Pack 4 (V11.1.4.4) and later. Earlier users need to download and install latest ODBC driver from this site .
14 Supported by Db2 V11.1 Mod Pack 4 and Fix Pack 4 (V11.1.4.4) or later.
15 Required JDBC driver is included as a supporting program.
16 SAP HANA ODBC driver is required and users are recommended to download it from SAP.
17 Required libraries for connection and data parsing are included as a supporting program, no additional action required for customer.
Notes:
- For other data sources not listed in Table 1, customer can also use federation server to access them and perform basic operations like querying remote data via ODBC or JDBC drivers, as long as the required ODBC driver comply with ODBC 3.0 standard or the JDBC driver comply with 6.0 standard. They are listed in Table 2 as "Generic ODBC" and "Generic JDBC". But they are not optimized so there might be some data types and functions not supported well and the performance is not expected to be as good as the optimized data sources. For example, IBM InfoSphere Classic Federation Server for z/OS (IICF in short) can be accessed with ODBC driver provided by IICF, in which case IICF can serve as a gateway to host data sources such as IMS and VSAM.
- For all ODBC data sources, federation server needs an ODBC driver manager and specified ODBC drivers to access them.
- For Linux and Unix platforms, customers are recommended to use IBM-branded DataDirect ODBC driver manager and specified ODBC drivers included in IBM branded ODBC driver package(see annotation #3 above for details). And for data sources not supported by DataDirect ODBC drivers, customers can also download and install specified ODBC drivers from data source vendors to work with IBM-branded DataDirect ODBC driver manager.
- For Windows systems, IBM recommends using the ODBC driver manager from Microsoft and the ODBC driver from data source vendors.
Table 2. Availability of data source support on 32-bit and 64-bit operating systems.
This table shows whether or not a data source support is available on a certain operating system. It does not imply anything about the availability of data server or client software on that platform. To access the data source, the wrapper must be available on the operating system where Federation Server runs.
|
Hardware Architecture
|
X86-32
|
X86-32
|
X86-64
|
X86-64
|
Power
|
Itanium®
|
Power
Big Endian |
Power
Little Endian |
Sparc
|
zSeries®
|
|
Operating system
|
Linux
RHEL SUSE |
Windows
|
Linux
RHEL SUSE |
Windows
|
AIX®
|
HP-UX
|
Linux
RHEL SUSE |
Linux
RHEL SUSE |
Solaris
|
Linux
RHEL SUSE |
|
Data Source
|
||||||||||
| Apache Hive |
N
|
N
|
Y
|
N
|
Y
|
N
|
N
|
Y
|
N
|
N
|
| Apache Spark SQL |
N
|
N
|
Y
|
N
|
Y
|
N
|
N
|
Y
|
N
|
N
|
| Cloudera Impala |
N
|
N
|
Y
|
N
|
Y
|
N
|
N
|
Y
|
N
|
N
|
| CouchDB | N | N | Y | N | N | N | N | N | N | N |
| Generic JDBC | N | N | Y | Y | Y | N | N | N | N | Y |
| Generic ODBC | N | N | Y | Y | Y | N | N | Y | N | Y |
| Greenplum |
N
|
N
|
Y
|
N
|
Y
|
N
|
N
|
Y
|
N
|
N
|
| IBM Big SQL |
N
|
N
|
Y
|
Y
|
Y
|
N
|
N
|
Y
|
N
|
Y
|
| IBM Db2 Warehouse on Cloud |
N
|
N
|
Y
|
Y
|
Y
|
N
|
N
|
Y
|
N
|
Y
|
| IBM Db2 on Cloud |
N
|
N
|
Y
|
Y
|
Y
|
N
|
N
|
Y
|
N
|
Y
|
| IBM Db2 Warehouse |
N
|
N
|
Y
|
Y
|
Y
|
N
|
N
|
Y
|
N
|
Y
|
| IBM Db2 |
N
|
N
|
Y
|
Y
|
Y
|
N
|
N
|
Y
|
N
|
Y
|
| IBM Db2 for z/OS |
N
|
N
|
Y
|
Y
|
Y
|
N
|
N
|
Y
|
N
|
Y
|
| IBM Db2 for IBM i |
N
|
N
|
Y
|
Y
|
Y
|
N
|
N
|
Y
|
N
|
Y
|
| IBM Db2 Hosted |
N
|
N
|
Y
|
Y
|
Y
|
N
|
N
|
Y
|
N
|
Y
|
| IBM Db2 Server for VSE and VM |
N
|
N
|
Y
|
Y
|
Y
|
N
|
N
|
Y
|
N
|
Y
|
| IBM Integrated Analytics System |
N
|
N
|
Y
|
Y
|
Y
|
N
|
N
|
Y
|
N
|
Y
|
| IBM MQ |
N
|
N
|
Y
|
N
|
Y
|
N
|
N
|
N
|
N
|
Y
|
| IBM PureData System for Analytics |
N
|
N
|
Y
|
Y
|
Y
|
N
|
N
|
Y
|
N
|
Y
|
| IBM PureData System for Operational Analytics |
N
|
N
|
Y
|
Y
|
Y
|
N
|
N
|
Y
|
N
|
Y
|
| IBM PureData System for Transactions |
N
|
N
|
Y
|
Y
|
Y
|
N
|
N
|
Y
|
N
|
Y
|
| Informix |
N
|
N
|
Y
|
Y
|
Y
|
N
|
N
|
Y
|
N
|
Y
|
| MariaDB |
N
|
N
|
Y
|
N
|
N
|
N
|
N
|
N
|
N
|
N
|
| Microsoft Azure SQL Database |
N
|
N
|
Y
|
Y
|
Y
|
N
|
N
|
Y
|
N
|
Y
|
| Microsoft SQL Server | N | N | Y | Y | Y | N | N | Y | N | Y |
| MongoDB | N | N | Y | N | N | N | N | N | N | N |
| Netezza | N | N | Y | Y | Y | N | N | Y | N | Y |
| Oracle | N | N | Y | Y | Y | N | N | Y | N | Y |
| Oracle MySQL Enterprise Edition | N | N | Y | N | Y | N | N | Y | N | N |
| SAP HANA | N | N | Y | N | N | N | N | N | N | N |
| PostgreSQL |
N
|
N
|
Y
|
N
|
Y
|
N
|
N
|
Y
|
N
|
N
|
| Parquet on Hadoop | N | N | Y | N | N | N | N | N | N | N |
| SAP Sybase | N | N | Y | Y | Y | N | N | Y | N | N |
| Teradata | N | N | Y | Y | Y | N | N | N | N | Y |
Was this topic helpful?
Document Information
Modified date:
14 January 2021
UID
swg27049211