Access Sharepoint Data into Talend Data Fabric 6.3

[Anonymous]

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

[Anonymous]

Hi,

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

Best regards

Sabrina

[Anonymous]

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

[Anonymous]

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

[Anonymous]

Hello,

The problem appears when your server has self signed certificate. To workaround it you can add this certificate.

Are you able to successfully import the certificate by using tSetkeystore component?

tHttpRequest and tSetKeyStore components are available in talend open source.

Best regards

Sabrina

[Anonymous]

Hi Sabrina,
Can we delete the file from sharepoint.

Regards,

[Anonymous]

Hello,

So far, there is no connectors for sharepoint in talend.

Could you please try to use third party providers like CDATA or Progress to see if it is OK with you?

Best regards

Sabrina