OpenLink Server 4.5 User Manual

Virtuoso Universal Server 4.5

Application Integration

(Web Service Composition)

Reviewer's Guide

OpenLink Software Published: March 9, 2006

OpenLink, UDA, Virtuoso registered trademarks or trademarks of OpenLink Software in the United States and/or other countries.

The names of actual companies and products mentioned herein may be the trademarks of their respective owners.

Table of Contents

1 Preface .................................................................................................. 3

1.1 Objective ........................................................................................... 3

1.2 System Requirements ....................................................................... 3

1.3 Installation ........................................................................................ 4

2 Virtuoso Universal Server ...................................................................... 5

2.1 Introduction ...................................................................................... 5

3 Web Services Platform .......................................................................... 7

3.1 What Is This? ....................................................................................7

3.2 The Value Proposition ....................................................................... 7

3.3 Exploiting Value Proposition .............................................................8

3.3.1 Web Service Composition from SQL Stored Procedures................................. 8

3.3.2 Web Services Composition from other Application Logic Sources...................15

3.3.3 Web Service Deployment .........................................................................26

4 Appendix ............................................................................................. 28

4.1 Demo and Northwind Database ...................................................... 28

4.2 Industry Standards Support ........................................................... 28

4.3 Related Links................................................................................... 28

1 Preface

1.1 Objective

Thank you for taking the time to evaluate OpenLinks Virtuoso Universal Server 4.5. This guide introduces the Virtuoso 4.5 Server as well as Virtuoso’s new administration and configuration tool, the Virtuoso Conductor.

This guide takes you through Virtuoso, covering virtual and federated database, publishing and utilizing web services, XML storage, processing and querying, business process management and more.

We illustrate these aspects of the product with sample code and Queries against the Virtuoso Demo database as well as links to documentation, tutorials and other key resources.

OpenLink Software hopes you find this guide informative while you learn what Virtuoso has to offer for your enterprise.

For More information on Virtuoso or OpenLink Software, contact us at:

Sales: sales@openlinksw.com General general.information@openlinksw.com Technical Support technical.support@openlinksw.com

Or visit our web sites:

OpenLink Software http://www.openlinksw.com Virtuoso http://virtuoso.openlinksw.com

1.2 System Requirements

The Virtuoso Universal Server installation contains the Virtuoso VDBMS, server administrator web files, and Virtuoso client connectivity.

Software

• Virtuoso Universal Server 4.5

• Virtuoso Conductor VAD 1.00.3051

Virtuoso is available on a number of hardware platforms. Listed below are some of the operating system ports currently available.

Hardware

• Microsoft Windows 2000, XP (32 and 64 bit platforms), Server 2003

• Linux (Intel and AMD64) (glibc2.1, glibc2.2, glibc2.3 compatible)

• Linux (IBM pSeries 64 bit)

• Mac OS X 10.2+ ("Jaguar") & 10.3+ ("Panther")

• Solaris 2.8 / 2.9 (Sparc)

• AIX 4.3.x/5.0.x/5.1.x 32 and 64 bit Power PC

Operating Systems and Browsers

• IE 6.0, Mozilla (Firefox), Opera, etc.

1.3 Installation

Download the Virtuoso 4.5 installer from OpenLink Software Virtuoso Download area at:

http://oplweb.openlinksw.com:8080/download. Install both default and demo databases

by following the instructions provided by the installer. At the end of the installation process, the Virtuoso server will be installed with both default and demo databases.

On Windows, the Virtuoso start menu will appear which provides menu options for the Conductor, Web Applications, the 3.5 Classic Administration tool and links to other resources as shown in Figure 1 - Virtuoso Start Menu.

Figure 1 - Virtuoso Start Menu

2 Virtuoso Universal Server

2.1 Introduction

This reviewer’s guide presents Virtuoso 4.5, the latest version of OpenLink Software’s next-generation Universal Server Platform. Virtuoso facilitates the development and deployment of a new generation of Enterprise-wide, Internet-, Intranet-, and Extranetbased solutions. Virtuoso capabilities include handling of Disparate Databases & Data Sources, Web Service Composition and Business Process Integration.

