Hello,
Is it possible to connect to relational databases with the xamPivotGrid? Or is it only possible to connect with olap databases?
Greetz,
Geert De Vylder
Answer not really fit the topic , if you really forced to just use relatinal because sql server express just has that this answer helps you not at all ;)
Sadly it's the case in my case ^^ why is the oledpb adapter fro winforms version not portet ^^
Hi Plamen,
Thank you very much for your answer. I will look into it and see how we can implement this for our application and database.
Regards,
Geert
Hello Geert,
We are still following this forum thread.
Please feel free to let us know if you have any other questions with this matter.
In order to use XamPivotGrid you should consider to use SQL Server Analysis Services (SSAS) built over your relational database and then use XmlaDataSource instance as data source for XamPivotGrid. Also here you can find how you can set up your SSAS to provide access through XMLA:
http://ko.infragistics.com/community/blogs/atanas_dyulgerov/archive/2010/01/27/how-to-set-up-xmla-http-access-for-sql-server-analysis-service-2008-and-access-the-adventure-works-2008-from-an-infragistics-pivotgrid-application.aspx
Another option is to bring your data to the client application using for example Entity Framework, then as data source you can use FlatDataSource instances. Good starting point for using FlatDataSource are the Silverlight's online samples you can find here:
http://ko.infragistics.com/products/silverlight/pivot-grid/
If you require any further assistance, please do not hesitate to ask.
Best regards,Plamen