Connecting to a database by using a connection configuration

You can select a connection configuration in the New Connection wizard, so that the stored connection information is pre-filled in the wizard.

Before you begin

Before you can use a connection configuration to connect to a database, you must complete the following steps. In most cases, a database administrator or team leader will complete these steps for all team members.

Procedure

To connect to a database by using a connection configuration:

  1. Right-click in the Data Source Explorer, and select New Connection from the pop-up menu. As an alternative, you can right-click a connection configuration in the Data Source Explorer and select Create Connection. The New Connection wizard opens with the connection configuration selected.
  2. On the first page of the wizard, click Connection Configurations and select an existing connection configuration from the list. The properties of the connection configuration are used to populate the other fields in the wizard.
  3. Modify the connection details, if needed. For more information about each field, see Connecting to a database by using a wizard
  4. 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 in the Data Source Explorer 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.

  5. Complete all other wizard steps and click Finish.

Results

The connection is displayed in the Data Source Explorer.

Feedback