There are many data sources that you can access using a federated system.
IBM® InfoSphere® Federation Server supports the data sources shown in the following table.
For the most up-to-date information about supported data sources, see the Data source requirements page on the Web.
Data source | Supported versions |
---|---|
BioRS | 5.2, 5.3 |
CA-Datacom | 10, 11 |
CA-IDMS | 16, 17 |
DB2® for Linux, UNIX, and Windows | 9.7, 9.8, 10.1, 10.5 |
DB2 for z/OS® | 7.x, 8.x, 9.x, 10.x |
DB2 for System i® | 5.2, 5.3, 5.4, 6.1, 7.1 |
DB2 Server for VSE and VM | 7.4, 7.5 |
IMS™ | 10.1, 11.1 |
Informix® | 11.1, 11.5, 11.7, 12.10 |
JDBC | 3.0 or later |
Microsoft Excel | 2003, 2007, 2010 |
Microsoft SQL Server | 2005, 2008, 2008R2, 2012 |
MQ | MQ7, MQ7.01 |
Netezza | 4.6, 5.0, 6.0 |
ODBC* | 3.0 |
Oracle | 11g, 11gR1, 11gR2 |
Software AG Adabas | 8.1.3, 8.1.4, 8.2.2 |
Sybase | Sybase ASE 15.0, 15.5, 15.7 |
Teradata | 12, 13, 14 |
VSAM |
|
Web Services | WSDL 1.0, 1.1 SOAP 1.0, 1.1 |
XML | XML1.0, XML1.1 |
* ODBC can be used to access RedBrick 6.20.UC5 and 6.3, InfoSphere Classic Federation Server for z/OS V8.2 and above, and Netezza among other data sources. |