 | Level: Introductory Michael Schenker (mschenk@us.ibm.com), Software Engineer, IBM
01 May 2008 Data Studio, the new unified tooling platform for IBM data servers,
provides a feature that allows easy exposure of database operations as Web services,
also known as IBM Data Web Services (DWS). This tutorial series will show how Web
services created with DWS can be deployed on IBM's WebSphere® Application Server
and how WebSphere Application Server enhanced features in terms of security,
transaction capabilities and more, can be leveraged to turn your Data Web Service application into a powerful, secure, and reliable enterprise Web service. Objectives - Create a basic Data Web Service using IBM Data Studio and deploy it on WebSphere
Application Server
- See how the service can be tested and WebSphere's tracing/logging feature can be used
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 "IBM Data Studio:
Get started with Data Web Services" (developerWorks, November 2007). Basic knowledge of WebSphere Application Server and
J2EE is recommended.
System requirements
To run the examples in this tutorial, you need an installation of IBM Data Studio
1.1 (fixpack 2) as well as
WebSphere Application Server version 6.0.2 (fixpack 9) or higher or version 6.1.x.
Furthermore, you need a DB2 version 8 or 9 installation with the sample database.
Formats html, pdf
Tutorial overview
The first product to provide tooling for Data Web Services is IBM Data Studio. With this solution, exposing a database statement as Web service operation
is as simple as dragging and dropping an SQL statement or stored procedure into a
Web service folder. A Data Web Service can contain one or more operations where each
is based on a single stored procedure call or SQL statement. After the Web
service has been assembled, runtime artifacts for different application servers can be generated by
a click on a button. Data Studio also comes with a testing environment (the Web Service Explorer), which allows you to instantly test the assembled data Web service. The tool
conveniently packages the Web service runtime artifacts into a deployable Web
Application Archive (war), which can directly be deployed onto an application server instance.
Since the Data Web Service runtime artifacts are based on the J2EE standard, it
is possible to leverage advanced features provided by the application server, like database connectivity,
security, transactions, tracing/logging/monitoring, and more.
| | | |
