Reporting and SQL Data Services
SQL Data Services (SDS) was shown at PDC in October, utilizing a REST based interface. As described in a previous posting, we also made available a SDS custom data extension for Reporting Services reports.
A few days ago, we announced that besides the REST interface, SDS will also expose SQL Server’s existing network protocol, Tabular Data Stream (TDS), directly as the service protocol and thereby extend the relational model directly to the cloud and enable new capabilities:
This is exciting news for Reporting Services report authors and users!
You will be able to just use the “SQL Server” data source type and point it to SDS to execute queries and stored procedures using the well-familiar T-SQL language. You also get schema discovery with the graphical query designer in Reporting Services.