DBA 230 Introducing SQL Server 2000 Reporting Services

DBA 230 Introducing SQL Server 2000 Reporting Services Jason Carlson Product Unit Manager SQL Server Microsoft Corporation

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 Share. Point, Office applications, browser and other familiar tools Single platform and tools for all types of structured data (relational, hierarchical, multidimensional)

Scenarios Enterprise Reporting In-house reports (Sales, Finance, HR) Manageability, portal and LOB integration Embedded Reporting Report processing included in applications Extensible, embeddable architecture B 2 B Reporting Partner reporting via extranets, Internet Data isolation, extensible security

BI User Profiles Analysts 5 -10% of users SQL Server Analysis Services Information Explorers 15 -25% of users SQL Server Reporting Services Information Consumers 65 -80% of users

Reporting Lifecycle SQL Server Reporting Services supports the full reporting lifecycle, including Authoring, Management and Delivery Authoring Management Delivery

Report Authoring Report developers can create reports to be published to the Report Server using Microsoft or 3 rd party design tools that support the Reporting Services XML Report Definition Language (RDL) Authoring Management Delivery Online Access Report Definition Managed Report Delivery Channels

Report Management Report definitions, folders, and resources are published and managed in a reporting web service; Managed reports can be executed either on-demand or via schedule and are cached for consistency and performance Authoring Management Delivery Online Access Report Definition Managed Report Delivery Channels

Report Delivery Reporting Services supports both on-demand (“pull”) and event-based (“push”) delivery of reports; Users can view reports from a web-based front-end or subscribe for reports to be delivered in e-mail Authoring Management Delivery Online Access Report Definition Managed Report Delivery Channels

demo Reporting Services Brian Welcker Group Program Manager SQL Server Microsoft

Report Delivery Single report definition can be rendered to diverse output formats Web Formats (HTML 4, HTML 3. 2, HTML w/OWC) Print Formats (TIFF, RTF, PDF) Data Formats (Excel, XML, CSV) Personalized and administrator defined subscription and delivery Ability to select output formats per subscription Can deliver links as well as rendered reports Data-driven subscriptions for personal delivery Extensible delivery provider architecture E-mail, File System, Custom

Report Authoring Powerful, XML Report Definition Language Freeform / Table / Matrix / Chart Parameters (Dynamic, Hierarchical) Sorting / Filtering / Grouping / Aggregates Interactivity (Drill-down, Drill-through) Full VB. NET Expression Language Extensible query execution architecture SQL Server / Analysis Services OLE DB / ODBC / Oracle Report Designer Integrated with Visual Studio. NET 2003 Published definition enables 3 rd party tools

Report Management Web Service APIs for management Web and Win 32 management user interfaces Report Management Functions Report Metadata (Name, Description, Connections, Credentials, Parameters) Scheduling integrated with SQL Server Agent Execution properties (live, cache or snapshot) History of prior executions Extensible, role-based security architecture

Reporting Services Architecture Browser Data Sources (SQL, OLE DB, ODBC, Oracle, Custom) Management URL Custom App WMI Web Service Report Server Output Formats (HTML, Excel, PDF, Custom) Report Processing Security Services (NT, Passport, Custom) Data Retrieval Rendering Security Delivery SQL Server Catalog Delivery Targets (E-mail, File share, Custom)

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 Online Session Evaluations! Signup for Reporting Services Beta Public Beta in Late Summer Signup on http: //www. microsoft. com/sql RTM by end of 2003

Additional Resources Visit the “Ask the Experts” area for follow up questions Attend the Reporting Services sessions at Tech Ed DBA 230 – Introducing SQL Server 2000 Reporting Services DAT 235 – Authoring reports using SQL Server 2000 Reporting Services DBA 331 – Managing a Microsoft SQL Server 2000 Reporting Services implementation Hands-On Lab HOL 03 – SQL Server Reporting Services

Community Resources http: //www. microsoft. com/communities/default. mspx Most Valuable Professional (MVP) http: //www. mvp. support. microsoft. com/ Newsgroups Converse online with Microsoft Newsgroups, including Worldwide http: //www. microsoft. com/communities/newsgroups/default. mspx User Groups Meet and learn with your peers http: //www. microsoft. com/communities/usergroups/default. mspx

evaluations

© 2003 Microsoft Corporation. All rights reserved. This presentation is for informational purposes only. MICROSOFT MAKES NO WARRANTIES, EXPRESS OR IMPLIED, IN THIS SUMMARY.