Has anyone connected Matlab to a MS Azure SQL database?

20 次查看（过去 30 天）
Andre
Andre 2016-6-6
回答： Jose Ibanez 2020-3-26
Has anyone connected Matlab to a MS Azure SQL database? I normally connect to a local DB via ODBC connection; how would you do this for Azure SQL?

请先登录，再回答此问题。

采纳的回答

Antti
Antti 2016-11-29
编辑：Antti 2018-11-22
Hi Andre,
I was able to connect to an Azure SQL database by doing the following:
  • 1. Download and install the JDBC drivers that support Azure (> 4.0 I think)
  • 2. In MATLAB, open classpath.txt, and add the path to your JDBC driver (e.g. C:\Program Files\sqljdbc_6.0\enu\sqljdbc4.jar) on the last line of the classpath.txt file. Restart MATLAB.
  • 3. Open the Database Explorer tool in MATLAB (requires Database toolbox):
>> dexplore % R2017a or earlier
>> databaseExplorer % R2017b or later
  • 4. R2017a or earlier: close the dialog that pops up. Click "New", select JDBC source. R2017b or later: click "Configure Data Source"
  • 5. In the dialog, give your data connection a local name, then fill in the details of your SQL server
  • 6. Click 'test' to test the connection, and save
  • 7. In the app, click "New Query" (R2017b or later) or "Connect" (R2017a or earlier)
If you get an error message about data connection, configure your Azure SQL server to accept connections from your computer
Hope this works for you!

更多回答（2 个）

Jose Ibanez
Jose Ibanez 2020-3-26
id = 'MySqlUser' ;
pwd = 'MySQLPassword';
sDriver ='com.microsoft.sqlserver.jdbc.SQLServerDriver';
sqlSDriverPath = 'C:\Apps\sqlserverjdbdc\sqljdbc_4.2\enu\jre8\sqljdbc42.jar';
javaaddpath({sqlSDriverPath});
sqlDBInfo = 'jdbc:sqlserver://myAzureDatabaseFolder.somecharacters.database.windows.net; database=MyDB';
MyConnection = database('', id, pwd, sDriver, sqlDBInfo);
Andre
Andre 2019-2-21
Thank you very much, I will definitely try this.

类别

在 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