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.
|Relational database ODBC connection|
|Relational database JDBC connection|
Information About Database Structure
|List all available data sources|
|Find information about all table types in database|
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 the
connectionobject and the
- Data Retrieval Restrictions
Identify restrictions on table and column names for data retrieval.