The first time you sign into developerWorks, a profile is created for you. Select information in your profile (name, country/region, and company) is displayed to the public and will accompany any content you post. You may update your IBM account at any time.

All information submitted is secure.

The first time you sign in to developerWorks, a profile is created for you, so you need to choose a display name. Your display name accompanies the content you post on developerworks.

Please choose a display name between 3-31 characters. Your display name must be unique in the developerWorks community and should not be your email address for privacy reasons.

All information submitted is secure.

My developerWorks:

My notifications:

Sign out

Select a language:

Use IBM InfoSphere Information Server to transform legacy data into information services

An SOA approach to information sharing using GJXDM schema

Lai-Fong Leung (lfleung@us.ibm.com), Senior Software Engineer, IBM

Lai-Fong Leung is a Senior Software Engineer with the Software Group Federal Innovation Solution Center at Bethesda, MD. In this role, she is responsible for building Content Management Services and Information Integration Services demo. Her areas of expertise include e-business technologies such as Enterprise Content Management Solution, WebSphere and Java. She has over twenty years of experience in application development. She holds a masters degree in Computer Science from the University of George Washington.

Walt Geddes (geddes@us.ibm.com), Senior Software Engineer, IBM

Walt Geddes is a senior software engineer with the IBM Software Group, Strategy team in IBM. In his 37 years with IBM Mr. Geddes was the software architect and team lead on a number of IBM products and customer projects. He is currently working in the IBM Federal Innovation Solution Center, focused on creating customer demonstrations and proof of concepts.

Summary: 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 InfoSphere DataStage, InfoSphere Federation Server, InfoSphere Information Services Director, and WebSphere Transformation Extender for DataStage. In this example, the information services are delivered using a standard government XML model (GJXML).

This scenario was implemented by the Federal Innovation Solution Center (FISC) as part of an information-sharing demonstration. Note: Although this tutorial was written for InfoSphere Information Server V8.1, it also applies to later versions of the product.

Date: 12 Nov 2012 (Published 07 Feb 2008)
Level: Intermediate
PDF: A4 and Letter (3468 KB | 55 pages)Get Adobe® Reader®

Activity: 23973 views
Comments:

Before you start

Government agencies often need to share important information with one another. Unfortunately, the data for these agencies is often kept in many different repositories, and reflects many different data models. One way to meet this need is to map each of the local models to a common, shared model. The mapped data can then be exposed to the sharing organizations as information services.

Wouldn’t it be great if you could create all of these information services without writing code? Well, such tools do exist as components of the IBM Information Server (IIS).

About this tutorial

In this tutorial, learn how to create and deploy information services that can access legacy databases and return the information in a standard government XML model (GJXML). The techniques described in the tutorial can be used with any XML model chosen.

Objectives

Import legacy database schemas into IBM Information Server (IIS)
Create a federated view (optional)
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 InfoSphere Information Services Director (IISD).
- InfoSphere DataStage Server
- InfoSphere DataStage and QualityStage Designer
- InfoSphere DataStage and QualityStage Director
- InfoSphere DataStage and QualityStage Administrator
- InfoSphere 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 IISD. You can test using the WebExplorer in one of the following IBM development tools:
- InfoSphere 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.

Figure 1 shows the development environment that we used to develop the IncidentReport Web service. It consists of an IBM Information Server (IIS), an IBM DB2 Server and a client workstation.

Figure 1. IncidentReport development environment

IBM Information Server

We installed all the IBM Information Server components onto one server. The operating system was Windows XP. The IIS server contained both the server and client for developing the DataStage job.

IBM DB2 Server

We setup an IBM DB2 V9.0 server to simulate where legacy data is stored. You can use any repository that IIS supports.

Client Workstation

We setup a Client workstation on an IBM T40 Thinkpad with 2GB of RAM. We installed the IBM Rational Application Developer (RAD) V7.0, so we could test the IncidentReport Web service using the WebExplorer in the RAD. We also installed the WebSphere Transformation Extender Designer Studio V 8.1.0.2 on the Client workstation and used that to develop the IncidentReport transformation map.

System requirements for IIS

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.

Comments

static.content.url=http://www.ibm.com/developerworks/js/artrating/

SITE_ID=1

Zone=Information Management, WebSphere

ArticleID=845416

TutorialTitle=Use IBM InfoSphere Information Server to transform legacy data into information services

publish-date=11122012

author1-email=lfleung@us.ibm.com

author1-email-cc=

author2-email=geddes@us.ibm.com

author2-email-cc=

Next steps from IBM

Rational Tester for SOA Quality is an automated web services testing and SOA testing tool that supports Web services SOAP, HTTP(S), JMS, WS-Security, UDDI, and RESTful standards.