Get OData or Atom Service feed for SSRS 2008 R2 Shared Dataset
Is there anyway to get a shared dataset to simply dump it's contents in an Atom or OData feed that can then be consumed somew开发者_运维知识库here else? In our scenario we want to build just the datasets and let users consume them from PowerPivot or elsewhere.
Thanks, Brent
You might find this useful:
http://technet.microsoft.com/en-us/library/ee240754.aspx
It does not look like SSRS can easily consume OData sources but that they are considering it.
http://connect.microsoft.com/SQLServer/feedback/details/559570/ssrs-should-be-able-to-use-odata-as-a-data-source
In the following article Mattias suggests a workaround that might meet your needs by using the XML data source and embedding your OData query in the URL
http://mskold.blogspot.com/2011/05/tfs-odata-services-as-data-source.html
精彩评论