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
BioRS V5.2 None
Y
Y
Blast V2.2.1, V2.2.3, v2.2.4, v2.2.9 Blast Demon (Supplied)
Y
Y
DB2 for Linux, UNIX, and Windows V8.1.x, V8.2.x, V9.1 None
Y
Y
DB2 for z/OS V7.x, V8.x, V9.1 DB2 Connect V9.1
Y
Y
DB2 for iSeries V5.2, V5.3, V5.4 DB2 Connect V9.1
Y
Y
DB2 Server for VSE and VM V7.2 , V7.4 DB2 Connect V9.1
Y
Y
Entrez None
Y
Y
Flat files None
Y
Y
HMMER v2.3, v2.3.2 HMMER daemon (supplied)
Y
Y
Informix Informix XPS v8.40, 8.50 and Informix IDS 7.31, IDS 9.40, IDS 10.0, IDS 11.10 Informix Client SDK Version 2.81.TC2 or later
Y
Y
KEGG Databases v3.0 None
Y
Y
MQ UDFs
Y
Y
Microsoft Excel 2000,2002,2003 Excel 2000,2002 or 2003
Y
Microsoft SQL Server Microsoft SQL Server 2000/SP3, 2005 For Windows, Microsoft SQL Server Client ODBC 3.0 (or later) driver.
For UNIX, DataDirect ODBC 5.0 & 5.1
Y
Y
ODBC 3.0 ODBC drivers that comply with ODBC 3.0 2
Y
Y
OLE DB 2.7, 2.8 OLE DB 2.0, or later
Y
Y
Oracle v8.1.7, v9.2, v10g, v10gR2 Oracle NET client v9.0 - 9.2.0.5 & v10.0 - 10.1.x or NET8 client v8.1.7.x
Y
Y
Sybase Sybase ASE 12.0, 12.5, 15.0 Sybase Open Client 12.0 - 15.0
Y
Y
Teradata v2.4, v2.5, v2.6 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:
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.6 PeopleSoft v8.x None
Y
Y
WebSphere Business Integration for SAP 2.6 SAP v3.x, v4.x None
Y
Y
WebSphere Business Integration for Siebel 2.6 Siebel v7, v7.5, 2000 None
Y
Y
Web Services WSDL 1.0, 1.1
SOAP 1.0, 1.1
None
Y
Y
XML XML1.0, XML1.1 None
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.

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

InfoSphere Federation Server

Software version:

9.1

Operating system(s):

AIX, HP-UX, Linux x86, Solaris, UNIX, Windows, z/OS

Reference #:

7008401

Modified date:

2009-03-24

Translate my page

Machine Translation

Content navigation