IBM Support

InfoSphere Federation Server Version 10.1 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
BioRS5.2, 5.3None
CA-Datacom10, 11Classic Federation Server for z/OS
CA-IDMS16, 17Classic Federation Server for z/OS
DB2 for Linux®, UNIX®, and Windows®8.1.x, 8.2.x, 9.1, 9.5, 9.7, 9.8, 10.1None
DB2 for z/OS®7.x, 8.x, 9.x, 10.xNone1
DB2 for System i®5.2, 5.3, 5.4, 6.1, 7.1None1
DB2 Server for VSE and VM7.2, 7.4None1
Flat filesN/ANone
IMS10.1, 11.1Classic Federation Server for z/OS
Informix®Informix 11.1, 11.5, 11.7, 12.10Informix Client SDK version 3.0 or higher
JDBC3.0 or laterJDBC drivers and manager comply with JDBC 3.0 or later
Microsoft® Excel2000, 2002, 2003, 2007None2
Microsoft SQL ServerMicrosoft SQL Server 2000 SP4, 2005, 2008, 2008R2None3
MQMQ7None4
Netezza4.6, 5.0, 6.0Netezza ODBC driver
ODBC3.0 or laterODBC driver5
OLE DB2.7, 2.8None
Oracle10g, 10gR2, 11g, 11gR1, 11gR2Oracle NET client 10.0 - 10.1, 10.2.0.1 with patch 3807408, 10.1.0.3 with patch 3807408, 11.1.0.6.0
SybaseSybase ASE 12.5, 15.0, 15.5Sybase Open Client 12.5 - 15.5
Teradata2.5, 2.6, 12, 13Shared 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
VSAMCICS® 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 ServicesWSDL 1.0, 1.1
SOAP 1.0, 1.1
None
XMLXML1.0, XML1.1None
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

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
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
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 apply to DB2 Developer Edition only.

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

Document Information

Modified date:
17 June 2018

UID

swg27024461