Support Azure AD authentication

조회 수: 11 (최근 30일)
Oliver Lintner
Oliver Lintner 2018년 12월 17일
편집: Oliver Lintner 2018년 12월 18일
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:
  1. 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)
  2. 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).
  3. 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.
  4. I created a JDBC connection (using server auth) works again.
Many thanks for the help

답변 (0개)

카테고리

Help CenterFile Exchange에서 Database Toolbox에 대해 자세히 알아보기

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by