You can use the pages in the New Connection wizard to create
a connection profile, so that you can connect to and browse existing
data object. This topic explains how to open the New Connection wizard
from the Data Source Explorer view (or
the Administration Explorer for products that include this view).
The New Connection wizard pages can also be embedded in other wizards
in the workbench.
About this task
You can also create a new connection by creating a duplicate
of an existing connection. This method is useful if you want to create
a connection that is similar to an existing connection but with different
properties. To create a duplicate of an existing connection, right-click
a connection and select Duplicate. You can
then edit the properties of
the duplicate connection as needed.
Procedure
To connect to a database by using a wizard:
- Right-click in the Data Source Explorer, and select New
Connection from the pop-up menu.
For
products that contain the Administration Explorer, you can also click from the Administration Explorer toolbar.
- On the first page of the wizard, select a database manager,
a JDBC driver, and then specify the connection details.
Note: Your
password is temporarily stored in your workbench while you are connected
to a database server and is removed when you disconnect. To permanently
store your password in the workbench, select Save password.
- Optional: On the Filter page,
specify filtering options.
For best performance, you
should use filters when you are connecting to a large database.
If
you do not specify filtering options in the wizard, you can modify
them later by modifying connection properties or by specifying data object filter options. To modify
connection properties, right-click a connection and select Properties.
Filtering
is not enabled by default on the wizard page. To filter your connection,
clear the Disable filter check box, then specify
filtering options either by using an expression or by selecting specific
objects to include or not include in the connection view.
- Complete all other wizard steps and click Finish.
Results
The connection is displayed in the Data Source Explorer
(and
the Administration Explorer for products that contain this view).