Transcript Introducing SQL Server 2000 Reporting Services Geoff Snowman Developer Community Champion [email protected] Microsoft Corporation http://blogs.msdn.com/gsnowman.

Introducing SQL Server 2000
Reporting Services
Geoff Snowman
Developer Community Champion
[email protected]
Microsoft Corporation
http://blogs.msdn.com/gsnowman
Reporting Services Vision
Enable employees at all levels of an
organization to realize the promise of BI
to promote better decision making
Delivered through
• Traditional and interactive reports
• Scalable, manageable and embeddable
server infrastructure
• Integration with SharePoint, Office applications,
browser and other familiar tools
• Single platform and tools for all types of structured
data (relational, hierarchical, multidimensional)
Licensing Model
SQL Server
Reporting Lifecycle
SQL Server Reporting Services supports the full
reporting lifecycle, including Authoring,
Management and Delivery
Authoring
Management
Delivery
demo
Sample Reports
demo
Reporting Authoring
Report Management
• Security
• Scalability
Caching Query Results
• History
• Data Connections
demo
Report Management
Report Delivery
• Pull Model
Report Manager
URL Addressability – CF Integration!
Web Service – CF Integration!
• Push Model
E-Mail
File Share
Custom
URL Addressability
• Any report can be displayed by typing a URL into
a browser
• Example:
http://server1/ReportServer/SalesReport?
CategoryID=1&EmployeeID=1
demo
URL Addressability
Web Service Interfaces
• Namespace
•
•
•
•
•
Management
Item Properties
Report Execution
Report Parameters
Report History
Data Source
Management
• Scheduling
• Subscriptions and
Delivery
• Linked Reports
• Job Management
• Security Management
demo
Web Service WSDL
demo
Push Delivery
Reporting Services Architecture
Browser
Data Sources
(SQL, OLE DB, ODBC,
Oracle, Custom)
Management
URL
Custom App
WMI
Web Service
Output Formats
(HTML, Excel,
PDF, Custom)
Report Server
Report Processing
Security Services
(NT, Passport,
Custom)
Data Retrieval
Rendering
Security
Delivery
SQL Server Catalog
Delivery Targets
(E-mail, File share,
Custom)
Programmatic Interfaces
• Customizable XML report definition
Open Schema
• Viewing Interfaces
URL Addressability
Web Service / SOAP
• Management Interfaces
Web Service / SOAP
WMI Interface
• Extension Interfaces
Data, Delivery, Rendering and Security
Key Differentiators
• Full Reporting Platform
All server components are extensible
Completely embeddable
Published, extensible report definition
• Scalability and Performance
Designed from day one to be a .NET
web service
Web farm architecture
Optimized processing and rendering
Reports execute as CLR assemblies
Next Steps
• Download the eval!
© 2004 Microsoft Corporation. All rights reserved.
This presentation is for informational purposes only. MICROSOFT MAKES NO WARRANTIES, EXPRESS OR IMPLIED, IN THIS SUMMARY.