Yesterday Microsoft announced the next step in the evolution of Power BI. It’s getting quite a bit of attention, and rightly so for its aim of bringing Business Intelligence closer… Continue reading The New Power BI – Now With Enterprise!
Tag: SSIS
Using the SSIS OData Source Connector With SharePoint Online Authentication
Last week, Microsoft released the OData Source for Microsoft SQL Server 2012 . What is it? It allows SQL Server Integration Services (SSIS) to use an OData feed as a… Continue reading Using the SSIS OData Source Connector With SharePoint Online Authentication
How To Automate SharePoint Report Creation With SSIS and SSRS
If you’ve used SQL Server Reporting Services to any great extent, you’ve likely encountered the need to generate reports automatically. This requirement may be for for delivery purposes, archival purposes,… Continue reading How To Automate SharePoint Report Creation With SSIS and SSRS
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… Continue reading How to Get SharePoint Data Into a Data Warehouse (And Back Again)
Archiving Your SharePoint Workflow History Lists
If you’ve worked at all with SharePoint declarative workflows (the ones that you use InfoPath to create), or others, such as Nintex workflows that are based on them, you are… Continue reading Archiving Your SharePoint Workflow History Lists