MATLAB: Is the ODBC driver slower than the JDBC driver when used with the Database Toolbox

Database Toolbox

When I use my ODBC database from the Database Toolbox, it seems slow compared to when I use a JDBC driver with the same database.

Best Answer

This change has been incorporated into the documentation in Release 14 Service Pack 3 (R14SP3). For previous releases, read below for any additional information:

When you use a ODBC driver, all of your data has to be moved from MATLAB, to Java, to C/C++, and the other way around. If you use a JDBC driver, your data is only moved between Java and MATLAB, and the other way around. Therefore, you will likely experience better results by using a JDBC driver if one is available.

Related Solutions

MATLAB: Do I get an error when I try to access a remote database using the Microsoft SQL 2000 JDBC driver

This documentation bug has been fixed for Release 14 (R14). For previous releases, please read below for any possible workarounds:

To connect to the remote database using the Microsoft SQL 2000 JDBC Driver please use the following command:

conn = database
('iri','andy','andy','com.microsoft.jdbc.sqlserve
r.SQLServerDriver','jdbc:microsoft:sqlserver://an
dre1:1433;database=iri')

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

Best Answer

Related Solutions

MATLAB: Do I get an error when I try to access a remote database using the Microsoft SQL 2000 JDBC driver

MATLAB: Access Apache Hive using ODBC driver

Related Question