A connection profile contains the connection property information needed to connect to a database runtime instance.
Warning: Ensure that the database server is running before attempting to test the connection or to connect to the database server.
Procedure
In
Data Source Explorer, Right-click on
Database Connections and select
New.
The new connection profile dialog box is displayed.
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
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.
Click
Next.
The driver details dialog box for the selected database if displayed.
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. .
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.
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.
to create a new driver definition. Select
to edit an existing driver definition. .
