General Page

This document outlines the remote data sources supported by the federation capability in IBM Db2 version 12.1. It is designed for database administrators and IT professionals configuring federated access to heterogeneous data sources using various wrappers.

Federation Wrappers Overview

Federation in Db2 12.1 connects to remote data sources via wrappers—software layers (drivers, SDKs, or programs) handling vendor-specific communication. Wrappers may be built-in, IBM-provided, or sourced from vendors of the data source or third-parties.

Wrapper Types and Configuration

Some data sources are supported by more than one wrapper. For optimal performance and functionality, IBM recommends the following order for choice of wrappers - Native > ODBC > JDBC.

Native Wrapper: Best performance and functionality. Configuration Guide

ODBC Wrapper: Uses ODBC drivers. Configuration Guide

JDBC Wrapper: Uses JDBC drivers. Configuration Guide

NoSQL Wrapper: For NoSQL databases. Configuration Guide

Other Wrappers: For additional sources. Configuration Guide

Licensing

Federation is included in most Db2 editions (Advanced, Standard, Community) without additional licenses. See Db2 Product editions.

Accessing Db2 for IBM i, Db2 Server for VSE and VM, and Db2 for z/OS as data sources requires a Db2 Connect license. See Db2 Connect documentation.

Supported Data Sources

Some data sources require vendor-supplied software to complete the wrapper, while others are included with Db2. Tables 1 to 5 provide details of supported data sources, versions, dependent software, quick-start guides, and notes.

Some wrappers have limited availability on certain 64-bit operating systems due to dependencies on data source software. Table 6 shows the availability of wrappers on 64-bit operating systems.

Table 1: Native wrappers

Table 2: ODBC wrappers

Table 3: JDBC wrappers

Table 4: NoSQL wrappers

Table 5: Niche data sources

Table 6: Wrapper support on 64-bit operating systems

Native wrappers, versions, and software requirements

Table 1. Data sources supported by native wrappers, versions, and software requirements.

Data Source	Supported Versions	Dependent Data Source Software or Service	Notes
IBM Big SQL	5.0.4 and up	Integrated natively in Db2
IBM® Db2® Warehouse on Cloud (formerly dashDB for Analytics)	Managed Service	Integrated natively in Db2
IBM Db2 on Cloud (formerly dashDB for Transactions)	Managed Service	Integrated natively in Db2
IBM Db2 Warehouse (formerly dashDB Local)	Managed Service	Integrated natively in Db2
IBM Db2 for Linux, UNIX and Windows	11.5 and up	Integrated natively in Db2
IBM Db2 for IBM i®	7.4 and up	Db2 Connect License is required
IBM Db2 for z/OS®	12.x and up	Db2 Connect License is required
IBM Db2 Hosted (formerly DB2 on Cloud)	Managed Service	Integrated natively in Db2
IBM Db2 Server for VSE and VM	7.4, 7.5	Db2 Connect License is required
IBM Integrated Analytics System	Managed Service	Integrated natively in Db2
IBM MQ®	9.2.x and up	Integrated natively in Db2
Informix®	12.10 and up	Informix Client SDK version 4.50.xC1 or higher	Match client/server versions; consult vendor for support matrix
Microsoft SQL Server	2016, 2017, 2019, 2022	ODBC driver manager and SQL Server ODBC driver	Included on x86_64 Linux, AIX64, PPCLEx64, zLinux64; Windows download from Microsoft
Oracle	19c, 21c, 23ai	Oracle Database Client Software
SAP Sybase ASE	16.0	Sybase Open Client	Match client/server versions; consult vendor for support matrix
Teradata	17, 20	Shared Common Components for Internationalization for Teradata (tdicu), Teradata Generic Security Services (TeraGSS) And Teradata API library CLIv2	Match client/server versions; consult vendor for support matrix

ODBC wrapper, versions, and software requirements

Federation server needs an ODBC driver manager and specified ODBC drivers to access ODBC data sources.

On Linux and UNIX platforms, IBM recommends the use of IBM-branded DataDirect ODBC driver manager and the specific ODBC drivers included in the IBM-branded driver package. Db2 includes IBM-branded DataDirect ODBC driver manager on 64-bit Linux, AIX, PPCLE, and zLinux. Windows users must download and install the ODBC driver manager and drivers provided by Microsoft.

For other data sources, users must download and install supported ODBC drivers provided by the vendor to work with the included DataDirect ODBC driver manager. Other ODBC 3.0-compliant data sources may work but are not optimized.

