Has anyone built a custom provider that can hook up to a backend SSAS database, or can direct me to information that can help me create one? I would like to not have to use msmdump.dll if there is an alternative.
Thanks
Cort
Hi, Cort,
I'm currently working on a sample that will demonstrate how to do this. I'll post it here when it is ready.
All the best,
Atanas
Hi,
I'm attaching a working solution, that uses a custom DataProvider that in turn uses a WCF service to access an MS Analysis Server and get data from it through the Adomd Client. The connection totally excludes the use of msmdpump.dll.
I will be publishing an article that clarifies how each part of this sample works. That will happen in the next two weeks. By that time feel free to experiment with the code in the zip file attached. I'll post the link to the post here when it is ready.
I hope this is helpful. Best regards,
P.S.
In order to make this sample work, you need:
to install the MS Adomd.NET Client. If you do not have it installed already you can download it freely from this location.
(optionally if the sample throws unknown exceptions) to install the following two components if you do not already have them:
They are part of the MS SQL Server 2008 R2 Feature Pack
Hi guys,
Atanas is on leave for a short while, but I've written an article that summarizes how to write the custom WCF/ADOMD data provider mentioned here. Check it out if you're interested:
http://community.infragistics.com/blogs/engineering/archive/2010/10/26/building-a-custom-data-provider-for-xampivotgrid-in-silverlight-using-wcf-and-adomd-net.aspx
Happy developing.
Hi Paulo,
Have you tried using RIA services to access the relational database? Take a look at this article and the one it refers to.
I hope this helps. Have a great day!
Todor
Hello Atanas,Is there any example of custom provider that works with relational database?Thanks,Paulo Corrêa
Like Mana from heaven ;)
We'll look into the problem and will get back to you when we have some more info. It might be a bug, but we have to verify it.
Thanks for the feedback!