Connecting to Azure DataWarehouse using EntraID

Help Studio
1

Good day. I need to replace my sql authentication users in my bots with a EntraID user. You need to call a http endpoint to get your bearer token using the supplied ClientID and ClientSecret.

After getting the bearer token you need to then obviously establish connection with the token to the Azure environment and using invoke code do the sql call.

The default UiPath.Databases activities do not support the token authentication and therefore I cannot use them to connect and execute the query.
The invoke code activity is also not able to connect to the database inside of our Azure environment and I would prefer to not have to do this in script to make it easier to reuse accross all my automations.

Any ideas how to accomplish connecting using the EntraID to the databse?

My error I am receiving is as follows out of my invoke code where I try to open the connection using (conn.Open()):

image
image497×102 3.2 KB

Please any assistance will be greatly appreciated.

2

Hey @leon.wentzel,

Use Microsoft.Data.SqlClient instead of System.Data.SqlClient, get the EntraID bearer token by calling the OAuth2 endpoint using ClientID, ClientSecret, and TenantID, then in Invoke Code set conn.AccessToken = token before calling conn.Open() to authenticate securely without using SQL authentication.

Let me know if you need any further help