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:
|
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.
Was this topic helpful?
Document Information
Modified date:
30 May 2019
UID
swg27038537