User`s guide

4 Using Database Explorer
4-16
dialog box to create a MAT-file that saves your specified data source information
for future Database Explorer sessions.
Navigate to the folder where you want to put the MAT-file, specify a name for it
that includes a .mat extension, and click Save.
d
To test the connection, click Test.
If your database requires a user name and password, a dialog box opens
prompting you to supply them. Enter values into these fields and click OK.
A confirmation dialog box states that the database connection succeeded.
e
To add more data sources, repeat steps 5 and 6 for each new data source.
Note: You can use tabs in Database Explorer to access different data
sources. All of the data sources that you create using Database Explorer are
stored in a single MAT-file for easy access. This MAT-file name is stored in
setdbprefs('JDBCDataSourceFile') and is valid for all MATLAB sessions.
Connect to a Data Source
After configuring your OBDC or JDBC data sources, use Database Explorer to connect to
the database.
1
Open Database Explorer by clicking the Apps tab on the MATLAB Toolstrip. Select
Database Explorer from the Database Connectivity and Reporting section in
the apps gallery. Alternatively, at the command line, enter:
dexplore
2
In the Connect to a Data Source dialog box, select your data source. Or, click Cancel,
click the Database Explorer tab, and click Connect to select your data source.
3
Select your data source from the Data Sources list. Enter your user name and
password.