Skip to content

How to Get SharePoint Data Into a Data Warehouse (And Back Again)

With apologies to J.R.R. Tolkien……

Yesterday, as part of the ongoing Panellist Spotlight series for SharePoint Shoptalk, I presented a session on how to move your data from SharePoint, and in to a data warehouse, and then consume the warehoused data directly within SharePoint. These presentations are recorded, and posted online, and if you’re interested, you can view the entire presentation below:

In it, I demonstrate how SQL Server Integration Services (SSIS) can be used to extract the data from SharePoint, and to store it in a SQL Server data warehouse. Then I walk through the creation of an external content type, and an external list using SharePoint Designer and SharePoint Business Connectivity Services (BCS). Finally, I create a report using SQL Server Reporting Services (SSRS) in SharePoint Integrated mode.

Thanks to Jamees Wright for organizing the session, and to my fellow panellist, Laura Rogers.


  1. Sandeep G Sandeep G

    Could you give me the link and references for How to Get SharePoint Data Into a Data Warehouse (And Back Again)

    I dont see them in this site

  2. J. Arturo Garcia J. Arturo Garcia

    I’m really interested in your presentation “How to Get SharePoint Data Into a Data Warehouse (And Back Again)” but it looks like the link to the video file is broken, I can’t find it in this site.
    Can you send me a link or an url where this presentation is available?

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.