Relational Databases
Explore data in databases such asMicrosoft®Access™,Microsoft SQL Server®, and Oracle®by configuring ODBC and JDBC drivers and using SQL
Database Toolbox™ enables you to connect MATLAB®to ODBC-compliant and JDBC-compliant relational databases. The Database Explorer app provides a visual way to establish a connection to a relational database, explore data, and import data into MATLAB. Or, you can use the command line to perform these tasks.
For high-level information about using Database Toolbox, seeAccess Relational Database Data in MATLAB.
Relational Database Interaction Basics
- 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