Hi everyone!
I designed a KNIME workflow for a team, which is being used through a Data App by sharing its link. The workflow is relatively simple: it extracts files from SharePoint and then performs transformations on the data.
To access SharePoint and the files, I am currently using the Microsoft Authenticator (deprecated) node with my personal credentials. However, these credentials expire periodically, causing the Data App to stop working unless I manually re-execute the authentication node. Additionally, if my credentials become unavailable for any reason, the workflow would completely stop working for the team.
Since this workflow is used by multiple users, I would like to know if there is a way to allow users to securely input their own credentials interactively within the Data App, similar to how authentication works in a local KNIME execution.
There are also some constraints to consider:
-
Since I’m part of a developing team, I am the only one with access to a Business Hub account. Other users only interact with the workflow via the Data App link.
-
Due to development restrictions, I am the only one in the developing team with direct access to the SharePoint where the files are stored. The operational team (end users) manages access to those files on their side.
Given this setup:
-
Is there a secure way to allow dynamic user authentication in a KNIME Data App?
-
What would be the recommended best practice for handling authentication in this scenario?
Any guidance or recommended architecture would be greatly appreciated.