Creating a New Database Connection profile

(Short description required)

1. In Data Source Explorer, Right-click on Database Connections and select New.
   
2. The new connection profile dialog box is displayed.
   
3. Select the database from the filter type list for which you want to create a connection profile. 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
4. Change the Name from the system-provided default, and enter a Description. You must change the name if a connection profile already exists with the same name.
5. Click Next.
6. The driver details dialog box for the selected database if displayed.
   
7. Select the appropriate driver from the drop-down list. If a driver definition does not exist for the database type selected, you can create one. Click to create a new driver definition. Select to edit an existing driver definition. .
8. The Properties tabs displays the default template information for the selected driver. Add or modify the Properties information in the General or Optional Properties tabs.
   • Select the Save Password checkbox to save the password for the database server login.
   • Select Connect When the Wizard Completes checkbox to connect to the database server once you finish defining this connection profile.
   • Select Connect Every Time the Workbench Is Started checkbox to automatically connect to the database server using this connection profile when you launch Eclipse.
   • Click Test Connection to ping the server and to verify that the connection profile is working.
9. If you want to create database select the Create database checkbox and if you want to upgrade your database then select the Upgrade database to current version checkbox.
10. Click Next to view Summary information.
11. Click Finish to create the connection profile.