Database Toolbox    

Setting Up a Data Source for JDBC Drivers

To set up a data source for use with a Windows or UNIX system using JDBC drivers, include a pointer to the JDBC driver location in the MATLAB $matlabroot/toolbox/local/classpath.txt file. For example, add the following line to your classpath.txt file

  1. /dbtools/classes111.zip

where classes111.zip is the file containing JDBC drivers, and it is located in the dbtools directory. The filename is different for each database system. The file is available from your database provider.

Setup for Using Visual Query Builder on UNIX Platforms

If you want to use the Visual Query Builder on UNIX platforms, perform these steps to set up the JDBC data source. (You cannot use the Visual Query Builder on a Windows platform with a JDBC driver.)

  1. Start MATLAB if it is not already running.
  2. Access the Configure Data Source dialog box by typing
  1. Any existing data sources are listed under Data source.

  1. Complete the Name, Driver, and URL fields. For example:
  1. Name: orcl

    Driver: oracle.jdbc.driver.OracleDriver

    URL: jdbc:oracle:thin:@144.212.123.24:1822:

  1. Click Add to add the data source.
  2. Click Test to establish a test connection to the data source. You are prompted to supply a username and password if the database requires it.
  3. Click OK to save the changes and close the Configure Data Source dialog box.

To remove a data source, select it from the Data source list in the Configure Data Source dialog box, click Remove, and click OK.


  Setting Up a Data Source for ODBC Drivers Starting the Database Toolbox