March 20, 2012 at 1:28 pm
I have SQL server 2008 and a Sharepoint server. I have the need to pull data from the Sharepoint site via my SSIS package.
I downloaded Kevin Idzi's adapter and it works great on my desktop (added as a Addin in BIDS and let my SSIS talk to sharepoint - all run on my desktop). But since it is not an approved tool, i can't get it installed on the server (if it was a MS product, i could have had teh DBA install it on the server for me).
http://sqlsrvintegrationsrv.codeplex.com/releases/view/17652
Are there any adapaters similar to the one developed by Kevin, that is blessed by Microsoft.
Thanks
March 21, 2012 at 12:42 am
The adaptor is on Codeplex, the open source community site supported by Microsoft.
Doesn't that count as a blessing? 🙂
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 21, 2012 at 7:58 am
Big corporations take a year to get MS Patches/SPs out in to production. Installing a Adapter from CodePlex will see very little light. Hence i was looking to see if there was anything from MS that was similar to Kevin's Adapter
March 26, 2012 at 10:45 am
Consider looking at the views in the SharePoint content database. There is a view called UserData that contains the data. The tp_DirName indicates what the data belongs to. So if you are looking for the contents of the list ABC rows with a tp_DirName value of Lists\ABC are rows that belong to that list. The data is in the various generic fields for each field type. Looking at the data from the view versus the data in SharePoint should clarify where the data is.
March 26, 2012 at 10:57 am
I would say your best bet other than using that Adapter is to either:
> As suggested earlier, just grab the data from the DB, I have done that before and the tables aren't very nice, but you can certainly extract data from it easily.
> All SharePoint Lists can be exposed as ATOMSVC feeds, from my understanding you can create a Data Feed Library in SharePoint, add your SharePoint Lists to it as a source, and then you can retrieve the list through a REST protocol as XML results based on the ATOM schema.
The nice thing about approach 2 is that these lists become available for other ATOMSVC source consumers, such as PowerPivot or SSRS.
You consume the list through SSIS as you would with any XML data source, just define the schema and the URL and you are good to go.
More about Data Feed Libraries in SP: http://msdn.microsoft.com/en-us/library/ee210699.aspx
Hope it helps!
-----------------
... Then again, I could be totally wrong! Check the answer.
Check out posting guidelines here for faster more precise answers[/url].
I believe in Codd
... and Thinknook is my Chamber of Understanding
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply