Skip to main content

Software  >  Information Management  >  Information Integration  >  

WebSphere Information Integration Version 9.1 data source requirements
 Product documentation
 
Abstract
WebSphere Information Integration products support the data source versions shown in the following tables.
 
 
Content
WebSphere® Federation Server, WebSphere Replication Server, and WebSphere Data Event Publisher support data sources shown in the following list:
  • Federated access supports all the data sources shown in the table.
  • SQL-based replication supports:
    • DB2®, Informix® Dynamic Server, Microsoft® SQL Server, Oracle, and Sybase Adaptive Server Enterprise as sources and targets.
    • Informix Extended Parallel Server and Teradata 1 as targets.
    • DB2 for z/OS® support requires WebSphere Replication Server for z/OS.
    • DB2 for iSeries™ support requires IBM® DB2 DataPropagator™ for iSeries.
  • Queue-based replication supports:
    • DB2 for Linux®, UNIX®, and Windows® and DB2 for z/OS and OS/390® as sources and targets.
    • Informix Dynamic Server, Microsoft SQL Server, Oracle, and Sybase Adaptive Server Enterprise as targets.
    • DB2 for z/OS support requires WebSphere Replication Server for z/OS.
  • Data event publishing supports:
    • DB2 for Linux, UNIX, and Windows and DB2 for z/OS and OS/390.
    • DB2 for z/OS support requires WebSphere Data Event Publisher for z/OS.
Data client software requirements depend on the data sources that are accessed and are shown in the first table. The client software must be acquired separately unless specified otherwise. The client software must be installed on the same system as the WebSphere Federation or Replication Server.

1 Teradata is not supported on Itanium HP-UX.

Table 1. Supported data sources, client software requirements, and support from 32-bit platforms.

32-bit Hardware Architecture
and
Operating System
X86-32
X86-32
Data Source
Supported Versions
Client Software
Linux,
RedHat Enterprise Linux (RHEL),
SUSE
Windows
BioRSV5.2None
Y
Y
BlastV2.2.1, V2.2.3, v2.2.4, v2.2.9Blast Demon (Supplied)
Y
Y
DB2 for Linux, UNIX, and WindowsV8.1.x, V8.2.x, V9.1None
Y
Y
DB2 for z/OSV7.x, V8.x, V9.1DB2 Connect V9.1
Y
Y
DB2 for iSeriesV5.2, V5.3, V5.4DB2 Connect V9.1
Y
Y
DB2 Server for VSE and VMV7.2 , V7.4DB2 Connect V9.1
Y
Y
EntrezNone
Y
Y
Flat filesNone
Y
Y
HMMERv2.3, v2.3.2HMMER daemon (supplied)
Y
Y
InformixInformix XPS v8.40, 8.50 and Informix IDS 7.31, IDS 9.40, IDS 10.0, IDS 11.10Informix Client SDK Version 2.81.TC2 or later
Y
Y
KEGG Databasesv3.0None
Y
Y
MQ UDFs
Y
Y
Microsoft Excel2000,2002,2003Excel 2000,2002 or 2003
Y
Microsoft SQL ServerMicrosoft SQL Server 2000/SP3, 2005For Windows, Microsoft SQL Server Client ODBC 3.0 (or later) driver.
For UNIX, DataDirect ODBC 5.0 & 5.1
Y
Y
ODBC3.0ODBC drivers that comply with ODBC 3.0 2
Y
Y
OLE DB2.7, 2.8OLE DB 2.0, or later
Y
Y
Oraclev8.1.7, v9.2, v10g, v10gR2Oracle NET client v9.0 - 9.2.0.5 & v10.0 - 10.1.x or NET8 client v8.1.7.x
Y
Y
SybaseSybase ASE 12.0, 12.5, 15.0Sybase Open Client 12.0 - 15.0
Y
Y
Teradatav2.4, v2.5, v2.6Shared 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 7.0 or later and the Teradata API library CLIv2 4.7.0 or later. For UNIX Teradata Call-Level Interface Version 2 CLIv2 Release 04.06, 04.07
Y
WebSphere Business Integration for PeopleSoft 2.6PeopleSoft v8.xNone
Y
Y
WebSphere Business Integration for SAP 2.6SAP v3.x, v4.xNone
Y
Y
WebSphere Business Integration for Siebel 2.6Siebel v7, v7.5, 2000None
Y
Y
Web ServicesWSDL 1.0, 1.1
SOAP 1.0, 1.1		None
Y
Y
XMLXML1.0, XML1.1None
Y
Y
2 ODBC can be used to access RedBrick 6.20cu5 and WebSphere Information Integration Classic Federation V8.2.x , among other data sources.

Table 2. Support from 64-bit Platforms

64-bit Hardware Architecture
X86-64
X86-64
Power
Itanium
Power
Sparc
zSeries
Operating System
Linux
RHEL
SUSE
Windows
AIX
HP-UX
Linux
RHEL
SUSE
Solaris
Linux
RHEL
SUSE
Data Source
BioRS
Y
Y
Y
Y 3
Y
Y
Y
Blast
Y
Y
Y
Y 3
Y
Y
Y
DB2 for Linux, UNIX, and Windows
Y
Y
Y
Y
Y
Y
Y
DB2 for z/OS
Y
Y
Y
Y
Y
Y
Y
DB2 for iSeries
Y
Y
Y
Y
Y
Y
Y
DB2 Server for VSE and VM
Y
Y
Y
Y
Y
Y
Y
Entrez
Y
Y
Y
Y
Y
Y
Flat files
Y
Y
Y
Y
Y
Y
Y
HMMER
Y
Y
Y
Y
Y
Y
Y
Informix
Y
Y
Y
Y
Y
Y
KEGG Databases
Y
Y
Y
Y
Y
Y
Microsoft Excel
Microsoft SQL Server
Y
Y
Y
Y
Y
ODBC
Y
Y
Y 4
Y
Y 4
OLE DB
Y
Y
Oracle
Y
Y
Y
Y
Y
Y
Y
Script
Y
Y
Y
Y
Y
Y
Y
Sybase
Y
Y
Y
Y
Y
Teradata
Y 5
Y 5
WebSphere Business Integration for PeopleSoft 2.6
Y
Y
Y
Y
Y
Y
Y
WebSphere Business Integration for SAP 2.6
Y
Y
Y
Y
Y
Y
Y
WebSphere Business Integration for Seibel 2.6
Y
Y
Y
Y
Y
Y
Y
Web Services
Y
Y
Y
Y 3
Y
Y
Y
XML
Y
Y
Y
Y
Y
Y
Y

3 Support for BioRS, BLAST, and Web Services on HP-UX for Itanium is available in a Version 9 Fix Pack 1 on the support page.
4 ODBC can be used to access RedBrick 6.20cu5 and WebSphere Information Integrator Classic Federation V8.2.x using 32-bit clients.
5 Teradata can be accessed using a 32-bit Teradata client.
 
 
 

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
 Operating system(s):
  AIX, HP-UX, Linux x86, Solaris, UNIX, Windows, z/OS
 Software version:
  9.1
 Reference #:
  7008401
 IBM Group:
 Software Group
 Modified date:
 2009-03-24

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.