IBM Data Studio Data Web Services, Part 1: IBM Data Studio: Get started with Data Web Services

Level: Introductory

Michael L. Pauser (pauser@us.ibm.com), Developer, IBM

08 Nov 2007
Updated Dec 2008

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

The IBM® Data Studio solution includes many new features, among these is the Data Web Services support. Data Web Services is the next generation Web service provider for IBM database servers. Data Web Services provides a full Web service interface, that supports both REST-style (HTTP GET/POST binding) as well as SOAP over HTTP, SOAP over JMS and automatic WSDL generation. Data Web Services supports the IBM DB2® family of databases, IBM Informix® Dynamic Server (IDS), and many popular Web servers, such as Apache Tomcat v6, and IBM WebSphere® Application Server V7 and Community Edition V2.1 as well as DataPower SOA appliances. Create your first Data Web Service using IBM Data Studio. No programming is required. Build Web services using drag-and-drop, and deploy with a few clicks of the mouse.

Objectives

• Create a database connection
  
  
• Create a Data development project
  
  
• Create an SQL script
  
  
• Create a Web service
  
  
• Add SQL scripts
  
  
• Add stored procedures to the Web service
  
  
• Add a Web server
  
  
• Deploy a Web service
  
  
• Test the Web service
  

Prerequisites

No programming knowledge is required. You simply drag-and-drop and deploy with a few clicks of the mouse.

System requirements

• IBM DB2 9.5 for Linux, Unix, and Windows. 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 the SAMPLE database installed, refer to your DB2 Information Center for instructions on installation.
• 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, 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, refer to the WebSphere Application Server Community Edition Web page for additional information or to download the WebSphere Application Server Community Edition installation image.

Duration

Less than two hours

Formats

Tutorial overview

This tutorial provides a step-by-step guide to creating your first Data Web Service using IBM Data Studio.

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

Back to top