DataStage Version 8 on Information Server

Enterprise PACKs

SAP BW Pack o BAPI: (Staging Business API) loads from any source to BW. o OpenHub: extract data from BW.

SAP R/3 Pack o ABAP: (Advanced Business Application Processing) auto generate ABAP, Extraction Object Builder, SQL Builder, Load and execute ABAP from DataStage, CPI-C Data Transfer, FTP Data Transfer, ABAP syntax check, background execution of ABAP. o IDoc: create source system, IDoc listener for extract, receive IDocs, send IDocs. o BAPI: BAPI explorer, import export Tables Parameters Activation, call and commit BAPI.

Siebel Pack o EIM: (data integration manager) interface tables o Business Component: access business views via Siebel Java Data Bean o Direct Access: use a metadata browser to select data to extract o Hierarchy: for extracts from Siebel to SAP BW.

Oracle Applications Pack o Oracle flex fields: extract using enhanced processing techniques. o Oracle reference data structures: simplified access using the Hierarchy Access component. o Metadata browser and importer

DataStage Pack for PeopleSoft Enterprise o Import business metadata via a metadata browser. o Extract data from PeopleSoft tables and trees.

JD Edwards Pack o Standard ODBC calls o Pre-joined database tables via business views Database Connectivity The common connection objects functionality means the very wide range of DataStage database connections are now available across Information Server products. Latest supported databases for version 8:

DB2 8.1, 8.2 and 9.1

Oracle 9i, 10i, 10gR2 not Oracle 8

SQL Server 2005 plus stored procedures.

Teradata v2r5.1, v2r6.0, v2r6.1 (DB server) / 8.1 (TTU) plus Teradata Parallel Transport (TPT) and stored procedures and macro support, reject links for bulk loads, restart capability for parallel bulk loads.

Sybase ASE 15, Sybase IQ 11.5, 12.5, 12.7

Informix 10 (IDS)

SAS 612, 8.1, 9.1 and 9.1.3

IBM WS MQ 6.1, WS MB 5.1

Netezza v3.1

ODBC 3.5 standard and level 3 compliant

UniData 6 and UniVerse ?

Red Brick Source