Db2 (On Premises and Cloud)

Data Source Support Matrix of Federation Bundled in Db2 LUW V11.5

  • 1.  Data Source Support Matrix of Federation Bundled in Db2 LUW V11.5

    Posted Mon May 10, 2021 10:23 AM

    Product Documentation


    Abstract

    This page lists the remote data sources that can be accessed using the built-in federation capability of Db2 LUW V11.5.

    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.

    Table 1-5 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. Some data sources are supported by more than one wrappers. In most case, the main differences among them are the communication method to access data source and the required software layer. Usually the native wrappers have less limitations and support more functions. For more details about configuring access to data sources through certain wrappers, please refer to the following pages in IBM Knowledge Center.

    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.


    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 Informix Client SDK version 3.0 or higher6
    Microsoft SQL Server 2012, 2014, 2016, 20174, 20194 ODBC driver manager and SQL Server ODBC driver5
    Oracle 11gR2, 12cR1, 12cR2, 18c, 19c4

    Oracle Database Client Software6

      SAP Sybase ASE 15.5, 15.7, 16.0 Sybase Open Client6
      Teradata 13, 14, 15, 16
      Shared Common Components for Internationalization for Teradata (tdicu), Teradata Generic Security Services (TeraGSS)
      and Teradata API library CLIv26

      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 its most current version.

      3 Required MQ software is included as a supporting program.

      4 This version is supported from Db2 11.5.4.

      5 Required ODBC driver manager and SQL Server ODBC driver are included in Db2 LUW on x86_64 Linux, AIX64, PPCLEx64 and zLinux64. Customers on Windows servers are recommended to download and install them from Microsoft.

      6  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.


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

      Data Source Supported Versions Dependent Data Source Software or Service Quick Start
      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.01, 3.11
      ODBC driver manager3 and Hive ODBC driver4
      The sample for Hive
      Apache Spark SQL 1.6.2, 1.6.3, 2.0.0, 2.1.1
      ODBC driver manager3 and Spark ODBC driver4
      The sample for Spark SQL
      Cloudera Impala 2.7.0
      ODBC driver manager3 and Impala ODBC driver4
      The sample for Impala
      Greenplum 5.0
      ODBC driver manager3 and Greenplum ODBC driver4
      The sample for Greenplum
      IBM PureData System for Analytics (formerly Netezza) 6.x, 7.x
      ODBC driver manager3 and Netezza ODBC driver4
      The sample for PureData System
      MariaDB 10.x
      ODBC driver manager3 and MariaDB ODBC driver5
      The sample for MariaDB
      Microsoft Azure SQL Database (not applicable)2
      ODBC driver manager3 and SQL Server ODBC driver4
       -8
      Microsoft SQL Server 2012, 2014, 2016, 20171, 20191
      ODBC driver manager3 and SQL Server ODBC driver4
      The sample for SQL Server
      Oracle MySQL Community Edition7 8.0 ODBC driver manager3 and MariaDB ODBC driver5 The sample for MySQL CE
      Oracle MySQL Enterprise Edition 5.7
      ODBC driver manager3 and MySQL ODBC driver4
      The sample for MySQL EE
      Oracle 11gR2, 12cR1, 12cR2, 18c, 19c1
      ODBC driver manager3 and Oracle ODBC driver4
        The sample for Oracle
        PostgreSQL 9.x, 10.x, 11.x
        ODBC driver manager3 and PostgreSQL ODBC driver4
        The sample for PostgreSQL
        SAP HANA 2.0
        ODBC driver manager3 and HANA ODBC Driver6
        The sample for SAP Hana
        Snowflake7 (not applicable)2 ODBC driver manager3 and Snowflake ODBC Driver6  -8

        1 This version is supported from Db2 11.5.4.

        2 This data source is a managed service that is always at its most current version.

        3 IBM branded DataDirect ODBC driver manager is included in Db2 LUW on x86_64 Linux, AIX64, PPCLEx64 and zLinux64. Customers on Windows servers are recommended to download and install the ODBC driver manager from Microsoft.

        4 Required specified ODBC driver is included in Db2 LUW on x86_64 Linux, AIX64, PPCLEx64 and zLinux64. Customers on Windows servers are recommended to download the specified ODBC driver from data source vendor.

        5 Required MariaDB ODBC driver is included in Db2 LUW on x86_64 Linux. Customers on other platforms are recommended to download it from data source vendor.

        6 The specified ODBC driver is required but not included. Customers are recommended to download it from data source vendor.

        7 This version is supported from Db2 11.5.5.

        8 This section is being written.

        Notes:

        • For other data sources not listed in Table 2, customer can also use federation server to access them and perform basic operations like querying remote data via ODBC wrapper, as long as the required ODBC driver comply with ODBC 3.0 standard. 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 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 #2 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.

        Table 3. Data sources supported by 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 JDBC wrapper, versions, and software requirements.

        Data Source Supported Versions Dependent Data Source Software or Service Quick Start
        Amazon Athena1 (not applicable)5 Athena JDBC driver2 The sample for Athena
        Amazon RedShift1 (not applicable)5 RedShift JDBC driver3 The sample for RedShift
        Apache Derby1 10.8 Derby JDBC driver2 The sample for Apache Derby
        Apache Hive1
        Hive with HDP 2.6
        Hive JDBC driver3 The sample for Apache Hive
        DVM server1 1.1.0 DVM JDBC driver3 The sample for DVM server
        Google BigQuery1 (not applicable)5 BigQuery JDBC driver3 The sample for BigQuery
        IBM Db2 for LUW1 11.1 and later None4 The sample for Db2 for LUW
        IBM Db2 for z/OS®1 11.x, 12.x None4 The sample for Db2 for z/OS
        IBM PureData® System for Analytics (formerly Netezza®)1 7.1, 7.2 Netezza JDBC driver2 The sample for Netezza
        MariaDB1 10.x MariaDB JDBC driver2 The sample for MariaDB
        Microsoft SQL Server1 2014 and later SQL Server JDBC driver3 The sample for SQL Server
        Oracle1 12cr2 and later Oracle JDBC driver3 The sample for Oracle
        Oracle MySQL Community Edition1 5.7 MariaDB JDBC driver2 The sample for MySQL CE
        Oracle MySQL Enterprise Edition1 5.7 MySQL JDBC driver3 The sample for MySQL EE
        Pivotal Greenplum1 5.0 Greenplum JDBC driver3 The sample for Greenplum
        PostgreSQL1 9.x, 10.x, 11.x PostgreSQL JDBC driver3 The sample for PostgreSQL
        Salesforce1 (not applicable)5 Salesforce JDBC driver3 The sample for Salesforce
        SAP HANA1 2.0 HANA JDBC driver2 The sample for SAP Hana
        Snowflake6 (not applicable)5 Snowflake JDBC driver2 The sample for Snowflake
        Teradata 14, 15, 16 Teradata JDBC driver2 The sample for Teradata
        Autonomous RESTful Services (not applicable)5 Restful JDBC driver3 The sample for RESTful Services

        1 This data source is supported from Db2 11.5.4.

        2 The specified JDBC driver is required but not included. Customers are recommended to download it from data source vendor.

        3 The required JDBC driver is included in Db2 LUW on x86_64 Linux and AIX64. Customers on other platforms are recommended to download it from data source vendor.

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

        5 This data source is a managed service that is always at its most current version.

        6 This data source is supported from Db2 11.5.5.

        Notes:

        • For other data sources not listed in Table 4, customer can also use federation server to access them and perform basic operations like querying remote data via JDBC wrapper, as long as the required JDBC driver comply with 6.0 standard. 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.

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

        Data Source Supported Versions Dependent Data Source Software or Service
        BioRS 5.2, 5.3 None1
        Web Services
        WSDL 1.0, 1.1
        SOAP 1.0, 1.1
        None1
        XML XML 1.0, XML 1.1 None1

        1 Required libraries for connection and data parsing are included as a supporting program, no additional action required for customer.

        Table 6. Availability of wrapper support on 64-bit operating systems.

        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


        ------------------------------
        Hai Jun Shen
        ------------------------------