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.
Tag: Data Warehouse
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
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