Table 2. Data sources supported by ODBC wrapper, versions, and software requirements.

Data Source	Supported Versions	Dependent Data Source Software or Service	Notes
Apache Hive	CDP 7.1.x	ODBC driver manager and Hive ODBC driver	Driver included on x86_64 Linux, AIX64, PPCLEx64, zLinux64 Windows download from vendor
Apache Spark SQL	3.5 and up	ODBC driver manager and Spark ODBC driver	Driver included on x86_64 Linux, AIX64, PPCLEx64, zLinux64; Windows download from vendor
Amazon Aurora PostgreSQL	14.x, 15.x, 16.x	ODBC driver manager and PostgreSQL ODBC driver	Driver included on x86_64 Linux, AIX64, PPCLEx64, zLinux64 Windows download from vendor
Cloudera Impala	3.2, 3.4, 4.0	ODBC driver manager and Impala ODBC driver	Driver included on x86_64 Linux, AIX64, PPCLEx64, zLinux64; Windows download from vendor
Greenplum	5.x, 6.x	ODBC driver manager and Greenplum ODBC driver	Driver included on x86_64 Linux, AIX64, PPCLEx64, zLinux64; Windows download from vendor
MariaDB	10.x	ODBC driver manager and MariaDB ODBC driver	Driver included on x86_64 Linux; Other platforms download from vendor
Microsoft Azure SQL Database	Managed Service	ODBC driver manager and SQL Server ODBC driver	Driver included on x86_64 Linux, AIX64, PPCLEx64, zLinux64; Windows download from vendor
Microsoft SQL Server	2019, 2022	ODBC driver manager and SQL Server ODBC driver	Driver included on x86_64 Linux, AIX64, PPCLEx64, zLinux64; Windows download from vendor
Oracle MySQL Community Edition	8.0	ODBC driver manager and MariaDB ODBC driver	Driver included on x86_64 Linux; Other platforms download from vendor
Oracle MySQL Enterprise Edition	8.0	ODBC driver manager and MySQL ODBC driver	Driver included on x86_64 Linux, AIX64, PPCLEx64, zLinux64; Windows download from vendor
Oracle	19c, 21c, 23ai	ODBC driver manager and Oracle ODBC driver	Driver included on x86_64 Linux, AIX64, PPCLEx64, zLinux64; Windows download from vendor
PostgreSQL	13.x, 14.x, 15.x, 16.x	ODBC driver manager and PostgreSQL ODBC driver	Driver included on x86_64 Linux, AIX64, PPCLEx64, zLinux64; Windows download from vendor
SAP HANA	2.0	ODBC driver manager and HANA ODBC Driver	Driver not included, download from vendor
Snowflake	Managed Service	ODBC driver manager and Snowflake ODBC Driver	Driver not included, download from vendor
Cassandra	4.1	ODBC driver manager and Cassandra ODBC Driver	Cassandra is supported starting Db2 12.1.2 Driver included on x86_64 Linux, AIX64, PPCLEx64, zLinux64; Windows download from vendor

JDBC wrapper, versions, and software requirements

Federation server needs a JDBC driver manager and specified JDBC drivers to access JDBC data sources.

Other JDBC 4.0-compliant data sources may work but are not optimized.

Table 3. Data sources supported by JDBC wrapper, versions, and software requirements.

