7 Things You Need To Know about SQL Azure ReportingSolution ·
The SQL Azure Team had a quite interesting blog back in mid-November around the newly released SQL Azure Reporting. Here’s a summary of their nuggets about the new technology.
- It’s Based on SQL Server Reporting Services (SSRS)
SQL Azure Reporting provides a subset of the features of SSRS, therefore, the same tooling & artefacts apply: Business Intelligence Studio, tables, widgets (e.g. gauge, charts, maps) and the result is an RDL file.
- Report Execution Happens in the Cloud
The cloud is going to absorb the execution of report.
- SQL Azure Reporting is Part of the Windows Azure Platform
Which means the same advantages as the rest of the platform: scalability, quick provisioning & integration with the Azure Portal.
- The Data Source is SQL Azure
This is more of a limitation than anything at the moment. Basically the paradigm is that you run reports in the cloud against a DB in the cloud.
- Reports Are Exactly the Same Format
Nothing special needs to be put in the .rdl. It is an output of Business Intelligence Studio like any other report.
- There is Nothing New to Download and Install
Again, the same toolset
- You Can Access SQL Azure Reporting With a Browser
You do not need to deploy a web site and embed your reports into it (although you can): you can view the reports directly from SQL Azure Reporting. The reports are secured with Live ID by default.
A nice introduction to Azure SQL Reporting is the PDC 2010 Video by Nino Bice.