Before you start

About this tutorial

This tutorial gives you the basic steps of how to develop a Data Web Service with IBM Data Studio and shows you how to deploy it on an IBM WebSphere DataPower XI50 Integration Appliance.

Back to top

Motivation

IBM Data Studio Developer provides an easy way to expose database data as a service. While the service definition and artifact generation are important to understand, if you want to get serious about SOA, you must consider the problems of security, performance, governance and monitoring. Those issues can many times not be solved with the service definition, but they require additional infrastructure and configuration steps. Even though it's possible to create an "enterprise-ready" SOA environment with traditional J2EE application servers, it might not always be the best approach for exposing enterprise data as services.

IBM WebSphere DataPower provides a distinct and competitive hardware, software, and infrastructure stack which allows you to address many of the SOA challenges mentioned earlier. Now, this infrastructure can be leveraged for Data Web Services with IBM Data Studio Developer 1.2 (or later) supporting WebSphere DataPower XI50 Integration Appliance as runtime environment and the DataPower enhancements for database access in the 3.7.1 firmware release.

Using WebSphere DataPower XI50 Integration Appliance as the hosting environment for Data Web Services allows you to leverage the superior support of network protocols. This gives a wide variety of clients the ability to talk to DB2 — without even being database-aware. Furthermore, all the other DataPower advantages like security, XML hardware acceleration for parsing, schema validation and XSLT processing can be used.

Back to top

Objectives

In this tutorial, you learn what steps are necessary to create Data Web Service runtime artifacts for the WebSphere DataPower XI50 Integration Appliance with IBM Data Studio Developer 2.1. Furthermore, see how to create a DB2 data source on DataPower, how to transfer the service artifacts from Data Studio to DataPower, how to create an HTTP-based binding configuration using the XSL Accelerator, and how to create the WSDL/SOAP-based service binding using the Web Service Proxy.

Back to top

Prerequisites

This tutorial is written for users who have basic knowledge of Web Services, databases, IBM Data Studio and IBM WebSphere DataPower Appliances.

Back to top

System requirements

To run the examples in this tutorial, you need IBM Data Studio Developer 1.2 or 2.1 as well as DB2 version 8 or higher with the sample database. For service deployment, you need an IBM WebSphere DataPower Integration Appliance XI50 with firmware level 3.7.1 and the ODBC package.

Back to top

Overview

In the tutorial you will:

1. Create a Data Web service and DataPower runtime artifacts with IBM Data Studio Developer
2. Create a DB2 data source on DataPower
3. Upload the generated service artifacts to DataPower
4. Configure an XSL Accelerator for HTTP POST XML binding
5. Configure an XSL Accelerator for HTTP GET binding
6. Configure a WS-Proxy for SOAP over HTTP binding

1 of 11 | Next

Comments

Back to top

Table of contents

• Before you start
• How it works
• Create a simple Web service and generate DataPower artifacts
• Set up a DB2 data source on DataPower
• Copy artifacts to DataPower
• Configure and Test an XSL accelerator for HTTP POST XML binding
• Configure and test an XSL Accelerator for HTTP POST/GET binding (URL-encoded parameter)
• Configuring and Testing a Web Service Proxy for SOAP over HTTP binding
• Conclusion
• Resources
• About the author

---

1 of 11 | Next

Next steps from IBM

• Try: Data Studio
• Demo: Use Ajax with DB2
• Briefing: Virtual tech briefings on integrated data management
• Community: DB2
• Buy: Data Studio

Dig deeper into Information Management on developerWorks

Try IBM PureSystems. No charge.

Experience today!

---

Get started with the cloud-based trial and pattern development kit.