Guys, can anyone point me to a definitive Microsoft map for where Reporting Services is going regarding using WCF Data Services (ADO.NET Data Services, Astoria) as a data source? There's bits of fragmented info out there, some about creating custom data providers, some about some sort of extension enable connection to the Azure storage layer (exposed as REST data service I believe) and some about connecting to latest versions of sharepoint (again, Sharepoint exposing its data as a REST service?), but there doesn't seem to be any sort of unified vision as regards reporting on REST services (I'm particularly interested in WCF Data Services). Have I missed a portal or something somewhere? What's the story with these two technologies?
Bit of background; we have a system where we've got our data exposed via WCF (ADO.NET, Astoria) data services. In this layer we've got all sorts of business rules shaping the data returned. What we'd like to do is use SQL Reporting services for our reporting needs, but give it the data service as the data source. We're thinking using either Report Builder or BI Studio to create the reports.
It looks like we'll have to generate our own data model, which is fine, and also create a custom data provider - and then also create a semantic query extension to translate the report queries into REST calls....now there's obviously a disconnect between what the report queries can do and what the WCF Data services REST api can do, which will be interesting.....
Just seems like a lot of work to have to do when Microsoft seem to be pushing WCF data services so hard - have I missed something or is there a gap in the story as far as reporting is concerned? Or are we just ahead of the curve with what MS will do eventually?