Use Matlab Database Explorer to access additional schema.

I'm using the Database Explorer to connect with an SQL ODBC server containing schema "dbo", "learn" and "map" with separate tables that I want to access. The explorer only presents selections for "dbo", "Information_Schema" and "sys"; the "Information_Schema" contains a table "Schemata" with entries "Schema_Name" of "dbo", "learn" and "map", all owned by "dbo". I can't seem to find a way to examine and query the tables in the "learn" or "map" schema using the explorer. The Azure Data Studio shows all three schema and associated tables, and I am able to generate a simple query through Azure, so this doesn't seem to be a permissions issue on the server side. Is this a limitation of the Database Explorer, or is there some additional configuration required for Matlab to access the different schemas?

Answer 1

[Prasanna]

Hi Robert,

It is my understanding that you are not able to access additional schemas through the MATLAB database explorer even with required permissions.

It's not a limitation of the Database Explorer in MATLAB to only access the ‘dbo’ schema. You should be able to query tables from any schema to which you have access. It might be an issue with how the Database Explorer is configured or how it's reading the schema information from the SQL ODBC server.

Here are a few steps you can take to troubleshoot and potentially resolve the issue:

• Refresh the Database Explorer: Sometimes, simply refreshing the connection can help. Look for a refresh option or button in the Database Explorer and use it to update the schema list.
• Check the Connection: Make sure the connection is configured correctly in MATLAB. Double-check the connection settings, including the username and password, to ensure they match what you use in Azure Data Studio.
• Use SQL Query: If the Database Explorer is not showing the schemas, you can still execute SQL queries directly. Use the “database” function to create a connection and then “exec” or “fetch” to run a SQL query. You can find the documentation for the same in the following link: https://in.mathworks.com/help/database/ug/databaseexplorer-app.html
• Review ODBC Configuration: The ODBC data source configuration might have options related to the visibility of schemas. Check the ODBC Data Source Administrator on your system to see if there are any schema-related settings such as DSN Configuration File, Registry Settings, etc that can be adjusted.

Hope this helps,

Regards

Prasanna