Support Azure AD authentication
9 views (last 30 days)
Show older comments
Hi, I tried to connect to a SQL server endpoint using Azure AD (AAD) authentication using ODBC and JDBC. Is AAD authentication properly supported in Matlab (when connecting to JDBC/ODBC connections)?
I see some weird behavior and and wanted to verify. Here are the scenarios i tested:
- Created an ODBC connection (using the latest SQL ODBC driver v17) with an AAD user (where multi-factor authentication is enabled). Doesn't work in Matlab - receive an error (I'm pretty sure this is because of the MFA)
- Created an ODBC connection (using the latest SQL ODBC driver v17) with an AAD user (where multi-factor authenticaiton is disabled). Connecting to the data source in Matlab worked but it seems that Matlab uses cursors (which is bad from a performance perspective).
- I created a JDBC connection (latest JBDC SQL driver and AAD auth module) with an AAD user (multi-factor authentication is disabled). Doesn't work in Matlab. I assume that the "Windows" JDBC connection option in Matlab does only work with classic Windows credentials (and not with AAD credentials). Is this correct? The auth module definitively supports AAD auth as well.
- I created a JDBC connection (using server auth) works again.
Many thanks for the help
0 Comments
Answers (0)
See Also
Categories
Find more on Database Toolbox in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!