I have a question, I have ms sql data base, with lot of data, but I have to add data from a web services, may it be possible ?
The preferred way to accomplish this would be to import the web service information into a database, and then add it to your DSV to make it available to the cube. Take a look at SSIS, as it can communicate with web services, and then write the data to a database.|||SSIS will also allow you to take data from a data source (like a web service) and "push" it directly into an OLAP partition. The advantage of pushing into a relational database first is that if you ever need to do a full process of you OLAP database the data is sitting there and you will not need to hit the webservice.
No comments:
Post a Comment