MATLAB: Has anyone connected Matlab to a MS Azure SQL database

azure sql read and write

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?

Best Answer

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!

Related Solutions

MATLAB: How to connect Microsoft SQL Server 2000 with Matlab R2011b

Download Microsoft SQL Server JDBC Driver 2.0. And configure it as following(demo information): Configure MATLAB to Use JDBC Drivers for Authenticated Database Connection

To connect to a SQL server database with integrated Windows authentication using a JDBC driver, do the following:

   1.
      Close MATLAB if it is running.
   2.
      Insert the path to the database driver JAR file in the classpath.txt file. The classpath.txt file is located at:
      $MATLABROOT\toolbox\local\classpath.txt
      The updated path entry should now include the full path to the driver. For example:
      C:\DB_Drivers\sqljdbc_2.0\enu\sqljdbc4.jar
   3.
      Insert the path to the folder containing sqljdbc_auth.dll in the librarypath.txt file. The librarypath.txt file is located at:
      $MATLABROOT\toolbox\local\librarypath.txt
      The path entry should not include the file name sqljdbc_auth.dll:
      C:\DB_Drivers\sqljdbc_2.0\enu\auth\x64
      The sqljdbc_auth.dll file is installed in the following location:
      <installation>\sqljdbc_<version>\<language>\auth\<arch>
      where <installation> is the installation directory of the SQL server driver.
      If you are running a 32-bit Java Virtual Machine (JVM), use the sqljdbc_auth.dll file in the x86 folder, even if the operating system is the x64 version. If you are running a 64-bit JVM on a x64 processor, use the sqljdbc_auth.dll file in the x64 folder. If you are running a 64-bit JVM on a IA-64 processor, use the sqljdbc_auth.dll file in the IA64 folder.
   4.
      Start MATLAB.
   5.
      Append the string integratedSecurity=true; to the database URL:
      conn = database('dbName','','', ...
         'com.microsoft.sqlserver.jdbc.SQLServerDriver', ...
         ['jdbc:sqlserver://servername:portnumber; '...
          'database=dbName;'] 'integratedSecurity=true;')

MATLAB: Do I get a “JDBC Driver Error: CLIENT_PLUGIN_AUTH is required” error when connecting to a remote MySQL database

This appears to be a server-side authentication issue with the MySQL database.

1) Please ensure the driver version for the JDBC connection is compatible with the version of the MySQL database you are trying to connect to.

2) Please specify the parameter "useSSL=false" in the URL of JDBC connection:

>> driverpath = 'C:\xxxxxx\mysql-connector-java-X.X.XX.jar';
>> opts = configureJDBCDataSource('Vendor','Other');
>> opts = setConnectionOptions(opts,'DataSourceName','SQLServerDataSource',...
'URL','jdbc:mysql://<hostname or ip address>/<database-name>?useSSL=false&',...
'Driver','com.mysql.cj.jdbc.Driver',...
'JDBCDriverLocation',driverpath);
username = 'exampleUsername';
password = 'examplePassword';
[status, error] = testConnection(opts,username,password)

3) If these steps fail, please contact your database administrator to troubleshoot authentication and connectivity issues.

Best Answer

Related Solutions

MATLAB: How to connect Microsoft SQL Server 2000 with Matlab R2011b

MATLAB: Do I get a “JDBC Driver Error: CLIENT_PLUGIN_AUTH is required” error when connecting to a remote MySQL database

Related Question