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 Reading and Loading SharePoint Data using SSIS
Tag: Data Warehouse
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 Microsoft SQL Server 2012 Fast Track White Paper is now available
Important SAP tables
if you are struggling with pulling data from SAP, this list of essential SAP tables could be helpful DD02L SAP Tables DD03L Table Fields DD04L Data elements TADIR Directory of Repository Objects VARID Variant for Reports TFDIR Function Modules T100 Messages TSE05 ABAP Editor insert commands USR03 User address data USR02 Logon data USR01 User … Continue reading Important SAP tables