1 / 20

SharePoint and SQL Server 2005 Reporting Services Integration Explained (DAT205)

SharePoint and SQL Server 2005 Reporting Services Integration Explained (DAT205). Key Takeaways. Deep integration of Reporting Services 2005 with SharePoint Technologies Enables publishing, viewing, management, and delivery of SSRS reports in SharePoint libraries

arin
Download Presentation

SharePoint and SQL Server 2005 Reporting Services Integration Explained (DAT205)

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. SharePoint and SQL Server 2005 Reporting Services Integration Explained (DAT205)

  2. Key Takeaways • Deep integration of Reporting Services 2005 with SharePoint Technologies • Enables publishing, viewing, management, and delivery of SSRS reports in SharePoint libraries • Report web part for hosting rich reports in BI dashboards including filter Web Part integration • Leverage SharePoint collaboration and workflow capabilities with rich reporting

  3. SharePoint Integration Today • SSRS Integration with SharePoint ‘v2’ • Report Explorer allows users to browse and subscribe to reports • Report Viewer allows for users to view and navigate reports • Limitations • Separate content stores • Different security models • Different management UI • Not deployable outside of firewall • No filter web parts

  4. SSRS & SharePoint Integration • Seamless integration with SharePoint Document Library in Office SharePoint Server 2007 • Report server namespace and security is hosted in WSS content database • SharePoint database stores Report Server reports, data sources, models, resources etc. • Report Server database used for additional metadata (schedules, caching, subscriptions) • Enables collaboration, workflow, versioning

  5. SSRS & SharePoint Integration • Centralized user interface for Report Management through Office SharePoint Server 2007 • Upload, manage, render and deliver Reports all through Office SharePoint Server 2007 UI • Administration using Office SharePoint Server 2007 • Rich reporting experience to “light up” Office SharePoint Server 2007 • Filter web parts enhancing dashboards in Office SharePoint Server 2007

  6. Document Library Integration

  7. SSRS Add-In Install SQL Server 2005 SP2 SSRS 2005 SP2 Report Server Reporting Services Add-in Security Extension Catalog Management Report Viewer Web Part Report Management UI WSS Object Model WSS Object Model Report Server DB SharePoint Content DB Architecture WSS 2007

  8. Get Master Copy from WSS DB NO Run Report Yes Yes ON Database Integration • WSS Content Database stores the master copy of SSRS items Master? Exists? • Schedules, caching, and subscriptions are stored in SSRS database only • No automated migration path from existing SSRS installations

  9. Report Tools • Report Designer, Report Builder, Model Designer are updated to work in SharePoint Integration mode. • Report Manager, Management Studio, My Reports, Linked Reports, and Job Management SSRS features not supported in SharePoint Integration mode • Reports, data sources, and report models are managed via the SharePoint user interface.

  10. Report Builder Integration

  11. ReportViewer Web Part • Used in full page view or on Web Part Pages • Wraps the ReportViewer ASP.NET Control • Handles report rendering calls to report server • Supports Filter consumer and Row consumer interfaces for specifying report parameter values via filter web parts • Can slice Excel Workbooks and reports together

  12. Report Viewer

  13. Programmability Details • New report server SOAP endpoint for use in SharePoint Integrated mode only. • Database integration in SharePoint Integrated mode results in SOAP APIs call into WSS DB’s using WSS OM • Updated WMI provider for use in Native or SharePoint Integrated mode • Reporting Services security role definitions are replaced with SharePoint roles.

  14. CreateReportoperation CreateSchedules operation Manage Web Site Add Items CreateReport( ) CreateSchedule( ) Security Mapping • SSRS security operations map to SharePoint Web or List rights. • New Site permissions replace System permissions. • Model Item security is still managed by SSRS.

  15. WSS Web Application with Windows Authentication WSS Web Application (non-Kerberos or Custom Authentication) Non-Windows User Windows User SSRS SP2 Trusted Account & SharePoint User token Windows User Security Modes • Windows Integrated & Trusted Account

  16. Summary • Seamless integration with SharePoint Document Library in Office SharePoint Server 2007 • Centralized user interface for Report Management through Office SharePoint Server 2007 • Rich reporting experience to “light up” Office SharePoint Server 2007

  17. Resources • Reporting Services on the web: http://www.microsoft.com/SQL/Reporting

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

More Related