1 / 25

OFS330 SSRS 2008R2 Integration With SharePoint 2010

OFS330 SSRS 2008R2 Integration With SharePoint 2010. Peter Myers Mentor Solid Quality Mentors. Presenter Introduction. Mentor, Solid Quality Mentors BBus , MCITP ( Dev , DBA, BI), MCT, MVP 13 years’ experience designing and developing software solutions using Microsoft products

spyridon
Download Presentation

OFS330 SSRS 2008R2 Integration With SharePoint 2010

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. OFS330SSRS 2008R2Integration With SharePoint 2010 Peter Myers Mentor Solid Quality Mentors

  2. Presenter Introduction • Mentor, Solid Quality Mentors • BBus, MCITP (Dev, DBA, BI), MCT, MVP • 13 years’ experience designing and developing software solutions using Microsoft products • pmyers@solidq.com

  3. Session Overview • SSRS Integration with SharePoint • What’s New in SSRS 2008 R2 • Easier installation and configuration • Local mode reporting • Access Reporting • SharePoint List Reports • Reporting Service 2008 R2 SharePoint Mode Support Matrix

  4. SSRS Integration with SharePoint • Integration with SharePoint 2007 • Integration with SharePoint 2010

  5. Microsoft Business Intelligence Business Productivity Suite Business Collaboration Platform Reports Central Admin Information Platform Reporting Services

  6. Integration with SharePoint 2007SQL Server SSRS 2005 SP2 and 2008 • Seamless authoring, publishing, viewing in full-page or dashboards, management, and delivery of reports via SharePoint user interface • Full support of SSRS capabilities in SharePoint environment • Leverage SharePoint collaboration and workflow capabilities with rich reporting experience • Shared security principles across SSRS and SharePoint

  7. Integration with SharePoint 2010SQL Server Reporting Services 2008 R2 • SharePoint pre-requisite utility installs SSRS R2 Add-in for SharePoint 2010 • PrerequisiteInstaller.exe • SSRS R2 Add-in can install before installing SharePoint 2010 • SSRS 2008 R2 is the reporting engine for Access 2010 reporting in SharePoint 2010 • Native SharePoint List reporting

  8. SQL Server Reporting Services 2008 R2One-step Configuration and More • One-step configuration within SharePoint Central Admin • One page for configuring RS integration • Convenient feature activation • Other new features of SSRS 2008 R2: • ReportBuilder 3.0 with Report Parts • AJAX ReportViewer • New data visualizations (Map, Data Bar, Sparkline and Indicators) • ATOM feeds

  9. Report Viewer Web Part Peter Myers Mentor Solid Quality Mentors demo

  10. SSRS R2 Integration with SharePoint 2010: Report Viewer Web Part | Access Reporting |SharePoint List Reporting Peter Myers Mentor Solid Quality Mentors demo

  11. SSRS 2008 R2 Add-in SSRS 2008 R2 Report Server in SharePoint Mode Reporting Services Add-in Security Extension Data Management Report management UI Report Viewer web part SharePoint Object Model SharePoint Object Model Connected Mode Architecture SharePoint 2010 WFE (Connected Mode) (Local mode) SSRS Proxy Report Sever DB SharePoint Config / Content DB

  12. SQL Server Reporting Services 2008 R2More New Features • Alternate Access Mapping support • SharePoint ULS Logging • Claims : Trusted Account mode will continue to work in Claims enabled SharePoint 2010

  13. Report Server Report Viewer web part SharePoint Object Model SharePoint Object Model Trusted Account Flow in Claims SharePoint WFE (Service Acct. = User2 ) Security Mgmt SSRS Proxy Data Management Render (User 1 SP token) (User2) HTTP REQ (User1 SP Token) Render Processing & Rendering On-Demand Sync Output (User2) HTTP SOAP RESPONSE (User 1) User1 Sharepoint Token (Claims Authenticated) Report Sever DB SharePoint Config / Content DB

  14. SQL Server Reporting Services 2008 R2Local Mode: Out-of-box Reporting Capability in SharePoint 2010 • SharePoint pre-requisite utility installs SSRS add-ins • Supports local mode rendering of reports from SharePoint without integrating Reporting Services • In Local Mode, you can render only: • SharePoint Lists reports • Access reports • Central Admin configuration pages allows switching between Local and Connected Mode

  15. Local Mode Reporting Peter Myers Mentor Solid Quality Mentors demo

  16. SSRS 2008 R2 Add-in SSRS 2008 R2 Report Server in SharePoint Mode (SSRS 2005 SP2, 2008, 2008 R2) Reporting Services Add-in Security Extension Data Management Report management UI Report Viewer web part SharePoint Object Model SharePoint Object Model Local & Connected Mode Architecture SharePoint 2010 WFE (Connected Mode) (Local mode) SSRS Proxy Report Sever DB SharePoint Config / Content DB

  17. SSRS 2008 R2 Integration with SharePoint2010Other Improvements • Performance improvements • Reduced average number of SharePoint OM calls per render request • Removed additional hop between UI and proxy in RS Add-in • RS.EXE enabled to script against SharePoint endpoints • 37 languages support including Bi-Di support in RS Add-in

  18. Report Server Report Viewer web part SharePoint Object Model Report Rendering Now… SharePoint WFE (Service Acct. = User2 ) Security Extension Report Viewer Web Part SSRS Proxy SSRS Proxy Data Management Render (User1) (User1) HTTP REQ Render (User1) HTTP REQ Processing & Rendering On-Demand Sync Output (User1) HTTP RESPONSE (User 1) Report Sever DB SharePoint Config / Content DB

  19. Reporting Services SharePoint Mode Scaled Out Report Server SharePoint Farm Reporting Data RS Scale Out Deployment Report Catalog

  20. Working with the RS Utility Peter Myers Mentor Solid Quality Mentors demo

  21. SSRS 2008 R2 and 2008 Support MatrixSharePoint 2010 and 2007 • Report Server 2008 R2 support: • For SharePoint 2010 use SSRS 2008 R2 Add-in • For SharePoint 2007 use SSRS 2008 SP2 Add-in • Report Server 2008 support: • For SharePoint 2007 continue using SSRS 2008 Add-in • For SharePoint 2010 use SSRS 2008 R2 Add-in and apply report server patch 2008 SP1 CU8 • Relies on SharePoint 2010 backward compatibility

  22. Resources • Overview of Reporting Services and SharePoint Technology Integration • http://msdn.microsoft.com/en-us/library/bb326358.aspx • Features supported by SSRS in SharePoint Integrated Mode • http://msdn.microsoft.com/en-us/library/bb326290(SQL.105).aspx • SSRS SharePoint Integration blog: Prash Shirolkar • http://blogs.msdn.com/b/prash/ • Whitepaper: “Configuring Kerberos Authentication for Microsoft SharePoint 2010 Products” (including SSRS 2008 R2) • Search http://microsoft.com/downloads, or • http://go.microsoft.com/fwlink/?LinkID=196600

  23. Session Evaluations Tell us what you think, and you could win! All evaluations submitted are automatically entered into a daily prize draw*  Sign-in to the Schedule Builder at http://europe.msteched.com/topic/list/ * Details of prize draw rules can be obtained from the Information Desk.

  24. © 2010 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.

More Related