 | Level: Advanced Jacques Labrie (jlabrie@us.ibm.com), Senior Software Engineer, IBM
05 Oct 2006 Discover an alternate methodology for accessing
application data sources in IBM® WebSphere® Federation Server using the
WebSphere DataStage® 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.
| | | |
