Skip to main content

Software  >  Information Management  >  Information Integration  >  

WebSphere Information Integration Version 8.2 data source requirements
 Product documentation
 
Abstract
WebSphere Information Integration products support the data source versions shown in the following tables.
 
 
Content
WebSphere® Information Integration Version 8.2 products support the data source versions shown in the following tables.
  • Federated access supports all the data sources shown in the table below.
  • SQL-based replication supports DB2®, Informix® Dynamic Server, Microsoft® SQL Server, Oracle, Sybase SQL Server, and Sybase Adaptive Server Enterprises as sources and targets. Informix Extended Parallel Server and Teradata are supported as SQL replication targets. Support for DB2 Universal Database™ for z/OS® requires WebSphere Replication Server for z/OS® or DB2 DataPropagator™ for z/OS.
  • Queue-based replication supports DB2 for Linux®, UNIX®, and Windows® and DB2 Universal Database for z/OS. Support for DB2 Universal Database for z/OS requires WebSphere Replication Server for z/OS.
  • Data event publishing supports DB2 for Linux, UNIX, and Windows and DB2 Universal Database for z/OS. Support for DB2 Universal Database for z/OS and OS/390® requires WebSphere Event Publisher for z/OS.

Support on 32-bit platforms:
Data Sources
Supported Versions
Client Software Required
AIX® (4.3.32, 5.1, 5.2)
Windows (NT42, 2000, 2003, XP1, XP SP12)
Sun™ Solaris™ (2.72, 2.8, 2.9)
HP-UX PA-RISC (11i)
Linux x86 (Red Hat Linux V7.22, Red Hat Enterprise Linux AS V2.1, Red Hat Enterprise Linux AS V3.0, SuSE Linux Enterprise Server V8)
BioRS
V5.0.14, V5.2
None
Y
Y
Y
Y
Blast
V2.2.3, V2.2.4, V2.2.5, V2.2.6
BLAST daemon (supplied)
Y
Y
Y
Y
DB2 for Linux, UNIX, and Windows
V7.2, V8.1, V8.2
None
Y
Y
Y
Y
Y
DB2 Universal Database for z/OS and OS/390
V6.x, V7.x, V8.x
None
Y
Y
Y
Y
Y
DB2 Universal Database for iSeries™
V5.1, V5.2, V5.3, V5.4
None
Y
Y
Y
Y
Y
DB2 Server for VM and VSE
V7.1
None
Y
Y
Y
Y
Y
Documentum
V4.x
Documentum Client APL/Library 3.1.7a, or later
Y
Y
Y
Y
Entrez
None
Y
Y
Y
Y
Flat files
None
Y
Y
Y
Y
Y
HMMER
V2.2g, V2.3
HMMER daemon (supplied)
Y
Y
Y
Y
KEGG Databases (Pathway and SSDB)
V2.3 API
KEGG API V2.3
Y
Y
Y
Y
Y
IBM Lotus® Extended Search
V4.0 with latest available fix pack
Extended Search Client Library (supplied)
Y
Y
Y
Y
Informix
V7.31, V8.32, V8.4, V9.3, V9.4, V10.0
Informix Client SDK 2.7, 2.8, 2.9
Y
Y
Y
Y
Y
Microsoft Excel
97, 2000, 2002, 2003
Excel 97, 2000, or 2002 installed on the same machine as the federated server
Y
Microsoft SQL Server
7.0 and 2000 SP3 and further service packs on that release
On Windows, the Microsoft SQL Server Client ODBC 3.0 (or later) driver
On UNIX, the DataDirect Technologies Connect ODBC 3.7 (or later) driver
Y
Y
Y
Y
Y
ODBC
V3.x
ODBC driver for the data source
Y
Y
Y
Y
Y
OLE DB
V2.7, V2.8
OLE DB 2.0, or later
Y
Y
Oracle
V8.0.6, V8.1.6, V8.1.7, V9.0, V9.1, V9.2, V9i, V10g
Net8 or Oracle Net client software. Oracle clients 9.2.0.5, 9.2.0.6, 9.2.0.7, 10.1.0.3 and later, and 10.2.0.1 and 10.2.0.1 require Oracle patch 3807408.
Y
Y
Y
Y
Y
PeopleSoft (WBI Adapter for PeopleSoft V2.3.1, 2.4)
V8.x
None
Y
Y
SAP (WBI Adapter for or mySAP.com V2.3.1, 2.4 )
V3.x, V4.x
None
Y
Y
Siebel (WBI Adapter for Siebel eBusiness Applications V2.3.1, 2.4)
V7, V7.5, 2000
None
Y
Y
Sybase
V11.9.2, V12.0, V12.5
Sybase Open Client 11.9.2, 12.0, 12.5 (ctlib interface)
Y
Y
Y
Y
Y
Teradata
V2.3, V2.4, V2.5
Teradata Call-Level Interface Version 2 CLIv2 Release 04.06, 04.07
Y
Y
Y
Y
Web Services
WSDL 1.0, 1.1

