Four Stars

Access Sharepoint Data into Talend Data Fabric 6.3

Hi All,

 

Could any one Please suggest me, How to access Sharepoint data into Talend Data Fabric 6.3 or Do we have any direct option in talend components to access Sharepoint, It would be great if you provide the component names

 

Thanks

Sara

  • Data Integration
3 REPLIES
Moderator

Re: Access Sharepoint Data into Talend Data Fabric 6.3

Hi,

Have you tried to use component tHttpRequest to download a file from a Sharepoint to see if it works?

Best regards

Sabrina

Four Stars

Re: Access Sharepoint Data into Talend Data Fabric 6.3

Hi Sabrina,

 

Tried to use the component tHttpRequest and am getting the error like 

"sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target"

 

Its a very simple job created to test

 

tHttpRequest ---> tLogRow

 

My Requirement:-

 

Import Share point Data into Excel or any other format thru Talend (Am using Talend Data Fabric 6.3)

Note :  In sharepoint the data would be like web page entry and its not in a File Format like .csv or .xls

 

Please let me know if you need any more details

 

Thanks & Regards

Sara

 

 

 

Four Stars

Re: Access Sharepoint Data into Talend Data Fabric 6.3

Hi All,

 

Do we have a option to export data from Microsoft 365 Sharepoint to Talend?

For the above requirement do we must to use Talend Open Studio for ESB or We can use Talend Open Studio Data Fabric (My Current Version is 6.3.1)

Got some details from online to Export data from Microsoft 365 thru JDBC Connection using Talend Open Studio for ESB (Enterprise Service Bus) - Please guide me

"https://www.cdata.com/kb/tech/office365-jdbc-talend.rst"   

 

Could you Suggest me

 

Thanks & Regards

Sara