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