Invoking Web services from SQL: Integrating relational data with Web services using DB2 UDB 8.1

Level: Intermediate

Tim Brown , DB2 Universal Database Solutions Expert, IBM
James Magowan , Web Services and Data Grids, IBM

11 Mar 2004

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

Developing applications that access both Web services and database management systems can be an overwhelming task. It doesn't need to be. This tutorial demonstrates how to generate DB2 user-defined functions (UDFs) that provide access to Web services. The generated UDFs can be used in SQL statements to combine relational data with dynamic data retrieved from a Web service. Several different examples are provided.

Prerequisites

This tutorial assumes a basic knowledge of Web services, DB2 SQL, and WebSphere Studio Application Developer.

System requirements

To complete the steps in this tutorial, you need the following software installed and running: DB2 Universal Database V8.1 FixPack 4 and WebSphere Studio Application Developer V5.1.1 (optional - you could skip this and use the DB2 command line, but Application Developer makes it much easier.)

The tutorial includes links to a free trial download of DB2 Universal Database.

Duration

Under two hours

Formats

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

Back to top