Tag: Data Warehouse

Reading and Loading SharePoint Data using SSIS

Lists are one of the cornerstones of SharePoint and many companies have a wealth of information stored and managed using this SharePoint feature.  I sometimes get questions whether it is possible to extract that data (or load that data) into a data warehouse or a cube elsewhere.  The answer is yes, using the SharePoint SSIS Adapters. 

Continue reading

Microsoft SQL Server 2012 Fast Track White Paper is now available

Microsoft has updated its excellent Fast Track ( Microsoft Data Warehouse reference architecture) white paper for latest versoin of SQL Server (2012).  Whether you decide to follow this architecture or not (and there are good reasons for and against it given your budget and objectives), you will find a wealth of great and useful information that will help you

Continue reading