windows azure sql reporting name title microsoft corporation
TRANSCRIPT
Windows Azure SQL Reporting
NameTitleMicrosoft Corporation
Agenda
Overview
Architecture
Features
Walkthrough
Overview
SSRS Windows Azure SQL Reporting
Reporting Services
Azure infrastructure
SQL Azure connectivity
Windows Azure portal
Datacenters worldwide
SQL Reporting
Same Cloud BenefitsEnterprise-class scalability
Automatic support for High-Availability
Rapid provisioning
Trusted and familiar security model
Global Distribution
SQL Databas
e
Architecture
Architecture – What’s Under The Hood
Load Balancer
Gateway GatewayGateway
RS InstanceMonitor/Comm[SLA & Usage][Performance][Traces & Logs]
RS Engine
RS InstanceMonitor/Comm[SLA & Usage][Performance][Traces & Logs]
RS Engine
RS InstanceMonitor/Comm[SLA & Usage][Performance][Traces & Logs]
RS Engine
SQL Database
RS GPMTenant Data
Operations
Directory Services
Allocation + Service
Customer Service
SLA Conformation
Load Balancing
Billing/Usage
Monitoring[Alerting]
[Performance][Traces & Logs]
http://server.reporting.windows.net/reports/report.rdl
Features
Key Features
SQL Server Reporting as a ServiceRich Reporting Experience
Manageability
Familiar Development Tools
High Availability and Scalability
Feature Comparison
SSRS Azure SSRS
Tooling BIDS, Report Builder BIDS, Report Builder
Data Sources Assorted Data Sources SQL Database
Report Management Report Manager or SharePoint Windows Azure Developer Portal, URL Browsing
Developer Custom Data Sources, assemblies, etc.
No extensibility yet
Security Model Windows Authentication SQL Database Authentication
Security
SQL Server Reporting as a ServiceCredentials not saved in report definition
Shared data sources
Same roles and permissions model as SSRS
Separate Catalog and TempDB for each Tenant
SQL Database username and password authentication
Programmability Interface
SQL Reporting APIAPI from SSRS available in SQL Reporting
Extend SQL Reporting to develop additional features
Upload/Export Reports
Set Configuration
Render Reports Using SOAP API
rsExecutionContext = new ReportExecutionService();
rsExecutionContext.LoadReport("/Folder/ReportName", null);
//render report to required format byte[] result = rsExecutionContext.Render(reportFormat,
null, out extension, out encoding, out mimeType, out warnings, out streamIDs);
AccessibilityDirect URL AccessSend a URL in an email
Embed in a website
Embed in SharePoint / SharePoint Online
AvailabilityWho can use it?Anyone with a Windows Azure Subscription
Any authorized user can view a report
SQL Reporting Management
Demo
Walkthrough
Sample
Copyright 2011, AppDev Products, LLC. All Rights Reserved.
Server CreationServerAdministrator
Report CreationSQL Server Data ToolsBusiness Intelligence Development Studio Report DeploymentSet properties Deploy single or multiple reports
SQL Reporting – Creation and Deployment
Demo
© 2011 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries.The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to
be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.
Pricing• The price is correlated to usage:
• No servers No Charge
• Servers are charged by the hour
• Every hour a server may render up to 200 reports for
$0.88/hour
• SQL Reporting scales automatically: additional instances
of 200 reports will cost $0.88/hour