IBM Support

Federation Supported Data Sources for IBM Integrated Analytics System

Product Documentation


Abstract

This document shows all the data sources supported by federation capability which is part of IBM Integrated Analytics System.

Content

Below table includes all the data sources supported by federation capability which is part of IBM Integrated Analytics System

Table 1. Supported data sources and versions.

Data Source Supported Versions
Apache Hive V1.2.1 and later
Apache Spark SQL V1.5 and later
Cloudera Impala V2.7 and later
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 LUW 9.7, 9.8, 10.1, 10.5, 11.1, 11.5
IBM Db2 for IBM i® 6.1, 7.1
IBM Db2 for z/OS® 9.x, 10.x, 11.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 Analytics (formerly Netezza) 6.x, 7.x
IBM PureData System for Operational Analytics 1.1
IBM PureData System for Transactions 10.x
Microsoft SQL Server 2012, 2104, 2016
Oracle MySQL2 5.0, 5.1, 5.5, 5.6
Oracle 11gR1, 11gR2, 12cR1
PostgreSQL 9.0, 9.1, 9.2, 9.3, 9.4, 9.5, 9.6
1 This data source is a managed service that is always at its most current version.
2 Oracle MySQL Commercial and MySQL Enterprise servers are supported.

[{"Product":{"code":"SS2K5T","label":"InfoSphere Federation Server"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Federated Server","Platform":[{"code":"PF016","label":"Linux"}],"Version":"11.1","Edition":"All Editions","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
19 January 2020

UID

swg27050562