Relational Databases

Explore data in databases such as Microsoft Access^®, Microsoft^® SQL Server^®, and Oracle^®

Database Toolbox™ enables you to connect MATLAB^® to ODBC-compliant and JDBC-compliant relational databases using ODBC and JDBC drivers, respectively, or native interfaces. The Database Explorer app provides a visual way to establish a connection to a relational database, explore data, and import data into MATLAB. Alternatively, you can use the command line to perform these tasks.

For high-level information about using Database Toolbox, see Access Relational Database Data in MATLAB.

ODBC or JDBC Drivers

Configure Environment
Driver and data source configuration
Connect to Database and Import Data Interactively
Connect to and import data from relational database into MATLAB workspace using Database Explorer app
Connect to Database Programmatically
Establish connection to relational databases and retrieve information about their structures using command line
Import Data Programmatically
Import data from relational database into MATLAB workspace using command line
Import Large Data Programmatically
Import large data from relational database into MATLAB workspace using command line
Export Data Programmatically
Export data from MATLAB workspace into relational database using command line
Database Operations
Run stored procedure or custom function, alter structure of database, manage database transactions, and switch between catalogs
SQL Prepared Statements
Create and execute SQL prepared statements

Native Interfaces

MATLAB Interface to SQLite
Interact with an SQLite database using the MATLAB interface to SQLite
MySQL Native Interface
Interact with a MySQL^® database using the MySQL native interface
PostgreSQL Native Interface
Interact with a PostgreSQL database using the PostgreSQL native interface
Object Relational Mapping
Read, write, and update details of objects on relational databases by using object relational mapping