IBM Support

InfoSphere Federation Server Version 10.5 data source requirements

Product Documentation


Abstract

The supported data sources of IBM® InfoSphere™ Federation Server are shown in the following tables.

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 InfoSphere Federation Server, provided by IBM on the media with InfoSphere Federation Server, or in some cases, provided by the vendor of the data source or other third party.


The first table 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 IBM InfoSphere Federation Server for the data sources that you want to access.

The second table shows the availability of wrappers on 32-bit and 64-bit operating systems. Certain wrappers are not available on all operating systems due to the availability of dependent data source software.

Table 1. Supported data sources, versions, and software requirements.

Data Source
Supported Versions
Additional dependent data source software
BioRS7 5.2, 5.3 None
CA-Datacom 10, 11 Classic Federation Server for z/OS
CA-IDMS 16, 17 Classic Federation Server for z/OS
DB2 for Linux®, UNIX®, and Windows® 9.7, 9.8, 10.1, 10.5 None
DB2 for z/OS® 8.x7, 9.x, 10.x None1
DB2 for System i® 5.27, 5.37, 5.4, 6.1, 7.1 None1
DB2 Server for VSE and VM 7.4, 7.5 None1
IMS 10.1, 11.1 Classic Federation Server for z/OS
Informix® 11.17, 11.5, 11.7, 12.10 Informix Client SDK version 3.0 or higher
JDBC 3.0 or later JDBC drivers and manager comply with JDBC 3.0 or later
Microsoft® Excel7 2003, 2007,2010 None2
Microsoft SQL Server 20057, 20087, 2008R27, 2012
20146
None3
MQ MQ7, MQ7.01 None4
Netezza 4.67, 5.07, 6.0, 7.0 Netezza ODBC driver
ODBC 3.0 or later ODBC driver5
Oracle 11g7, 11gR17, 11gR2
12cR16, 12cR29

Oracle Database Client Software10

Sybase Sybase ASE 15.0, 15.5, 15.7 Sybase Open Client10
Teradata 127, 13, 14
156, 168
Shared Common Components for Internationalization for Teradata (tdicu) version 1.01 or later, Teradata Generic Security Services (TeraGSS) version 6.01 or later, and the software on the following operating systems:
  • For Windows: Teradata client TTU 8.0 or later and the Teradata API library CLIv2 4.8.0 or later
  • For UNIX and Linux: Teradata Call-Level Interface Version 2 CLIv2 Release 4.8.0 or later
VSAM CICS® Transaction Server V3.1, V3.2, V4.1

Native VSAM access for the supported z/OS levels

Transactional VSAM access with DFSMS Transactional VSAM Services (DFSMStys) at the supported z/OS levels
Classic Federation Server for z/OS
Web Services7 WSDL 1.0, 1.1
SOAP 1.0, 1.1
None
XML7 XML1.0, XML1.1 None

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

2 IBM recommends connecting to Excel as an ODBC source. The requirements are then the same as shown for ODBC in this table.

3 IBM-branded DataDirect ODBC driver, which is included with the product, is recommended for connections on Linux/Unix. For Windows, IBM recommends using the ODBC driver manager and ODBC driver from Microsoft.

4 Required MQ software is included as a supporting program.

5 ODBC can be used to access RedBrick, InfoSphere Classic Federation, Netezza, and a wide variety of other data sources. An IBM-branded DataDirect driver manager and ODBC drivers are included with the product for connections on Linux/Unix. However, ODBC drivers provided by the vendors are needed for specific data sources, such as MySQL. For Windows, IBM recommends using the ODBC driver manager from Microsoft and the ODBC driver from data source vendors.

6 Supported by InfoSphere Federation Server V10.5 Fixpack 7 or later.

7 Supported by InfoSphere Federation Server V10.5 Fixpack 7 or earlier.

8 Supported by InfoSphere Federation Server V10.5 Fixpack 9 or later.

9 Supported by InfoSphere Federation Server V10.5 Fixpack 10.

10 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. Availability of wrappers on 32-bit and 64-bit operating systems.

This table shows whether or not a wrapper 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-32*
X86-32*

X86-64
X86-64
Power
Itanium®
Power
Sparc
zSeries®
Operating system
Linux
RHEL
SUSE
Windows
Linux
RHEL
SUSE
Windows
AIX®
HP-UX
Linux
RHEL
SUSE
Solaris
Linux
RHEL
SUSE
Data Source
BioRS
Y
Y
Y
Y
Y
Y
Y
Y
Y
DB2 for Linux, UNIX, and Windows
Y
Y
Y
Y
Y
Y
Y
Y
Y
DB2 for z/OS
Y
Y
Y
Y
Y
Y
Y
Y
Y
DB2 for iSeries
Y
Y
Y
Y
Y
Y
Y
Y
Y
DB2 Server for VSE and VM
Y
Y
Y
Y
Y
Y
Y
Y
Y
Informix
Y
Y
Y
Y
Y
Y
Y
Y
Y
JDBC
Y
Y
Y
Y
Y
Y
Y
Y
Y
Microsoft Excel
Y
Y
Microsoft SQL Server
Y
Y
Y
Y
Y
Y
Y
Y
MQ
Y
Y
Y
Y
Y
Y
Y
Y
Netezza
Y
Y
Y
Y
Y
Y
ODBC
Y
Y
Y
Y
Y
Y
Y
Y
OLE DB
Y
Y
Y
Y
Oracle
Y
Y
Y
Y
Y
Y
Y
Y
Y
Script
Y
Y
Y
Y
Y
Y
Y
Y
Y
Sybase
Y
Y
Y
Y
Y
Y
Y
Y
Teradata
Y
Y
Y
Y
Y
Y
Y
Y
Web Services
Y
Y
Y
Y
Y
Y
Y
Y
Y
XML
Y
Y
Y
Y
Y
Y
Y
Y
Y

* The data sources available on Linux X86-32 and Windows X86-32 apply to Database Enterprise Developer Edition (DEDE) only.

[{"Product":{"code":"SS2K5T","label":"InfoSphere Federation Server"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Not Applicable","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"10.5","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
30 May 2019

UID

swg27038537