In "Talend Data Integration" I want to create a connection using a General JDBC to a SharePoint Website. I have no experience whatsoever with this type of connection.
The connection settings in Talend I have at the moment are:
EDIT: I am using Windows 10 on a 64-bit machine, using Talend Open Studio for Data Integration version 6.4.1
The Microsoft SharePoint uses a webservice API based on AXIS. Have you tried to use tfilefetch component to download file from SharePoint directly?
I have not tried AXIS however my requirements just changed and I no longer need to access the data from sharepoint. I need to pull data from excels stored on One Drive's Cloud based app. Do you have experience with any APIs built for One Drive or could you assist with the appropriate tfilefetch config settings for this type of connection?
So far, there is no a specific component for office 365 OneDrive. Here exists a new feature jira issue:https://jira.talendforge.org/browse/TDI-39061
The tFileFetch component can be used to download file from SharePoint directly.
Please follow the steps in the Component reference:TalendHelpCenter:tFileFetch
The URI looks like:
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Learn how to use an API-First Approach to Modernize your Applications
Pick up some tips and tricks with Context Variables
Take a look at this technical overview video of Talend API Designer