User`s guide

1 Before You Begin
1-2
Database Toolbox Product Description
Exchange data with relational databases
Database Toolbox™ provides an app and functions for exchanging data between
relational databases and MATLAB
®
. You can use SQL commands to read and write data
or use the Database Explorer app to interact with a database without using SQL.
The toolbox supports ODBC-compliant and JDBC-compliant databases, including
Oracle
®
, MySQL
®
, Sybase
®
, Microsoft
®
SQL Server
®
, and Informix
®
. You can apply
simple and advanced conditions to database queries from MATLAB. The toolbox lets you
access multiple databases simultaneously within a single MATLAB session and enables
segmented import of large data sets.
Key Features
• Database Explorer app for working with databases interactively
• JDBC-compliant database connections
• ODBC-compliant database connections, with the option for fast access via a native
ODBC driver
• Functions for executing queries using SQL files and SQL statements
• Data import and export with multiple databases in a single session
• Large data set import via a single transaction or via multiple transactions of
segmented data
• Direct data import into numeric, cell, structure, and dataset arrays