This applies to Retool self-hosted...
Following on from this discussion: Is it possible to connect and build CRUD tables for Microsoft Fabric Data Warehouse using Retool?
I'm writing this post to share my own, now successful, experience in connecting to a MS Fabric SQL endpoint using the JDBC connector and including AzureAD (now Entra), authentication.
This example is using AAD/Entra username and password, but using other connection string options, I believe you can also use the same method to connect using Service Principle accounts.
First, you must ensure JDBC is setup and you've mapped your paths properly. I won't go into the whole thing because it's documented on Retool's docco here:
What I would say, is there is a slight tweak where it mentions adding volume mappings:
You don't need the " ' " so it should be:
Once you have setup the volume mappings and the environment variable, you need the right .JAR files and their dependencies...
I used a tool called DBVizualiser which helped me work out which ones I needed, in the end I brought over a whole load.
The core driver .JAR for MSSQL you need is:
And the listed dependencies to get the authentication working is:
Once you have copied them into your
/jdbc folder and reloaded your Retool application containers, you should be able to connect to Azure/Fabric SQL using a JDBC Resource and connection string similar to:
(the servername and domain info will need to match whatever resource you're connecting to, datawarehouse.pbidedicated.windows.net is what Fabric SQL endpoints use).
As I say, if you want to use other AAD/Entra authentication methods, like a Service Principle, you'll have to tweak the connection string accordingly.
This worked for me, I hope it works for you.