Support Azure AD authentication

17 次查看（过去 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 Center 和 File Exchange 中查找有关 Database Toolbox 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by