Connecting to a database by using a wizard

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:

  1. 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 New > New Connection to a Database from the Administration Explorer toolbar.

  2. 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.
  3. 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.

  4. 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).

Feedback