White Papers
Abstract
This page lists the remote data sources that can be accessed by using the built-in federation capability of IBM Db2 Big SQL V7.0.0.
Content
When you configure 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 or, in some cases, provided by the vendor of the data source or other third party.
Tables 1-4 show 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. Some data sources are supported by more than one wrapper. In most cases, the main differences among them are the communication method that is needed to access the data source and the required software layer. Native wrappers usually have fewer limitations and support more functions. For more details about configuring access to data sources through certain wrappers, see the following pages in the IBM Knowledge Center:
Configuring access to data sources through ODBC wrapper
Configuring access to data sources through NoSQL wrapper
Configuring access to data sources through JDBC wrapper
Table 1. Data sources supported by native wrappers, versions, and software requirements
| Data Source | Supported Versions | Dependent Data Source Software or Service |
| IBM Big SQL | 3.0 and later | None1 |
| IBM® Db2® Warehouse on Cloud (formerly dashDB for Analytics) | (not applicable)2 | None1 |
| IBM Db2 on Cloud (formerly dashDB for Transactions) | (not applicable)2 | None1 |
| IBM Db2 Warehouse (formerly dashDB Local) | (not applicable)2 | None1 |
| IBM Db2 for LUW | 9.7, 9.8, 10.1, 10.5, 11.1, 11.5 | None1 |
| IBM Db2 for IBM i® | 6.1, 7.1, 7.2, 7.3 | None1 |
| IBM Db2 for z/OS® | 9.x, 10.x, 11.x, 12.x | None1 |
| IBM Db2 Hosted (formerly DB2 on Cloud) | (not applicable)2 | None1 |
| IBM Db2 Server for VSE and VM | 7.4, 7.5 | None1 |
| IBM Integrated Analytics System | (not applicable)2 | None1 |
| IBM MQ® | 7, 7.01, 8.x | None3 |
| IBM PureData System for Operational Analytics | 1.1 | None1 |
| IBM PureData System for Transactions | 10.x | None1 |
| Informix® | 11.5, 11.7, 12.10, 14.10 | Informix Client SDK version 3.0 or higher5 |
| Microsoft SQL Server | 2012, 2014, 2016, 2017, 2019 | ODBC driver manager and SQL Server ODBC driver4 |
| Oracle | 11gR2, 12cR1, 12cR2, 18c, 19c |
Oracle Database Client Software5 |
| SAP Sybase ASE | 15.5, 15.7, 16.0 | Sybase Open Client5 |
| Teradata | 13, 14, 15, 16 |
Shared Common Components for Internationalization for Teradata (tdicu), Teradata Generic Security Services (TeraGSS)
and Teradata API library CLIv25
|
1 Db2 Connect is included as a supporting program for the purpose of accessing this data source.
2 This data source is a managed service that is always at the current version.
3 Required MQ software is included as a supporting program.
4 Required ODBC driver manager and SQL Server ODBC driver are included on x86_64 Linux and PPCLEx64.
5 Be sure to keep the server and client software at the same release number for maximum compatibility. Obtain the support matrix for different versions of the client and server software from the data source provider.
Table 2. Data sources supported by the ODBC wrapper, versions, and software requirements
| Data Source | Supported Versions | Dependent Data Source Software or Service |
| Apache Hive |
Hive with CDH 5.7, 5.10, 5.11, 5.12, 5.13
Hive with HDP 2.4, 2.5, 2.6, 3.0, 3.1
|
ODBC driver manager2 and Hive ODBC driver3
|
| Apache Spark SQL | 1.6.2, 1.6.3, 2.0.0, 2.1.1 |
ODBC driver manager2 and Spark ODBC driver3
|
| Cloudera Impala | 2.7.0 |
ODBC driver manager2 and Impala ODBC driver3
|
| Greenplum | 5.0 |
ODBC driver manager2 and Greenplum ODBC driver3
|
| IBM PureData System for Analytics (formerly Netezza) | 6.x, 7.x |
ODBC driver manager2 and Netezza ODBC driver3
|
| MariaDB | 10.x |
ODBC driver manager2 and MariaDB ODBC driver4
|
| Microsoft Azure SQL Database | (not applicable)1 |
ODBC driver manager2 and SQL Server ODBC driver3
|
| Microsoft SQL Server | 2012, 2014, 2016, 2017, 2019 |
ODBC driver manager2 and SQL Server ODBC driver3
|
| Oracle MySQL Enterprise Edition | 5.7 |
ODBC driver manager2 and MySQL ODBC driver3
|
| Oracle | 11gR2, 12cR1, 12cR2, 18c, 19c |
ODBC driver manager2 and Oracle ODBC driver3
|
| PostgreSQL | 9.x |
ODBC driver manager2 and PostgreSQL ODBC driver3
|
| SAP HANA | 2.0 |
ODBC driver manager2 and HANA ODBC Driver5
|
1 This data source is a managed service that is always at the current version.
2 IBM branded DataDirect ODBC driver manager is included on x86_64 Linux and PPCLEx64.
3 Required specified ODBC driver is included on x86_64 Linux and PPCLEx64.
4 Required MariaDB ODBC driver is included on x86_64 Linux. For other platforms, download it from the data source vendor.
5 HANA ODBC driver is required but not included. Download it from SAP.
Notes:
- For other data sources not listed in Table 2, use the federation server to access them and to perform basic operations such as querying remote data via the ODBC wrapper, as long as the required ODBC driver complies with the ODBC 3.0 standard. Because such data sources are not optimized, some data types and functions might not be supported well, and performance is not expected to be as good as that for optimized data sources.
- The federation server needs an ODBC driver manager and specified ODBC drivers to access all ODBC data sources.
- Be sure to use the included IBM-branded DataDirect ODBC driver manager and specified ODBC drivers. For data sources that are not supported by DataDirect ODBC drivers, download and install specified ODBC drivers from data source vendors to work with the IBM-branded DataDirect ODBC driver manager.
Table 3. Data sources supported by the NoSQL wrapper, versions, and software requirements
| Data Source | Supported Versions | Dependent Data Source Software or Service |
| CouchDB | 2.0.0, 2.1.0, 2.2.0 | None1 |
| MongoDB | 3.0, 3.2, 3.4 | Eve RESTful service deployed with MongoDB |
| Parquet on Hadoop | 2.9.0 | None1 |
1 Required libraries for connection and data parsing are included as a supporting program.
Table 4. Data sources supported by the JDBC wrapper, versions, and software requirements
| Data Source | Supported Versions | Dependent Data Source Software or Service |
| Amazon Athena | (not applicable)1 | Athena JDBC driver2 |
| Amazon RedShift | (not applicable)1 | RedShift JDBC driver3 |
| Apache Derby | 10.8 | Derby JDBC driver2 |
| Apache Hive |
Hive with HDP 2.6
|
Hive JDBC driver3 |
| DVM server | 1.1.0 | DVM JDBC driver3 |
| Google BigQuery | (not applicable)1 | BigQuery JDBC driver3 |
| IBM Db2 for LUW | 11.1 and later | None4 |
| IBM Db2 for z/OS® | 11.x, 12.x | None4 |
| IBM PureData® System for Analytics (formerly Netezza®) | 7.1, 7.2 | Netezza JDBC driver2 |
| MariaDB | 10.x | MariaDB JDBC driver2 |
| Microsoft SQL Server | 2014 and later | SQL Server JDBC driver3 |
| Oracle | 12cr2 and later | Oracle JDBC driver3 |
| Oracle MySQL Community Edition | 5.7 | MariaDB JDBC driver2 |
| Oracle MySQL Enterprise Edition | 5.7 | MySQL JDBC driver3 |
| Pivotal Greenplum | 5.0 | Greenplum JDBC driver3 |
| PostgreSQL | 9.x | PostgreSQL JDBC driver3 |
| SAP HANA | 2.0 | HANA JDBC driver2 |
| Salesforce | (not applicable)1 | Salesforce JDBC driver3 |
| Teradata | 14, 15, 16 | Teradata JDBC driver2 |
1 This data source is a managed service that is always at the current version.
2 The specified JDBC driver is required but not included. Download it from the data source vendor.
3 The required JDBC driver is included on x86_64 Linux. For other platforms, download it from the data source vendor.
4 Db2 Connect is included as a supporting program for the purpose of accessing this data source.
Notes:
- For other data sources not listed in Table 4, use the federation server to access them and to perform basic operations such as querying remote data via the JDBC wrapper, as long as the required JDBC driver complies with the 6.0 standard. Because such data sources are not optimized, some some data types and functions might not be supported well, and performance is not expected to be as good as that for optimized data sources.
The following table shows whether or not 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 the federation server runs.
Table 5. Availability of wrapper support on 64-bit operating systems
|
Hardware Architecture
|
X86-64
|
Power
Little Endian |
|
Operating system
|
Linux
RHEL SUSE |
Linux
RHEL SUSE |
|
CTLIB(for Sybase)
|
Y
|
N
|
| DRDA |
Y
|
Y
|
| INFORMIX |
Y
|
N
|
| JDBC | Y | Y |
|
MSSQLODBC3(for SQL Server)
|
Y | Y |
|
NET8(for Oracle)
|
Y | Y |
| NoSQL |
Y
|
N
|
| ODBC |
Y
|
Y
|
| TERADATA |
Y
|
N
|
Was this topic helpful?
Document Information
Modified date:
08 April 2021
UID
ibm16258191