Relational Databases
Explore data in databases such asMicrosoft®Access™,Microsoft SQL Server®, and Oracle®by configuring drivers and using SQL
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, seeAccess Relational Database Data in MATLAB.
ODBC or JDBC Drivers
- Configure Environment
驱动程序和数据源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
本地接口
- 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