White Papers
Abstract
This page lists the remote data sources that can be accessed using the built-in federation capability of IBM Integrated Analytics System.
Content
Federation Server Bundled in IBM Integrated Analytics System supports Db2 native wrapper, ODBC wrapper, SQL Server native wrapper and Oracle native wrapper.
Data sources supported by Db2 native wrapper(listed in Table 1) and some data sources supported by ODBC wrapper(listed in Table 2) are configured automatically while deployment. User can create federated objects to access them directly.
To configure ODBC wrapper to access the data sources listed in Table 3 or to configure SQL Server native wrapper to access SQL Server data source, please refer to How to configure MSSQLODBC3 wrapper and ODBC wrapper to access certain data sources?.
To configure Oracle native wrapper to access Oracle data source, please refer to How does Federation Server connect to Oracle data source via Instant Client?.
Table 1. Data sources supported by the Db2 native wrapper.
| Data Source | Supported Versions |
| IBM Big SQL | 3.0 and later |
| IBM Db2 Warehouse on Cloud (formerly dashDB for Analytics) | (not applicable)1 |
| IBM Db2 on Cloud (formerly dashDB for Transactions) | (not applicable)1 |
| IBM Db2 Warehouse (formerly dashDB Local) | (not applicable)1 |
| IBM Db2 for IBM i® | 6.1, 7.1, 7.2, 7.3 |
| IBM Db2 for LUW | 9.7, 9.8, 10.1, 10.5, 11.1, 11.5 |
| IBM Db2 for z/OS® | 9.x, 10.x, 11.x, 12.x |
| IBM Db2 Hosted (formerly Db2 on Cloud) | (not applicable)1 |
| IBM Db2 Server for VSE and VM | 7.4, 7.5 |
| IBM Integrated Analytics System | (not applicable)1 |
| IBM PureData System for Operational Analytics | 1.1 |
| IBM PureData System for Transactions | 10.x |
Table 2. Data sources supported by the ODBC wrapper that are configurated automatically.
| Data Source | Supported Versions |
| 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
|
| Apache Spark SQL | 1.6.2, 1.6.3, 2.0.0, 2.1.1 |
| Cloudera Impala | 2.7.0 |
| Greenplum | 5.0 |
| IBM PureData System for Analytics (formerly Netezza) | 6.x, 7.x |
| Microsoft Azure SQL Database | (not applicable)2 |
| Microsoft SQL Server | 2012, 2014, 2016, 20171, 20191 |
| Oracle MySQL Enterprise Edition | 5.7 |
| Oracle | 11gR2, 12cR1, 12cR2, 18c, 19c1 |
| PostgreSQL | 9.x, 10.x |
1 This version is supported from IIAS 1.0.23.0 GA.
2 This data source is a managed service that is always at its most current version.
Table 3. Data sources supported by the ODBC wrapper that need manual configuration.
| Data Source | Supported Versions |
| MariaDB1 | 10.x |
| SAP HANA2 | 1.6.2, 1.6.3, 2.0.0, 2.1.1 |
1 Required MariaDB ODBC driver is not included. Customers are recommended to download it from data source vendor.
2 Required SAP HANA ODBC driver is not included. Customers are recommended to download it from data source vendor.
Was this topic helpful?
Document Information
Modified date:
26 April 2021
UID
ibm16435661