SOAP 1.0, 1.1

None
Y
Y
Y
XML
XML 1.0
None
Y
Y
Y
Y
Y

In addition, WebSphere Information Integrator supports Wise2 package version 2.1.20c for the LSGeneWise UDF (required for access to certain Health Care and Life sciences data) on all supported platforms.

Support on 64-bit platforms:

Data Sources
Supported Versions
Client Software Required
AIX (5.1,5.2)
Windows (2003, XP1)
Solaris (2.72, 2.8, 2.9)
HP-UX PA-RISC (11.1i)
HP-UX IPF
Linux x86 (RHEL 3.0, 4.0, SLES 8, 9)
DB2 for Linux, UNIX, and Windows
V7.2, V8.1, V8.2, V9.1
None
Y
Y
Y
Y
Y
Y
DB2 Universal Database for z/OS and OS/390
V6.x, V7.x, V8.x,
None
Y
Y
Y
Y
Y
Y
DB2 Universal Database for iSeries
V5.1, V5.2, V5.3, V5.4
None
Y
Y
Y
Y
Y
Y
DB2 Server for VM and VSE
V7.1
None
Y
Y
Y
Y
Y
Y
Flat files
None
Y
Y
Y
Informix
V7.31, V8.32, V8.4, V9.3, V9.4
Informix Client SDK 2.7, 2.8
Y
Y
Y
Y
Y
OLE DB
V2.7, V2.8
OLE DB 2.0, or later
Y
Oracle
V8.0.6, V8.1.6, V8.1.7, V9.0, V9.1, V9.2, V9i, V10g
Net8 or Oracle Net client software. Oracle clients 9.2.0.5, 9.2.0.6, 9.2.0.7, 10.1.0.3 and later, and 10.2.0.1 and 10.2.0.1 require Oracle patch 3807408.
Y
Y
Y
Sybase
V11.9.2, V12.0, V12.5
Sybase Open Client 11.9.2, 12.0, 12.5 (ctlib interface)
Y
Y
Y
1 Windows XP support is limited to development and testing purposes.

2 Indicates out-of-service version of the operating system. Customers are encouraged to move to a later version of the operating system to ensure continued support for the product.

 
 
 

Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.
Rate this page
Please take a moment to complete this form to help us better serve you.
This material provides me with the information I need.




This material is clear and easy to understand.




Did the information help you to achieve your goal?
What updates, improvements, or related information would you like to see in this document?
Your response will be used to improve our document content. Requests for assistance, if applicable, should be submitted through your normal support channel as we cannot respond from this site.
Input the verification number to submit feedback:
Document information
 Product categories:
 Software
 Information Integration and Master Data Management
 Information Integration Platform
 InfoSphere Federation Server
 8.2 Temporary
 Operating system(s):
  AIX, HP-UX, Linux x86, Solaris, Windows 2000, Windows NT, Windows XP
 Software version:
  8.2
 Software edition:
  Advanced, Standard
 Reference #:
  7005464
 IBM Group:
 Software Group
 Modified date:
 2007-05-18

Translate My Page
 
 

Rate this page

Help us improve this page. Your response will be used to improve our document content. Requests for assistance, if applicable, should be submitted through your normal support channel as we cannot respond from this site.