Learn more about Database Toolbox

Working with Databases

On this page…
Connecting to Databases Supported Platforms Supported Databases Supported Drivers Structured Query Language (SQL)

Connecting to Databases

Before you can use this toolbox to connect to a database, you must set up data sources. For more information, see Configuring Your Environment in the Database Toolbox™ Getting Started Guide.

Back to Top

Supported Platforms

This toolbox runs on all platforms that the MATLAB^® software supports.

For more information, see Database Toolbox system requirements at http://www.mathworks.com/products/database/requirements.html.

Note   This toolbox does not support running MATLAB software sessions with the -nojvm startup option enabled on UNIX® platforms. (UNIX is a registered trademark of the Open Group in the United States and other countries.)

Back to Top

Supported Databases

This toolbox supports importing and exporting data from any ODBC- and/or JDBC-compliant database management system, including:

• IBM DB2^®

• IBM^® Informix^®

• Ingres^®

• Microsoft^® Access™

• Microsoft^® Excel^®

• Microsoft^® SQL Server™

• MySQL^®

• Oracle^®

• Postgre SQL (Postgres)

• Sybase^® SQL Anywhere^®

• Sybase SQL Server^®

If you are upgrading an earlier version of a database, you need not do anything special for this toolbox. Simply configure the data sources for the new version of the database application as you did for the original version.

Back to Top

Supported Drivers

This toolbox requires a database driver. Typically, you install a driver when you install a database. For instructions about how to install a database driver, consult your database administrator.

On Microsoft^® Windows^® platforms, the toolbox supports Open Database Connectivity (ODBC) drivers and Sun™ Java™ Database Connectivity (JDBC) drivers. JDBC drivers are recommended for use with 64-bit machines.

On UNIX platforms, the toolbox supports Java Database Connectivity (JDBC) drivers. If your database does not ship with JDBC drivers, download drivers from the Sun JDBC Web Site at http://industry.java.sun.com/products/jdbc/drivers.

Back to Top

Structured Query Language (SQL)

This toolbox supports American National Standards Institute (ANSI) standard SQL commands.

Back to Top

Before You Begin

Supported Data Types

© 1984-2010- The MathWorks, Inc.    -   Site Help   -   Patents   -   Trademarks   -   Privacy Policy   -   Preventing Piracy   -   RSS