User`s guide

Connection Options
2-7
Connection Option Why Use This Option?
Database Explorer Use Database Explorer to:
• Visually inspect the structure, or schema, of your
database.
• View the tables and columns and rows in a table to
assess the general size of your database.
• Select the data in a table and import it into a
MATLAB variable.
• Generate a MATLAB script.
• Generate an SQL query.
For details, see “Selecting Data” on page 2-195.
Command line Use the command line to:
• Import data from a database into MATLAB.
• Export data from MATLAB into a database.
• Work with large amounts of data.
• Run SQL queries stored in text files.
• Run stored procedures and functions.
There are multiple options to connect to your database using the command line. Use this
table to choose your best option.
Connection Option Why Use This Option?
Native ODBC connection using
the command line
Connect to your database with maximum performance.
For details about the native ODBC interface, see
“Connecting to a Database Using the Native ODBC
Interface”.
JDBC connection using the
command line
Achieve maximum platform independence. Use
functionality not supported by native ODBC.
ODBC connection using the
command line
Only use this option after trying to connect to
your database using the native ODBC and JDBC
connections.