Connected at the hip for MS BI: SharePoint and SQL

Please download to get full document.

View again

All materials on our website are shared by users. If you have any questions about copyright issues, please report us to resolve them. We are always happy to assist you.
 5
 
  SQL Server has always been the foundation of the Microsoft Business Intelligence (BI) story. However, SharePoint has quickly moved into being the presentation layer for this important data. In this session, you will learn the many different options for combining SharePoint and SQL, the location of all the different pieces, how these pieces communicate, some licensing hints, and how Kerberos helps tie it all together.
Related documents
Share
Transcript
  • 1. Connected at the hip for MS BI: SharePoint and SQL Presented by: JD Wade, Lead Technical Architect Horizons Consulting Mail: jd.wade@hrizns.com Blog: http://wadingthrough.com LinkedIn: http://linkedin.com/in/jdwade Twitter: @JDWade
  • 2. Agenda • Primer • SQL Reporting Services • SQL Analysis Services • Knick Knacks
  • 3. Primer
  • 4. Config Content Service Application 3rd Party BI
  • 5. Delegation
  • 6. Srv1 Datamart Srv2 Cubes Srv3 Srv4 Web Delegation Defaults
  • 7. Srv1 Datamart Srv2 Cubes Srv3 Srv4 Web Unconstrained Delegation
  • 8. Srv1 Datamart Srv2 Cubes Srv3 Srv4 Web Constrained Delegation
  • 9. FBA Kerberos Protocol Transition
  • 10. Srv1 Datamart Srv2 Cubes Srv3 Srv4 Web Constrained Delegation w/ Protocol Transition
  • 11. • Uses Protocol Transition (Forest/domain limited until Server 2012) (Constrained Only) • Excel Services • Excel Online • PerformancePoint • SQL SSRS 2012/2014/2016 •Does NOT Use Protocol Transition (Forest limited until Server 2012) (Unconstrained or Constrained) • SQL Reporting Services 2008 R2 •Doesn’t usually require Kerberos • PowerPivot for SharePoint Server
  • 12. SQL Reporting Services
  • 13. SP Web SP App Database Engine SSRS ULS SQL Server 2008 R2 SharePoint 2010 SQL Server 2014 Add-in Data Sources
  • 14. SP Web SP App Database Engine ULS ULS SQL Server 2012 SharePoint 2010 SQL Server 2012 Add-in Data Sources
  • 15. SP Web SP App Database Engine ULS ULS SQL Server 2012 SP1 SharePoint 2010 SQL Server 2014 Add-in Data Sources
  • 16. SP Web SP App Database Engine ULS ULS SQL Server 2012 SP1 SharePoint 2013 SQL Server 2014 Add-in Data Sources
  • 17. SP Web SP App Database Engine ULS ULS SQL Server 2014 SharePoint 2010 SQL Server 2014 Add-in Data Sources
  • 18. SP Web SP App Database Engine ULS ULS SQL Server 2014 SharePoint 2013 SQL Server 2014 Add-in Data Sources
  • 19. SQL Reporting Services for free! Local Mode
  • 20. SQL Analysis Services
  • 21. SP Web SP App SSAS SSAS ULS SQL Server 2008 R2 SharePoint 2010/2013 SQL Server 2008 R2 Add-in Data Sources
  • 22. SP Web SSAS ULS SQL Server 2012 SharePoint 2010/2013 SQL Server 2012 Add-in SP App SSAS Data Sources
  • 23. SP Web SP App SSAS SSASULS SQL Server 2012 SP1 SharePoint 2010/2013 SQL Server 2012 SP1 Add-in Analysis Services Data Sources
  • 24. SP Web SP App SSAS SSASULS SQL Server 2014 SharePoint 2010/2013 SQL Server 2014 Add-in Analysis Services Data Sources
  • 25. Full BI functionality in SP2013 SQL reporting
  • 26. Knick Knacks
  • 27. SP Web SP App SSAS SSASULS SQL Server 2016 SharePoint 2013 SQL Server 2016 Add-in Analysis Services Data Sources
  • 28. •New PowerShell parameter •PrincipalsAllowedToDelegateToAccount •Constrained Delegation across forests and domains •Must have at least one W2K12 DC in all domains involved •SharePoint must be running on W2K12 servers •Backend server must be W2K3 or later •Must apply MS KB 2665790 to all W2K8 and W2K8 R2 DCs •Must not have W2K3 DCs • New KDC operational event log in W2K12 • Application and Services/Microsoft/Windows/Kerberos-Key-Distribution-Center/Operational •New Kerberos operational event log in W2K12 • Application and Services/Microsoft/Windows/Security-Kerberos/Operational •Performance counters added Windows 2012
  • 29. Q & A http://wadinghthrough.com/presentations http://www.hrizns.com http://twitter.com/jdwade
  • Related Search
    Similar documents
    View more
    We Need Your Support
    Thank you for visiting our website and your interest in our free products and services. We are nonprofit website to share and download documents. To the running of this website, we need your help to support us.

    Thanks to everyone for your continued support.

    No, Thanks