MESFedEx10222024 Posted Tuesday at 01:34 PM Share Posted Tuesday at 01:34 PM How do I connect to Synapse using Service Principal via Spotfire? Tibco Support recommended that I post the question here to see if there is custom connector that I can use to achieve this. I am trying to use Spotfire Analyst to connect to Synapse using Service Principal. This is a requirement for us since we use the Service Principal to connect and update the tables in Synapse using ADF. Is there any work-around that you can provide? I appreciate your help. Link to comment Share on other sites More sharing options...
David Boot-Olazabal Posted Tuesday at 01:58 PM Share Posted Tuesday at 01:58 PM Hi, We do have a custom connector for Azure, which also covers Synapse. You can find it here: When you have added the custom connector package (it's a .sdn file) in the Deployments & Packages section of the Admin console, the connector should be installed into your Analyst client when restarting it. If you add data and search for Azure, you will see all out of the box Azure connectors (including one for Synapse (in the red box) that works also with OAuth2) as well as the Azure SQL (Custom) connector (in the back box): When you select the Azure SQL (Custom) connector, you are required to connect to Microsoft with a Personal Access token: I'm not sure if that would be compatible with a service principal, but you can try it out. Kind regards, David Link to comment Share on other sites More sharing options...
MESFedEx10222024 Posted Thursday at 05:46 PM Author Share Posted Thursday at 05:46 PM Thank you for this reply David. I will give this a try and will let you know if this works with Service Principal. Best Regards, Mary Anne 1 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now