OpenLink Software Server 4.5 ユーザーズマニュアル
Virtuoso 4.5 Application and Integration Reviewers Guide
Copyright ©2006 OpenLink Software
Copyright ©2006 OpenLink Software
8
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.
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.
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.
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.