IBM Data Studio Data Web Services, Part 2: Deploy Data Web Services to a WebSphere Application Server Community Edition Web server

Level: Intermediate

Michael L. Pauser (pauser@us.ibm.com), Developer, IBM
Patsy Yu (patsyyu@us.ibm.com), Software Engineer, IBM

06 Mar 2008
Updated Jan 2009

	Register now or sign in using your IBM ID and password.

IBM® Data Studio V2.1 contains many features, one of which is Data Web Services. Data Web Services allows you to quickly and easily expose database operations (SQL SELECT, INSERT, UPDATE, and DELETE) and stored procedures CALLs as a Web service operation to client applications. Data Web Services requires no programming knowledge or past Web service experience. This tutorial takes you through the steps to deploy a Data Web service created by IBM Data Studio's Data Web Services to a WebSphere® Application Server Community Edition Web server.

Objectives

• Add a WebSphere Application Server Community Edition Web server instance.
  
  
• Deploy a Data Web Services Web service to a local WebSphere Application Server Community Edition Web server.
  
  
• Deploy a Data Web Services Web service to a remote WebSphere Application Server Community Edition Web server.
  
  
• Deploy a Data Web Services Web service to a WebSphere Application Server Community Edition Web server from a .WAR file.
  

Prerequisites

This tutorial is written for database programmers who are familiar with IBM Data Studio and know how to create a database connection, data development project, SQL scripts, or stored procedures, and have completed Part 1 of this series.

System requirements

This tutorial assumes that you have the following products installed:

• IBM DB2® for Linux®, UNIX®, Windows® V9.5. However, you can use any supported Data Web Service DB2 database. In addition, you must have the DB2 SAMPLE database installed. If you do not have this SAMPLE database installed, refer to your DB2 Information Center for instructions on the installation of the SAMPLE database.
• IBM Data Studio V2.1. During installation, ensure that the Data Web Services Development component is selected.
• IBM WebSphere Application Server Community Edition V2.1.0.1, a free Web server from IBM. A WebSphere Application Server Community Edition installation image may be bundled with your IBM Data Studio installation. If not, visit the WebSphere Application Server Community Edition download page and follow the link for previous version(s) for additional information, or to download the WebSphere Application Server Community Edition V2.1.0.1 installation image.
• A Data Development Project with a Data Web Service. This tutorial uses the data development project from Part 1 of this series.

Duration

Formats

Tutorial overview

As discussed in Part 1 of this series, exposing your SQL scripts and stored procedures as a Web service is an easy task to perform. As Data Web Service supports multiple Web servers, each Web server has its own nuances. This tutorial focuses on using WebSphere Application Server Community Edition.

Share this.... Digg this story del.icio.us Slashdot it!

Back to top