How to extract a SharePoint List
alfonsJul 1 2010 — edited May 18 2011Hi,
Our ourganization is just starting to build the DataWareHouse. I would prefer to use Oracle as a DatawareHouse platform but I am facing the following issue: curently a large number of our DWH data sources are based on SharePoint Lists. I know that it would be possible to extract them using Microsoft technology (Integration Services + SQL Server) but I I would prefer to use Oracle tools (such as ODI for instance). Anyone has experience retrieving data from SharePoint list? Which would be the best approach to load them in a Oracle RDBMS system?
Thanks