The conceptual architecture diagram below highlights Virtuoso’s key features.

Figure 2 - Virtuoso Conceptual Architecture including:

• Enterprise Data Integration –Virtuoso Virtual Database Engine

• Web Services Composition –Web Services Platform

• Introduction to Process Integration – Blog, BPEL, etc.

Figure 2 - Virtuoso Conceptual Architecture

The sections throughout this guide are aimed at demonstrating Virtuoso’s value proposition in these key areas. The step-by-step examples will quickly introduce you to Virtuoso and show you many useful techniques and features. The examples grouped by area include:

Enterprise Data Integration

• Identifying disparate data for integration and linking the data into Virtuoso

• Creating XML based documents or ODBC data sources for heterogeneous data

Web Services Composition

• Identifying monolithic applications from which services are to be decoupled, composing, and linking their functionality into Virtuoso

• Creating virtual directories as endpoints for exposing functionality for web services clients.

Process Integration

• See the OpenLink BPEL Process Manager Reviewers Guide for more information.

3 Web Services Platform

3.1 What Is This?

As a Web Services Platform, Virtuoso includes built-in support for WSDL, SOAP, UDDI WS-Security, and several other Web Services Protocols.

It enables the creation and composition of Web Services from existing application logic pools hosted within monolithic mission critical applications. Thus, the process of creating a SOAP and WSDL compliant Web Service from existing application logic resolves to the following steps:

 Identify the SQL Stored Procedures, Java Classes, .NET Assemblies, or C/C++

modules implementing the functionality in question.

 Use the HTML UI to trigger the generation of a WSDL file and SOAP invocation

wrappers for the application logic

 Use Virtuoso's HTTP Server functionality to create a Virtual Directory that acts as

an execution endpoint for your Web Service

 Test the usability of the new Web Service by interacting directly with an HTML

based Web Service verification page

 Proceed to using your newly created service with a Web Service aware

development tool, environment, or service

 Register your newly created service with Virtuoso's in-built UDDI Server, and then  advertise your service internally or externally to other service consumers.

Virtuoso facilitates the creation of SOAP compliant Web Services from existing or legacy monolithic applications without locking you into a host operating system, programming language/environment, or database engine. It enables you to perform the prerequisite step of creating and/or composing Web Services as part of your effort to cost effectively exploit emerging application architecture principles such as Service Oriented and Event

Driven Architectures.

3.2 The Value Proposition

Service Composition by exposure of existing time-tested application logic for invocation using Web Services protocols without any code re-writes. Code format support includes SQL Stored Procedures, .NET assemblies, Java Classes, C/C++ modules, etc.

Service Invocation Endpoints via HTTP/WebDAV based virtual directory and multi-homing functionality that provides endpoints for SOAP-, WS-Security-, WSDL-, and UDDIcompliant interactions with composite services.

3.3 Exploiting Value Proposition

3.3.1 Web Service Composition from SQL Stored Procedures

3.3.1.1 Linking/Attaching External SQL Stored Procedures

The following section includes steps for linking in external stored procedures from an ODBC Datasource. The steps in the example below uses a connected datasource called Demo_SQLSVR that maps to a Microsoft SQL Server database containing the Northwind schema.

Step 1. From the Conductor, navigate to the Database Tab, select the External

Datasources sub-tab and then the Connected Data Sources tab Select the Link objects link under the Actions column as shown below in Figure 3 –

External Procedures Management.

Figure 3 – External Procedures Management

Step 4. As seen in Figure 4 - Selecting the External Stored Procedures below,

when the page returns, a list is displayed of the available remote procedures. You can link any of the listed procedures into Virtuoso by selecting them from the list and pressing the Link Selected button.

Figure 4 - Selecting the External Stored Procedures

Step 5. In Figure 5 – Linking and Qualifying the Stored Procedures, a new

page listing the chosen procedures and their associated data type information is displayed. On this form, you can alter the data type mappings that Virtuoso will use both internally and for any future interactions with the SOAP server. If you do not want to specify any special type information, the details can be left as default.

+ 19 hidden pages

OpenLink Server 4.5 User Manual

Specifications and Main Features

Frequently Asked Questions

User Manual