User`s guide

2 Getting Started with Database Toolbox
2-188
Other ODBC- or JDBC-Compliant Databases
This tutorial provides high-level workflows for using other ODBC- or JDBC-compliant
databases.
In this section...
“ODBC-Compliant Databases” on page 2-188
“JDBC-Compliant Databases” on page 2-188
ODBC-Compliant Databases
This tutorial shows how to configure your driver and connect to your ODBC-compliant
database with MATLAB. Database Toolbox can connect to any ODBC-compliant
database that is relational and that uses ANSI SQL. For example, if your database is
Microsoft Excel or IBM DB2, here are some basic steps to follow.
1
If your driver is not preinstalled on your computer, find a compatible driver and
install it on your computer. You can view preinstalled drivers using the Microsoft
Data Source ODBC Administrator.
2
Create a data source that uses the installed driver using the Microsoft Data
Source ODBC Administrator. For details about the Microsoft Data Source ODBC
Administrator, see Driver Installation.
3
Use Database Explorer to test your connection. For details, see “Configure ODBC
Data Sources” on page 4-8.
4
Use Database Explorer to connect to your database. For details, see “Connect to a
Data Source” on page 4-16.
5
Alternatively, you can connect to your database using the command line function
database.
6
For more in-depth assistance, contact your database administrator or database
documentation. For more in-depth instructions, see the example “MySQL ODBC for
Windows” on page 2-57.
JDBC-Compliant Databases
This tutorial shows how to configure your driver and connect to your JDBC-compliant
database with MATLAB. Database Toolbox can connect to any JDBC-compliant database
that is relational and that uses ANSI SQL. For example, if your database is Apache™