Database Toolbox™ enables you to create a connection to a database installed on a machine or located in the cloud. To connect to an installed database, first install the driver. For all databases, define a data source for an ODBC or JDBC driver. If you do not have an installed database and want to store relational data quickly, you can use the MATLAB® interface to SQLite. For details, see Working with MATLAB Interface to SQLite.
ODBC uses a Data Source Name (DSN) that is the logical name to refer to the drive and other required information for accessing data. This name is used to connect to an ODBC data source, such as a Microsoft® SQL Server® database.
Find your database environment in the following table by choosing your platform across the top and your database on the left. The link brings you to a page that has all the required steps for connecting to your database.
|
Database |
Platform | ||
|---|---|---|---|
|
Windows® |
macOS 64-bit |
Linux® 64-bit | |
|
Microsoft Access™ | |||
|
Microsoft SQL Server | |||
|
Oracle® | |||
|
MySQL® | |||
|
PostgreSQL | |||
|
SQLite | |||
Microsoft Access is not supported for Mac 64-bit and Linux 64-bit platforms.
For ODBC-compliant or JDBC-compliant databases that are not listed in the table, see Other ODBC-Compliant or JDBC-Compliant Databases.