 | Level: Intermediate Walt Geddes (geddes@us.ibm.com), Senior Software Engineer, IBM
Lai-Fong Leung (lfleung@us.ibm.com), Senior Software Engineer, IBM
07 Feb 2008 Learn how to create and deploy information services to access
legacy databases without writing any code.
The generated web services are created using the IBM® Information
Server components including WebSphere® DataStage, WebSphere
Federation Server, WebSphere Information Services Director,
and WebSphere Transformation Extender for DataStage.
In this example, the information services are delivered using a
standard government XML model (GJXML).
Objectives - Import legacy database schemas into IBM Information Server (IIS)
- Create a federated view
- Import GJXML schema
- Map the federated view to GJXML schema
- Create a DataStage job to access the data
- Publish and deploy DataStage job as a Web service
Prerequisites
To implement the IncidentReport Web service as described in this
tutorial, you will need:
- An IBM Information Server V8.1.0.1,
that consists of at least the following components:
- IBM Information Server Console. This is the
Client for the WebSphere Information Services
Director (WISD).
- WebSphere DataStage Server
- WebSphere DataStage and QualityStage Designer
- WebSphere DataStage and QualityStage Director
- WebSphere DataStage and QualityStage Administrator
- WebSphere Federation Server
- WebSphere Transformation Extender for DataStage
Version 8.1.0.1.
- If the latest WebSphere Transformation Extender
for DataStage is V8.1.0.1, you will also need
WebSphere Transformation Extender Designer Studio V 8.1.0.2
- A repository that stores the legacy data.
- A Web service testing tool to test the IncidentReport Web service created by
WISD. You can test using the WebExplorer in one of
the following IBM development tools:
- Rational® Data Architect V7.0
- Rational Application Developer for WebSphere Software V7.0
Trial versions of some of the products mentioned above
are available.
Refer to the Resources section
for the link to Download IBM product evaluation versions.
System requirements
Please refer to the
IBM Information Server Information Center for the complete
system requirements and installation instructions on the IBM Information Server.
In our development environment, the IIS server was actually
installed on a VMWare Image running Windows XP. The VMWare memory
was set to 2184 MB, and the virtual disk was set to 40 GB.
The IIS VMWare image was hosted by a Lenovo T60p Thinkpad with
3GB of RAM.
Formats html, pdf
| | | |
