Connect to Database Programmatically
Establish connection to relational databases and retrieve
information about their structures using command line
Database Toolbox™ enables you to connect to various relational databases by installing the database and driver. If you do not want to install a database and driver, you can use the MATLAB Interface to SQLite.
After establishing a database connection, you can explore database contents and structure using the command line. Close the database connection when you are finished.
Objects
connection | Relational database ODBC connection |
connection | Relational database JDBC connection |
Functions
Topics
Connect to Database
- Connect to Database
After configuring a driver and data source, connect to your database. - 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.
Retrieve Information About Database Structure
- Retrieve Database Metadata
Find information about the database, tables, and columns using theconnection
object and thesqlfind
function. - Data Retrieval Restrictions
Identify restrictions on table and column names for data retrieval.