Configure a data source depending on the database environment. Decide between using an ODBC and JDBC driver. Then, find the configuration instructions based on your operating system and database. You can configure data sources using the appropriate dialog box in the Database Explorer app. Configure an ODBC data source using the ODBC Data Source Administrator dialog box. Configure a JDBC data source using the JDBC Data Source Configuration dialog box or the command line.
For high-level information about using Database Toolbox™, see Access Relational Database Data in MATLAB. To get started by exploring data visually, use the Database Explorer app.
| Database Explorer | Configure, explore, and import database data |
SQLConnectionOptions | Define JDBC database connection options |
Choosing Between ODBC and JDBC Drivers
Discover the differences between ODBC and JDBC drivers, and choose the correct driver for your situation.
Configuring Driver and Data Source
Install drivers and configure data sources for your database environment.
Create JDBC Data Source and Set Options Programmatically
Create and configure a JDBC data source and set JDBC driver-specific options.
Modify and Delete Data Sources
Learn about managing data sources for ODBC and JDBC drivers.
Microsoft Access ODBC for Windows
Configure an ODBC driver and data source for the Microsoft® Access™ database for Windows®.
Microsoft SQL Server ODBC for Windows
Configure an ODBC driver and data source for the Microsoft SQL Server® database for Windows.
Configure an ODBC driver and data source for the Oracle® database for Windows.
Configure an ODBC driver and data source for the MySQL® database for Windows.
Configure an ODBC driver and data source for the PostgreSQL database for Windows.
Microsoft SQL Server JDBC for Windows
Configure a JDBC data source for the Microsoft SQL Server database for Windows.
Configure a JDBC data source for the Oracle database for Windows.
Configure a JDBC data source for the MySQL database for Windows.
Configure a JDBC data source for the PostgreSQL database for Windows.
Configure a JDBC data source for the SQLite database for Windows.
Microsoft SQL Server JDBC for macOS
Configure a JDBC data source for the Microsoft SQL Server database for Mac.
Configure a JDBC data source for the Oracle database for Mac.
Configure a JDBC data source for the MySQL database for Mac.
Configure a JDBC data source for the PostgreSQL database for Mac.
Configure a JDBC data source for the SQLite database for Mac.
Microsoft SQL Server JDBC for Linux
Configure a JDBC data source for the Microsoft SQL Server database for Linux®.
Configure a JDBC data source for the Oracle database for Linux.
Configure a JDBC data source for the MySQL database for Linux.
Configure a JDBC data source for the PostgreSQL database for Linux.
Configure a JDBC data source for the SQLite database for Linux.
Other ODBC-Compliant or JDBC-Compliant Databases
Configure a driver and data source for other ODBC-compliant or JDBC-compliant databases.