Data Source Support Matrix of Federation Bundled in Big SQL V5.0.2

When configuring a wrapper, a software layer (driver, SDK, or standalone program) is required to handle the vendor-specific communication with the data source. This layer can be built into Federation, provided with Big SQL on the media by IBM, or in some cases, provided by the vendor of the data source or another third party.

The following 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.

Table 1. Supported data sources, versions, and software requirements.

Data Source	Supported Versions	Dependent Data Source Software
Apache Hive	V1.2.1 and later	IBM Branded ODBC driver package2,4
Cloudera Impala	V2.7 and later	IBM Branded ODBC driver package2,4
Generic ODBC	(not applicable)	See notes below
Generic JDBC	(not applicable)	See notes below
IBM Big SQL	3.0 and later	None1
IBM® Db2® Warehouse on Cloud (formerly dashDB for Analytics)	(not applicable)3	None1
IBM Db2 on Cloud (formerly dashDB for Transactions)	(not applicable)3	None1
IBM Db2 Warehouse (formerly dashDB Local)	(not applicable)3	None1
IBM Db2 LUW	9.7, 9.8, 10.1, 10.5, 11.1	None1
IBM Db2 for IBM i®	6.1, 7.1	None1
IBM Db2 for z/OS®	9.x, 10.x, 11.x	None1
IBM Db2 Server for VSE and VM	7.4, 7.5	None1
IBM Integrated Analytics System	(not applicable)3	None1
IBM PureData System for Analytics (formerly Netezza)	6.x, 7.x	Netezza ODBC driver IBM Branded ODBC driver package
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
Microsoft SQL Server	2012, 2104, 2016	IBM Branded ODBC driver package2
Oracle MySQL Enterprise Edition	5.0, 5.1, 5.5, 5.6	IBM Branded ODBC driver package2,4
Oracle	11gR1, 11gR2, 12cR1	IBM Branded ODBC driver package2
PostgreSQL	9.0, 9.1, 9.2, 9.3, 9.4, 9.5, 9.6	IBM Branded ODBC driver package2,4
Teradata	13, 14, 15	Shared Common Components for Internationalization for Teradata (tdicu) Teradata Generic Security Services (TeraGSS) Teradata API library CLIv2

¹ Db2 Connect is included as a supporting program for the purpose of accessing this data source.

² IBM branded ODBC driver package is included in Big SQL starting from V5.0 on x86_64 Linux.

³ This data source is a managed service that is always at its most current version.
⁴ See configuring ODBC access and restrictions on the Configuring Data Source page.

Notes:
• Other data sources can also be accessed through ODBC or JDBC drivers, if the required ODBC driver complies with the ODBC 3.0 standard, or the JDBC driver complies with the 6.0 standard. For example, IBM InfoSphere Classic Federation Server for z/OS (IICF in short) can be accessed with the ODBC driver that is provided by IICF. In this case, IICF can serve as a gateway to host data sources such as IMS and VSAM.
• For some Linux and UNIX systems (details in Table 2), Big SQL includes an IBM-branded DataDirect ODBC driver manager and ODBC drivers for some ODBC data sources. However, other ODBC data sources, such as MariaDB, require the use of ODBC drivers that are provided by the vendors.

• Tentative - while Big SQL technically supports many sources they have not all been tested.

Table 2. Availability of data source support on 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-64	Power Little Endian
Data Source	Linux RHEL SUSE	Linux RHEL SUSE
Apache Hive	Y	Y
Cloudera Impala	Y	Y
Generic JDBC	Y	Y
Generic ODBC	Y	Y
IBM Big SQL	Y	Y
IBM Db2 Warehouse on Cloud	Y	Y
IBM Db2 on Cloud	Y	Y
IBM Db2 Warehouse	Y	Y
IBM Db2 LUW	Y	Y
IBM Db2 for IBM i	Y	Y
IBM Db2 for z/OS	Y	Y
IBM Db2 Server for VSE and VM	Y	Y
IBM Integrated Analytics System	Y	Y
IBM PureData System for Analytics	Y	Y
IBM PureData System for Operational Analytics	Y	Y
IBM PureData System for Transactions	Y	Y
Informix	Y	Y
Microsoft SQL Server	Y	Y
Netezza	Y	Y
Oracle	Y	Y
Oracle MySQL Enterprise Edition	Y	Y
PostgreSQL	Y	Y
Teradata	Y	Y