Has anyone connected Matlab to a MS Azure SQL database?

24 views (last 30 days)
Andre
Andre on 6 Jun 2016
Answered: Jose Ibanez on 26 Mar 2020
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?

Accepted Answer

Antti
Antti on 29 Nov 2016
Edited: Antti on 22 Nov 2018
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!

More Answers (2)

Jose Ibanez
Jose Ibanez on 26 Mar 2020
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 on 21 Feb 2019
Thank you very much, I will definitely try this.

Community Treasure Hunt

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

Start Hunting!