User`s guide

2 Getting Started with Database Toolbox
2-6
Connection Options
In this section...
“Creating or Connecting to a Data Source” on page 2-6
“Defining Operating System Authentication” on page 2-6
“Connection Options” on page 2-6
“Working with Multiple Databases” on page 2-8
Creating or Connecting to a Data Source
If you already have your driver installed, you can create a data source for an ODBC
driver or add the JDBC driver to the Java class path in MATLAB using the examples
in “Configuring a Driver and Data Source” on page 2-13. Otherwise, see Driver
Installation to help you install your driver. If your data sources are defined, then you
are ready to connect to your database. If you created JDBC data sources using VQB,
then see “Migrate from VQB to Database Explorer” on page 4-2. For details, see
“Connecting to a Database” on page 2-191. Once connected, you can begin to explore
your database using Database Explorer or the command line to view your data. For
details, see “Selecting Data” on page 2-195.
Defining Operating System Authentication
Operating system authentication allows you to connect to your database using your
operating system user account. The operating system performs user validation and
the database does not require a different user name and password. Operating system
authentication facilitates easy maintenance of database access credentials. For example,
Windows provides operating system authentication that can be configured to work with
a Microsoft SQL Server database. For details about Microsoft SQL Server Windows
authentication, see “Step 3. Set up the operating system authentication.” on page
2-36
Connection Options
There are numerous ways to connect to your database using Database Toolbox. The
following explains each option. Use this table to choose your best option.