Combining Web Services and SQL Server Data Utilizing Business Objects Business View Manager - Part 1
page 3 of 6
by Eric Landes
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 25413/ 61

Setting up the Data

For this article, we will use the pubs sample database for SQL Server.  For the purpose of this report we create a report showing the sales of each book, including information from where the book was manufactured.   To create this report, we will use the following tables:

·         Authors

·         Publishers

·         Title/author

·         Titles

·         Sales

·         Stores

See Figure 1 for a graphic of those tables.  One thing that is not included in the pubs database is a manufacturing ID.  We will need that to join our Web Service data to our data from this database.  So we will need to add that field to a table.  Normally it might be included in the actual orders table, but for the purposes of this article, we will add this to the Sales table.  We are creating this ID so that there we can link between the manufacturing information in our "ERP" system and the data in our Database.

Figure 1

To create the new column called "mfgid" we need to go into the query analyzer and execute the following commands:

Listing 1

Use pubs
alter Table dbo.sales add mfgid int

These add the foreign key that we will connect our Web Service to.

View Entire Article

User Comments

No comments posted yet.

Product Spotlight
Product Spotlight 

Community Advice: ASP | SQL | XML | Regular Expressions | Windows

©Copyright 1998-2021  |  Page Processed at 2021-11-26 10:04:17 PM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search