|
|
|
|
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.
-
In Data Source Explorer, right-click Databases and select New.
-
(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.
-
Select a connection profile type.
-
(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.
-
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.
-
(Optional) Add or modify the Properties information in the Connection or Other Properties tabs.
-
Click Save Password to save the password for the database server login.
-
Select Connect When the Wizard Completes to connect to the database server once you finish defining this connection profile.
-
Select Connect Every Time the Workbench Is Started 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.
-
(Optional) Click Next to view Summary information.
-
Click Finish to create the connection profile.
|
|
|