Microsoft access db - Remote location configuration - KNIME Business hub

KNIME Business Hub
1

Hi Team

We have workflow configured to access the local microsoft access database file. Can you suggest how we configure the path to run the same workflow in knime business hub.

In the Browse option - path points to local location, does not have option to choose relative.

2

Adding screenshot

image
image986×567 78 KB

3

Hello @narayanan ,

For security reasons, in KNIME Business Hub we cannot allow access to local file system.

However, there are different alternatives to achieve the same functionalities:

  • If you want to keep the files locally (on Windows) you can use SMB Connector to access them.
  • Depending on the files, if it makes sense you can also store them inside KNIME Business Hub.
  • Last but not least, you can put these files in the Cloud (e.g. SharePoint) and access them from your workflows.

It may also be useful to look at this thread, where options 2 and 3 are explained in more detail.

I hope it helps!

1 Like
4

Thank you Dora_gcs for checking and reply.
I got it but how we can access the microsoft access database file if we place into sharepoint folder?, as i dont see option on the Microsoft access connector node to connect with Mircosoft authentication node.