Data Source	Supported Versions	Dependent Data Source Software or Service	Notes
Amazon Athena	Managed Service	Athena JDBC driver	Driver not included, download from vendor.
Amazon RedShift	Managed Service	RedShift JDBC driver	Driver included on x86_64 Linux; Other platforms download from vendor
Amazon Aurora PostgreSQL	14.x, 15.x, 16.x	PostgreSQL JDBC driver	Driver included on x86_64 Linux, AIX64; other platforms download from vendor
Apache Derby	10.8	Derby JDBC driver	Driver not included, download from vendor
Apache Hive	CDP 7.1.x	Hive JDBC driver	Driver included on x86_64 Linux, AIX64; other platforms download from vendor
Apache Spark SQL	3.5 and up	Spark JDBC driver	Driver included on x86_64 Linux, AIX64; other platforms download from vendor
Autonomous RESTful Services	Managed Service	Restful JDBC driver	Driver included on x86_64 Linux, AIX64; other platforms download from vendor
Cloudera Impala	3.2, 3.4, 4.0	Impala JDBC driver	Driver included on x86_64 Linux, AIX64; other platforms download from vendor
DVM server	1.1.0, 1.2.0	DVM JDBC driver	Driver included on x86_64 Linux, AIX64; other platforms download from vendor
BigQuery	Managed Service	BigQuery JDBC driver	Driver included on x86_64 Linux, AIX64; other platforms download from vendor
IBM Db2	11.5, 12.1	Integrated natively in Db2
IBM Db2 for z/OS®	12.x and up		Db2 Connect License is required.
IBM Watsonx.data	1.0.1, 1.0.3, 1.1.1, 1.1.3	Presto JDBC driver
MariaDB	10.x	MariaDB JDBC driver	Driver not included, download from vendor
Microsoft SQL Server	2019, 2022	SQL Server JDBC driver	Driver included on x86_64 Linux, AIX64; other platforms download from vendor
Oracle	19c, 21c	Oracle JDBC driver	Driver included on x86_64 Linux, AIX64; other platforms download from vendor
Oracle MySQL Community Edition	8.0	MariaDB JDBC driver	Driver not included, download from vendor
Oracle MySQL Enterprise Edition	8.0	MySQL JDBC driver	Driver included on x86_64 Linux, AIX64; other platforms download from vendor
Pivotal Greenplum	5.x, 6.x, 7.x	Greenplum JDBC driver	Driver included on x86_64 Linux, AIX64; other platforms download from vendor
PostgreSQL	13.x, 14.x, 15.x, 16.x	PostgreSQL JDBC driver	Driver included on x86_64 Linux, AIX64; other platforms download from vendor
Salesforce	Managed Service	Salesforce JDBC driver	Driver included on x86_64 Linux, AIX64; other platforms download from vendor
SAP HANA	2.0	HANA JDBC driver	Driver not included, download from vendor
Snowflake	Managed Service	Snowflake JDBC driver	Driver not included, download from vendor
Teradata	17, 20	Teradata JDBC driver	Driver not included, download from vendor
Cassandra	4.1	Cassandra JDBC driver	Cassandra is supported starting Db2 12.1.3 Driver included on x86_64 Linux, AIX64, PPCLEx64, zLinux64; Windows download from vendor

NoSQL wrapper, versions, and software requirements

Table 4. Data sources supported by NoSQL wrapper, versions, and software requirements.

Data Source	Supported Versions	Dependent Data Source Software or Service	Notes
CouchDB	3.3.x and 3.4.x	Integrated natively in Db2	Connection and parsing libraries included.
MongoDB	5.0, 6.0, 7.0, 8.0	Eve RESTful service deployed with MongoDB
Parquet on Hadoop	2.9.0	Integrated natively in Db2	Connection and parsing libraries included.

Other data sources, versions, and software requirements

Table 5. Data sources supported by other data sources, versions, and software requirement

Data Source	Supported Versions	Dependent Data Source Software or Service	Notes
BioRS	5.2, 5.3	Integrated natively in Db2	Connection and parsing libraries included.
Web Services	WSDL 1.0, 1.1, 2.0 SOAP 1.0, 1.1, 1.2	Integrated natively in Db2	Connection and parsing libraries included.
XML	XML 1.0, XML 1.1	Integrated natively in Db2	Connection and parsing libraries included.

Wrapper support on 64-bit operating systems

Table 6. shows the availability of wrappers on 64-bit operating systems. Certain wrappers are not available on all operating systems due to the availability of dependent data source software.

This table shows whether or not a wrapper 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-64	X86-64	Power	Power Little Endian	zSeries®
Operating system	Linux RHEL SUSE	Windows	AIX®	Linux RHEL SUSE	Linux RHEL SUSE
Wrapper
CTLIB(for Sybase)	Y	Y	Y	N	N
DRDA	Y	Y	Y	Y	Y
INFORMIX	Y	Y	Y	N	Y
JDBC	Y	Y	Y	Y	Y
MSSQLODBC3(for SQL Server)	Y	Y	Y	Y	Y
NET8(for Oracle)	Y	Y	Y	Y	Y
NoSQL	Y	N	N	N	N
ODBC	Y	Y	Y	Y	Y
TERADATA	Y	Y	Y	N	Y

[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"ARM Category":[{"code":"a8m500000008PkvAAE","label":"Connectivity-\u003EFederation"}],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"12.1.0;12.1.1"}]

Tips

Data Source Support Matrix of Federation Bundled in Db2 12.1