Follow

How to get data from an Office 365 Sharepoint List into your Data Warehouse (video)

Author: Thomas Lørup Duun Last updated:
tx2014 ssis sr2 sharepoint office365 office_365

In this 10 minute video you can see how you can connect to your Office 365 Sharepoint and retrieve data from a list into your TX solution.

How to get data from an Office 365 Sharepoint List into your Data Warehouse

Was this article helpful?
0 out of 0 found this helpful

7 Comments

Date Votes
  • 0
    Avatar
    Jason Page

    Hi, this video seems to address exactly what i need to do. however, i don't seem to see the "data tools" option in the choose editor for the SSIS customized code - do i need any pre-requisites for this to work?

  • 0
    Avatar
    Thomas Lørup Duun

    Hi Jason,

    You can setup Data Tools as a Custom Editor in General Settings. 

  • 0
    Avatar
    Jason Page

    awesome! that worked perfectly!! now to just get the list to show up.. any idea why i might be getting this error - i get this when i try to browse the listdata.svc/ListName.

    This XML file does not appear to have any style information associated with it. The document tree is shown below.
    <code/>
    <message xml:lang="en-ZA">An error occurred while processing this request.</message>
    </error>
     
    It's only 1 of the particular lists (the one i want) - all the others work fine? are there any components of a list that might prevent it from working properly?
  • 0
    Avatar
    Thomas Lørup Duun

    Hi Jason,

    That is a good question that I unfortunately are unable to give you an exact answer to. 

    It could be that a duplicate fieldname exists due to some white-space removals - see here: https://nearbaseline.com/2014/09/odata-error-processing-this-request/

    This one could also be relevant: http://sharepoint.stackexchange.com/questions/174088/listdata-svc-returns-an-error-occurred-while-processing-this-request-for-some

    Happy hunting - and please update this thread with your findings! Thanks!

    Edited by Thomas Lørup Duun
  • 0
    Avatar
    Jason Page

    thanks for help, it's been great!

  • 0
    Avatar
    David Zebrowitz

    All, the video for the article "How to get data from an Office 365 Sharepoint List into your Data Warehouse", Is not available on Youtube.

    Are there any other documents for connecting to an Office 365 Sharepoint List?

     

  • 0
    Avatar
    Joseph Treadwell

    Hi David, this method is only for much older versions of TimeXtender. Please use the CData ADO.NET Provider for SharePoint. You can find the documentation on getting connected here: CData ADO.NET Provider for SharePoint - Establishing a Connection

Please sign in to leave a comment.