Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

James Serra's Blog

James is currently a Senior Business Intelligence Architect/Developer and has over 20 years of IT experience. James started his career as a software developer, then became a DBA 12 years ago, and for the last five years he has been working extensively with Business Intelligence using the SQL Server BI stack (SSAS, SSRS, and SSIS). James has been at times a permanent employee, consultant, contractor, and owner of his own business. All these experiences along with continuous learning has helped James to develop many successful data warehouse and BI projects. James has earned the MCITP Business Developer 2008, MCITP Database Administrator 2008, and MCITP Database Developer 2008, and has a Bachelor of Science degree in Computer Engineering. His blog is at .

SharePoint dependencies

Microsoft has made a big push the last few years to have all its end-user BI tools integrate with SharePoint, which is great if your company is using SharePoint.  Not so great if your company is not using SharePoint or if it is used internally but not setup to be used externally (i.e. customer-facing).  With that in mind, here are the SharePoint dependencies on all the tools so you know what you might not be able to use:

Power View: is required since reports can only be viewed thru SharePoint, but this will change starting with Excel 2013 as Power View will be an add-in to Excel 2013 that does not require SharePoint

PowerPivot: is required if you wish to share Excel workbooks that contain PowerPivot data via SharePoint (called “PowerPivot for SharePoint”).  Otherwise you would have to share PowerPivot workbooks via email, file share, etc.

PerformancePoint: requires it since it is part of SharePoint 2010

ProClarity: does not require it.  One reason this old tool still has some use!

SSRS: does not require it for SSRS native mode but obviously requires it for SSRS SharePoint integration mode

Excel: does not require it, but does for Excel Services (Excel Services is a service application that enables you to load, calculate, and display Microsoft Excel workbooks on Microsoft SharePoint Server)

Report Builder: Report Builder installs with a SQL Server Reporting Services report server configured for either native mode or SharePoint integration mode.  So obviously does not require SharePoint if in native mode but requires it if in SharePoint integration mode


Leave a comment on the original post [, opens in a new window]

Loading comments...