Database Toolbox™

database - Connect to database

GUI Alternatives

Connect to databases using Visual Query Builder. For more information on Visual Query Builder, see Using Visual Query Builder.

Syntax

conn = database('datasourcename','username','password')
conn = database('databasename','username',...
'password','driver','databaseurl')

Description

conn = database('datasourcename','username','password') connects a MATLAB software session to a database via an ODBC driver and assigns the returned connection object to conn. The arguments passed to this function are as follows:

• datasourcename: The data source to which you connect.

• username and password are the user name and password required to connect to the database. If a user name or password are not required to connect to your database, specify empty strings for these arguments.

conn = database('databasename','username',...
'password','driver','databaseurl') connects a MATLAB software session to a database and assigns the returned connection object to conn. The arguments passed to this function are as follows:

• databasename: The name of the database to which you connect.

• driver: The name of your JDBC driver.

  Note   The JDBC driver is sometimes referred to as the class that implements the Sun Java SQL driver for your database.

• username and password: The user name and password required to connect to the database. If a user name or password are not required to connect to your database, specify empty strings for these arguments.

• Find the correct driver name

  databaseurl: A JDBC URL object of the form jdbc:subprotocol:subname. subprotocol is a database type, such as Oracle. subname may contain other information used by driver, such as the location of the database and/or a port number. subname may take the form //hostname:port/databasename.

If database establishes a database connection, it returns information about the connection object, as shown in the following example:

       Instance: 'SampleDB'
       UserName: ''
         Driver: []
            URL: []
    Constructor: [1x1 com.mathworks.toolbox.database.databaseConnect]
        Message: []
         Handle: [1x1 sun.jdbc.odbc.JdbcOdbcConnection]
        TimeOut: 0
     AutoCommit: 'off'
           Type: 'Database Object'

Examples

Example 1 — Establish an ODBC Connection

Connect to an ODBC data source called Pricing, specifying user name mike, and password bravo.

conn = database('Pricing', 'mike', 'bravo');

Example 2 — Establish an ODBC Connection without Specifying a User Name and Password

Connect to an ODBC data source SampleDB where a user name and password are not required to access the database.

conn = database('SampleDB','','');

Example 3 — Establish a JDBC Connection

In this example, you establish a JDBC connection by passing the following arguments to the database function:

• oracle, the database to which you connect

• scott and tiger, the required user name and password

• oracle.jdbc.driver.OracleDriver, the oci7 JDBC driver name

• jdbc:oracle:oci7, the URL that specifies the location of the database server

conn = database('oracle','scott','tiger',...
	'oracle.jdbc.driver.OracleDriver','jdbc:oracle:oci7:');

The JDBC name and URL take different forms for different databases, as shown in the examples in the following table.

JDBC Name and URL Example Syntax

See Also

close, dmd, exec, fastinsert, get, getdatasources, isconnection, isreadonly, logintimeout, ping, supports, update ,Using Visual Query Builder

cursor.fetch

database.fetch