Access application data using WebSphere Federation Server and WebSphere DataStage
Discover an alternate methodology for accessing application data sources in IBMR WebSphereR Federation Server using the WebSphere DataStageR product as the connection vehicle to SAP. Application data sources can also be accessed by WebSphere Federation Server using the WebSphere Business Integrator adapters. The WebSphere Business Integrator method is not described in this tutorial but can be found in the product documentation, specifically the "WebSphere Federation Server Data Source Configuration Guide - Chapter 8: Configuring access to business application data sources." (The Resources section of the tutorial contains links to available online documentation.)
Objectives
Create and configure WebSphere DataStage jobs that uses the SAP PACK to access an SAP system. In this tutorial, you will be using the Customer business object with access to this object by the GetList and GetDetail2 BAPIs.
Configure RTI to allow the WebSphere DataStage jobs to be invoked as a Web service from any application and return the data back to the application.
Configure WebSphere Federation Server so that it can invoke the RTI Web service to retrieve the SAP data.
Test the access to the SAP data from WebSphere Federation Server by running sample queries.
Prerequisites
The tutorial is supplemental information to the product documentation. It is not intended to replace the product documentation, but rather consolidate the key information to show the steps needed to access the data sources with WebSphere Federation Server. Please make sure you have access to the appropriate product information (or expert) when using this document and setting up the systems.
In this tutorial scenario, it is assumed that you have access to an installed WebSphere Federation Server federated system, a WebSphere DataStage server, an RTI server, as well as access to an SAP R/3 system.
System requirements
WebSphere Federation Server V8.2, FixPack 10 with non-relational wrappers installed and running
WebSphere DataStage V7.5x2 with SAP PACK V5.2 installed and running
RTI V7.5.1.0 installed and running
access to an SAP R/3 system with the IDES sample database installed (for access to Customer business object)
If you are not able to comply with these requirements, you may need to make changes based upon your system configuration or data source you plan to access. For example, if you do not have the SAP IDES sample installed, you will need to choose other SAP objects to configure for WebSphere DataStage, WebSphere Federation Server access.
You must install and configure or have access to:
An SAP system with the appropriate client software
DB2 ESE V8.2 FP10 or later
WebSphere Federation Server V8.2 FP10 or later
WebSphere DataStage V7.5x2 or later
WebSphere DataStage SAP PACK V5.2 or later
RTI V7.5.1.0 or later
Formats
html, pdf
Tutorial overview
If you are interested in accessing your application data (SAP, for example), along with other relational and non-relational data source, you can use this tutorial to help you understand how to configure the infrastructure that is needed to bring diverse data together as if it were stored in local relational tables.
This tutorial shows an alternate methodology for accessing application data sources in WebSphere Federation Server using the WebSphere DataStage product as the connection vehicle to SAP.
source: http://www.ibm.com/developerworks/edu/dm-dw-dm-0610labrie-i.html
published: 2008-04-06 22:16:36
People reading this article also read
WebSphere DataStage
Access application data using WebSphere Federation Server and WebSphere DataStage
Job Details - Teradata Architect
Job Details: Applications Developer I
Job Details: Data Warehouse Architect
Job Details: Datastage TX Lead Developer
Job Details: EDI Analyst
Job Offer DataStage Developer
Datastage Developer Forum
WebSphere DataStage MVS Edition