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

Content

When configuring a wrapper, a software layer (driver, SDK, or stand-alone program) is required that handles the vendor-specific communication with the data source. This layer can 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 wrapper. 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 fewer limitations and support more functions. For more details about configuring access to data sources through certain wrappers, refer to the following pages in IBM Documentation.

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

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

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

³ Required MQ software is included as a supporting program.

⁴ This version is supported from Db2 11.5.4.

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

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

⁷ This section is being written.

⁸ This version is supported from Db2 11.5.7.

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

¹ This version is supported from Db2 11.5.4.

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

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

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

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

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

⁷ This version is supported from Db2 11.5.5.

⁸ This section is being written.

⁹ This version is supported from Db2 11.5.6.

¹⁰ This version is supported from Db2 11.5.8.  Db2 federation is tolerant support for PostgreSQL v13, V14, V15, including connection, basic data types and functions pushdown.

¹¹ This version is fully supported from Db2 11.5.9.

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.

¹ Required libraries for connection and data parsing are included as a supporting program.

² MongoDB version 4.x version is supported from Db2 11.5.8.

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

¹ This data source is supported from Db2 11.5.4.

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

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

⁴ Db2 Connect is included as a supporting program for accessing this data source.

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

⁶ This data source is supported from Db2 11.5.5.

⁷ This data source is supported from Db2 11.5.6.

⁸ This data source is supported from Db2 11.5.8.  Db2 federation is tolerant support for PostgreSQL v12, v13, V14, V15, including connection, basic data types and functions pushdown.

⁹ This data source is fully supported from Db2 11.5.9. The Presto JDBC driver presto-jdbc-0.282.jar is bunlded into Db2 v11.5.9.

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

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