SQL Azure Reporting

Deliver rich reporting, without having to maintain an infrastructure.

Microsoft SQL Azure Reporting lets you use the familiar on-premises tools you’re comfortable with to develop and deploy operational reports to the cloud. There’s no need to manage or maintain a separate reporting infrastructure, which leads to the added benefit of lower costs (and less complexity). Your customers can easily access the reports from the Windows SQL Azure portal, through a web browser, or directly from your applications.

While SQL Azure Reporting is not yet commercially available, you can register to be invited to the community technology preview (CTP).
Use SQL Azure Reporting to:

* Deliver rich insights to your customers without building and managing a reporting platform in house.
* Create robust, easy-to-read reports available directly within your applications, on the SQL Azure portal or online via a browser.
* Keep your data secure while offering access to even more users. The rich authentication/authorization model gives reliable, secure access to reports and underlying data.

Top features:

The Business Intelligence Design Studio (BIDS) offers a consistent report authoring experience that make your reports rich with visualizations – maps, charts, gauges, sparklines and more.

Export to various popular file formats, including Excel, Word, HTML, PDF, XML, CSV and ATOM feeds.

Scale and flex to meet elastic demand. Our cloud services platform automatically scales up and down to meet demand and has built-in high availability and fault tolerance.

Here’s a quick comparison between cloud-based SQL Azure Reporting and on-premises SQL Server Reporting Services:

Capability


SQL Server Reporting Services


SQL Azure Reporting

Developer design tool


Business Intelligence Design Studio

(BIDS)Report Builder


Business Intelligence Design Studio (BIDS)

Report Builder (Authoring only - deployment to SQL Azure Reporting through BIDS)

Supported data sources


Diverse data sources


SQL Azure databases

Report


Embed reports into your apps


Embed hosted reports into your apps

Management and delivery


Report Manager or SharePoint Portal

display reports

rendering to multiple formats

subscriptions

scheduled delivery


SQL Azure Development Portal

display reports

rendering to multiple formats

Developer Extensibility


Extensible for custom data sources, assemblies, report items, authentication, etc.


Extensibility is not yet enabled

Security Model


Windows Authentication


SQL Azure Username/password
SQL Azure Labs

Watch the PDC keynote video