Database Toolbox User's Guide
  Go to function:
    Search    Help Desk 

System Requirements

The Database Toolbox works with the following systems and applications.

Platforms

The Database Toolbox runs on the following platforms:

MATLAB Version

The Database Toolbox requires MATLAB Version 5.2 (R10) or later. You can see the system requirements for MATLAB online at
http://www.mathworks.com/products/ml5_sysreq.shtml.

Databases

Your system must have access to an installed database. The Database Toolbox supports import/export of data for the following database management systems:

Drivers

The Database Toolbox supports all Open Database Connectivity (ODBC) drivers used with the supported databases. Java Database Connectivity (JDBC) drivers are not officially supported, but some have been tested and found workable.

The driver for your database must be installed in order to use the Database Toolbox. Most users (or their database administrators) install the driver when they install the database. Consult your database documentation if you need instructions to install a database driver.

About Drivers for the Database Toolbox

An ODBC driver is a standard interface that enables communication between database management systems and SQL-based applications. Every database supported by the Database Toolbox provides an ODBC driver.

The Database Toolbox is a Java-based application. To connect the Database Toolbox to a database's ODBC driver, the toolbox uses a JDBC/ODBC bridge, which is supplied with and automatically installed as part of the toolbox.

A JDBC driver is a standard interface that enables communication between Java-based applications and database management systems.

Third-party companies supply JDBC drivers. It is technically possible to use a JDBC driver with the Database Toolbox instead of using an ODBC driver, but JDBC drivers are not officially supported by The MathWorks.

The MathWorks has tested the JDBC drivers listed below and found them to be usable with the Database Toolbox. You may find that you can use them without any problems.

Table 2-1: Tested JDBC Drivers
Driver
 Database
 Company
ORACLE
 ORACLE
 ORACLE
FastForward
 SYBASE
MS SQL
 Connect Software
Imaginary
 MS SQL
 Imaginary
Kona
 SYBASE
 KonaSoft, Inc.

The following illustrates the use of drivers with the Database Toolbox.


Structured Query Language (SQL)

The Database Toolbox supports American National Standards Institute (ANSI) standard SQL commands.

Data Types

You can import the following data types into MATLAB and export them back to your database:

Any other type of data that is imported is treated as a VARCHAR by MATLAB. If you import a data type that cannot be treated as a VARCHAR, you see an unsupported data message from MATLAB.

If you try to export types of MATLAB data not on this list to a database, you see a syntax error from the database.


[ Previous | Help Desk | Next ]