?
Solved

ETL from Sharepoint db to data warehouse

Posted on 2011-03-21
3
Medium Priority
?
626 Views
Last Modified: 2012-05-11
Hi,

How can I extract data from sharepoint databases and load it into SQL server's data warehouse from where this data can be reported against ?

I don't have experience with Sharepoint databases but my understanding is that the files are stored in Sharepoint db as BLOBs. And it's not even easy to find out which list/table data is stored. Not sure whether data is stored using relational db model or unstructured. I'm trying to see how others overcome the data extraction difficulty (if any) from sharepoint db to reporting environment.

Please advise!
0
Comment
Question by:Rainbow002
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 14

Accepted Solution

by:
GeorgeGergues earned 2000 total points
ID: 35183758
it is not recommended to directly access the SQL DB to get to the data
yet you can use the web services interface to do your data access.


http://www.codeproject.com/KB/reporting-services/ReportFromSharePoint.aspx

here is a nice article
and if you have a budget , you can use this product.
http://www.enesyssoftware.com/


Best of luck
0
 

Author Comment

by:Rainbow002
ID: 35190012
This product seems to be promising. Any experience with it?
0
 
LVL 14

Expert Comment

by:GeorgeGergues
ID: 35190073
one deployment against DB2 for some .NET reporting.

yes it works but as you can tell is a bit expensive

I have done it both ways and the product is a bit easier for some developers

You can download the eval copy for a month .

Best of luck.
0

Featured Post

10 Questions to Ask when Buying Backup Software

Choosing the right backup solution for your organization can be a daunting task. To make the selection process easier, ask solution providers these 10 key questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In case you ever have to remove a faulty web part from a page , add the following to the end of the page url ?contents=1
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question