MATLAB: Is it possible to set up Windows Authentication for ODBC data sources

accessauthenticationbasedatadatabaseDatabase Toolboxmicrosoftodbcpasswordusernamewindows

I would like to set up Windows Authentication for my data source such that I do not have to provide username and password each time I connect to the database.

Best Answer

The ODBC connection should be created with the following property enabled:

 'Windows NT authentication using the network login ID'

MATLAB should now be able to connect to the datasource without specifying the username and password. However, empty strings will still need to be passed in as arguments corresponding to these fields:

conn=database('myDataSource',' ',' ');

Related Solutions

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.

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: How to specify the Database URL String in the DATABASE function of Database Toolbox 3.4(R2007b) to connect to a POSTGRESQL database

MATLAB: Access Apache Hive using ODBC driver

Related Question