Reporting from Data in the Cloud (aka SSRS and SDS at PDC)

  • Article

PDC

One of the demos shown at Monday's PDC keynote by Ray Ozzie and Bob Muglia was Reporting Services with data stored in SQL Data Services (SDS) in the cloud.  Besides the keynote, there are several more sessions throughout PDC featuring Reporting Services - building those demos was a lot of fun!

How did we do this?  We built a small custom data extension for SDS utilizing the data source extensibility framework in Reporting Services.  This data extension will allow you to connect to SDS authorities and containers via HTTP SOAP to extract data sets, and build rich reports using standard tools like Report Designer / Report Builder and deploy the reports to Report Manager.

SQL Services Labs

As part of SQL Services Labs (also announced at PDC today), developers can now download the custom extension and configure it against their on-premise SSRS 2008 installation. More information, including the download, is available under the Reporting section of SQL Services Labs.

Enjoy!