Business Intelligence Blog from arcplan

Great Expectations – Users Expect Web Services Data on Their BI Dashboards


I bet when you were building your Business Intelligence application, it never occurred to you that your users would be so demanding. After all, you’ve managed to provide them reports and charts containing all the data they entered into the system. Now, in addition to the data in your internal systems, they’re asking you to add in data from other sources that you have no control over. This is actually the latest trend and I’m convinced it’ll get worse before it gets better. In the old days, you could just tell them you don’t have the data and it would cost a lot of money to bring the information feed in-house. But like I said in my previous article on user expectations, your users already have access to this data on their home computers and they expect the same type of information access from the BI systems they use to get their job done.

The good news is that those applications are using something that’s readily available to you — Web Services (WS). The reason this data used to be unavailable in the past is because the producers had no way of giving it to the consumers. They could dump the data into delimited files and email them to you, but what good would that have been?

Awhile back, a bunch of bright people came up with a way to simplify the process and the concept of Web Services was born. By defining the structure of their feeds, producers of information on the internet can give you instant access to all of their data. Generally, Web Services are a combination of Data Feeds and the Data Definition Language (DDL) that describes them called WSDL. WSDL is a standard way of telling another program what the data feed looks like by defining the input parameters, their format, and the output of the Web Service. To the right is an example of a Stock Quote service provided by

Continue reading this post >>