Creating a Database Connection Profile

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

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.