Combining Web Services and SQL Server Data Utilizing Business Objects Business View Manager - Part 2
page 1 of 7
Published: 12 Dec 2006
Eric concludes this 2 part series by showing how to set up Business Objects Business Views to consume the two data sources set up in Part 1.
by Eric Landes
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 27478/ 78


As mentioned in Part 1 of this article, there are many times your customers may want reports that combine data from different sources.  In this article we will concentrate on putting the data together in Business Objects Business Views.

In Part 1 of this article, we showed how to combine a web service with some sales data in our SQL Server database.  We created a mock web service and then gave a quick example of how we might then implement a real web service from our ERP.  We also had to modify our database to add a foreign key that will allow Business Views to join the 2 different data sources.

The report we are working on shows sales data about the books we have sold.  It also includes information on where the book was "manufactured," even though that information is not in our main database.  The data sources are set, now we just need to connect them and show that in a report.

View Entire Article

User Comments

No comments posted yet.

Product Spotlight
Product Spotlight 

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

©Copyright 1998-2024  |  Page Processed at 2024-05-18 3:46:39 PM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search