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
