+6I am looking at this Article for setting up Azure OAuth Connection for Data Bricks, the article is for Reader, but I assume the same set up will work for the Writer. We have an Azure app already set up for the FME SharePoint Reader and Connector, can the same Azure app work for both SharePoint and Data Bricks ? are there any best practices about using the same Azure app for both or making separate Azure Apps for each ? Any suggestions or cautions, things to watch out for, etc, appreciated
+21
Hi
Yes, you can technically use the same Azure App Registration for both SharePoint and Databricks in FME, though there are a few things to consider.
If you do reuse the existing app, you'll need to update it to support Databricks. The article you linked walks through those Azure-side setup steps in detail, so that's a good starting point.
Regarding best practices, while it works, keeping separate App Registrations is often recommended. The main reason is that Databricks and SharePoint connections may require different types of access, and combining them in a single app can create a broader security footprint than most IT teams are comfortable with. On top of that, if you're using the same app across Form and Flow, a rotated client secret will break all of your automated Flow pipelines at once. Separate apps keep things more contained.
That said, if your SharePoint connection runs on behalf of a signed-in user (with delegated permissions) rather than as a background service, the concern is smaller, since Databricks also uses user_impersonation API permissions, which is a delegated permission.
It's worth a quick check with your IT Security team before committing to either path.
Our Getting Started with SharePoint article and documentation are also good references for more context on connection types, delegated/application permissions, and their setup.
Hope this helps you and the community 🙂
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
