MATLAB: How to know if the database is supported by the Database Toolbox

accessanywherecompatibilityDatabase Toolboxdb2ibminformixjdbcmicrosoftMySQLodbcoraclepostgresqlsybaseudb

I would like to find the list of databases supported by the Database Toolbox.

Best Answer

The Database Toolbox in MATLAB 6.5 (R13) and later versions supports all ODBC/JDBC-compliant database management systems. For information about some restrictions, see the documentation at the following location.

https://www.mathworks.com/help/database/index.html

Related Solutions

MATLAB: Access Apache Hive using ODBC driver

I've tested Hive access via JDBC Driver, but not ODBC Driver yet, but I think possibly, yes.

First, 64 bit ODBC Driver is requied.

Next, configure ODBC data source in Database Toolbox. And I think you can access to Hive

datasource = 'Hive'; % The name of datasource specified in configureODBCDataSource
username = 'XXX';
password = 'YYY';
conn = database(datasource, username, password);
selectquery = 'SELECT TOP 10 * FROM TABLENAME';
data = select(conn,selectquery);

Ref: https://www.mathworks.com/help/database/ug/database.html#btcofz6

MATLAB: How to specify the Database URL String in the DATABASE function of Database Toolbox 3.4(R2007b) to connect to a POSTGRESQL database

For a PostGreSQL database the driver and the URL specifications are as follows:

JDBC driver: org.postgresql.DriverDatabase
URL: jdbc:postgresql://masd/DatabaseName

Please note that the Database URL string needs to have the Database name "DatabaseName" appended at the end of it.

Best Answer

Related Solutions

MATLAB: Access Apache Hive using ODBC driver

MATLAB: How to specify the Database URL String in the DATABASE function of Database Toolbox 3.4(R2007b) to connect to a POSTGRESQL database

Related Question