I have an Access database that my team uses that we save to SharePoint online. We have reporting that we pull out of this SharePoint site but due to the size of the data we extract this process takes time. I was hoping to connect KNIME to this access database to use KNIME to create my reports but was having an issue connecting to it since it is saved in SharePoint online and not on my local hard drive.
Has anyone ever connected to an Access database that is saved in SharePoint online and if so could you please share an example of how I can accomplish this.
Welcome to the KNIME Forum.
Can you maybe show us, what you’ve done so far to get a better understanding?
My approach would be like:
MS-Authenticator (Configure it as needed)
SP Online Connector (Configure it as needed)
List Files/Folders: Add Filesystem-port and connect with SP-Online. Filter for the mdb-file (result must be exactly 1 row)
Table Row to Variable: Transform the PATH-result from the former node to a variable
MS Access Connector: Use the variable generated with the node before in the “Location” field (the “V”-button right from it) and configure the rest according to your MS Access DB
If you use the MS Auth in interactive mode, you cannot automate this process. You have to open the node each time for configuration and login to MS within the node (opens a new browser-tab).
