Import Data Programmatically

Import data from relational database into MATLAB^® workspace using command line

Database Toolbox™ enables you to import data into MATLAB using the command line. You can import data from database tables, or write and execute SQL queries and import the results.

Objects

`connection`	Relational database JDBC connection
`SQLImportOptions`	Define import options for database data

Functions

expand all

Query Data

`sqlread`	Import data into MATLAB from database table
`select`	Execute SQL `SELECT` statement and import data into MATLAB
`fetch`	Import data into MATLAB workspace from execution of SQL statement
`fetchmulti`	Import data from SQL queries (Since R2024b)
`executeSQLScript`	Execute SQL script on database
`runstoredprocedure`	Call stored procedure with and without input and output arguments
`sqlinnerjoin`	Inner join between two database tables
`sqlouterjoin`	Outer join between two database tables

Customize Options for Data Import from Database

`databaseImportOptions`	Define import options for database data
`getoptions`	Retrieve import options for database data
`preview`	Preview eight rows from database using import options
`setoptions`	Customize import options for database data
`reset`	Reset to default import options for database data

Topics

SQL Query Basics

Data Import Using Database Explorer App or Command Line

Learn the best way to import data from your database into MATLAB.
- Data Type Support
- Data Retrieval Restrictions

Import Data Using Database Tables or SQL Queries

Data Import Memory Management
Save memory when importing data by using functions and the SQLImportOptions object.
Import Data from Database Table Using sqlread Function

Import data from one table or from the result of multiple joins in an SQL query.
Interact with Data in SQLite Database Using MATLAB Interface to SQLite

Analyze data without access to a database or driver by using the MATLAB interface to SQLite.
- Import Data Using MATLAB Interface to SQLite