User`s guide

4 Using Database Explorer
4-2
Working with Database Explorer
In this section...
“Getting Started with Database Explorer” on page 4-2
“Migrate from VQB to Database Explorer” on page 4-2
“Set Database Explorer Preferences” on page 4-3
If you are using Database Explorer for the first time, migrate from Visual Query Builder
(VQB) and set Database Explorer preferences. After performing these tasks, you are
ready to configure data sources and connect to your database.
Getting Started with Database Explorer
Database Explorer is a Database Toolbox app for connecting to a database and
interacting with database data. You can configure ODBC and JDBC data sources, modify
database connections, and work with multiple databases. You can also display data from
a database table, explore data from multiple database tables, and import data to the
MATLAB workspace for analysis. Once you create queries using Database Explorer, you
can generate code. For details, see:
• “Configure Data Sources and Connect to Databases” on page 4-6
• “Refine Results Using Query Criteria and Rules” on page 4-21
• “Generate SQL and MATLAB Code” on page 4-25
Migrate from VQB to Database Explorer
Database Explorer replaces VQB as an app for exploring the data in your database.
If you are using VQB, to help migrate from VQB to Database Explorer, refer to these
points:
• If you use VQB (querybuilder) to access a JDBC data source, before starting
Database Explorer for the first time, execute this command. You cannot use the same
JDBC data source with Database Explorer.
setdbprefs('JDBCDataSourceFile','')
Then, define your JDBC data source using Database Explorer.