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.
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
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?