# Creating a Database Connection Profile

A connection profile contains the connection property information needed to connect to a database runtime instance.

Prerequisites

Switch to the Database Development perspective. Make sure that the database server is running before attempting to test the connection or to connect to the database server.

1. In Data Source Explorer, right-click Databases and select New.
2. (Optional) Filter the Connection Profile Types list.

   For example, to list all databases that begin with the letter D, enter a `d` in the text box. You can also enter a text string such as `JDBC` or `embedded` to filter the list.

3. Select a connection profile type.
4. (Optional) Change the Name from the system-provided default, and/or enter a Description, and click Next.

   You must change the name if a connection profile already exists with the same name.

5. Indicate a driver definition.
   - Select one from the list. If a driver definition does not exist for the database type you selected, you can create one.
   - Select New Driver Definition to create a new driver definition.
   - Select Edit Driver Definition to edit an existing driver definition.

   The Properties tabs populate with default template information for the selected driver.

6. (Optional) Add or modify the Properties information in the Connection or Other Properties tabs.
   1. Click Save Password to save the password for the database server login.
   2. Select Connect When the Wizard Completes to connect to the database server once you finish defining this connection profile.
   3. Select Connect Every Time the Workbench Is Started to automatically connect to the database server using this connection profile when you launch Eclipse.
   4. Click Test Connection to ping the server and to verify that the connection profile is working.
7. (Optional) Click Next to view Summary information.
8. Click Finish to create the connection profile.

Related concepts
Data Source Explorer View
Related tasks
Setting Connectivity Preferences
Creating a Driver Definition
Creating a Connection Profile
Refreshing a Connection Profile
Renaming a Connection Profile
Deleting a Connection Profile
Testing a Connection Profile
Importing a Connection Profile
Exporting a Connection Profile
Editing Connection Profile Properties
Related reference
Database Connection Profile Preferences
Driver Definitions
Label Decorations Preferences