Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

SharePoint Integration

Hi Folks,
Firstly I Love your project and have been using Talend for some time now..
Anyway, I have become very active in a very exciting MS product maned SharePoint (it is now officially MS's fastest growing product). The product is a "monster" of an application. There are many aspects where I believe Talend's architecture would fit very well.
Has anyone brought this up before? Although I am fairly new with SharePoint, I would be willing to work with someone here to help. If there is interest please let me know.
Thank You,
Gus
Labels (3)
13 Replies
Anonymous
Not applicable
Author

Sharepoint (in it's latest form) has become a nice product.
What were you thinking of in terms of Sharepoint and TOS?
Anonymous
Not applicable
Author

I would like to see the ability to use a sharepoint list as data source
MC
Anonymous
Not applicable
Author

Me, I need to synch MS SQL 7 data with Sharepoint Lists. Great challenge, eh?!
Anonymous
Not applicable
Author

The good news is that Sharepoint lists are a web service so no need of c#$% and similar stuff I bet.
_AnonymousUser
Specialist III
Specialist III

Can someone give me a bullet point algorithm to connect from Talend to Sharepoint and download files to local directory?
Thanks,
Anonymous
Not applicable
Author

Hi
This topic is so old, but I can't help you, Sowjanya, because I am not family with Sharepoint, hope Li_SpeedyG will come back to us and share his new idea.
Best regards
Shong
_AnonymousUser
Specialist III
Specialist III

So has anyone successfully used tWebServiceInput to grab SharePoint list data?
Anonymous
Not applicable
Author

tFileFetch can be used to download file from SharePoint directly. Just follow the steps in the Component Guide, you can do this fairly quick.
I went one step further: apply tSoap to call SOAPaction GetListItems of webservice lists.asmx, and then port the response to a XML file. By parsing the XML using tFileInputXML, I get the list of URLs of all files in a SharePoint Doc lib folder. The final step is to iterate the list and supply the URL to tFileFetch so that all files can be downloaded. Set up a batch job to grab many folders and saved tons of clicks !
Anonymous
Not applicable
Author

tFileFetch can be used to download file from SharePoint directly. Just follow the steps in the Component Guide, you can do this fairly quick.
I went one step further: apply tSoap to call SOAPaction GetListItems of webservice lists.asmx, and then port the response to a XML file. By parsing the XML using tFileInputXML, I get the list of URLs of all files in a SharePoint Doc lib folder. The final step is to iterate the list and supply the URL to tFileFetch so that all files can be downloaded. Set up a batch job to grab many folders and saved tons of clicks !

Hi randyqin
Thanks very much for your knowledge and solutions! They are very helpful for users who want to integrate Talend with SharePoint.
Best regards
Shong