Drivers |
Select a driver from the list. If an appropriate driver definition does not exist, you can create one.
- Select
New Driver Definition to create a new driver definition.
- Select
Edit Driver Definition to edit an existing driver definition.
If deploying a web service to EAServer or Service Container, you need to add the JAR to the lib\ext directory in the EAServer installation.
|
Database |
Database associated with the connection profile. |
URL
|
URL address for the profile.
In most cases, if you selected a provided driver, you do not need to modify the value in this field.
|
User Name
|
User ID associated with the connection profile.
|
Password
|
Password for the database server login.
|
Save Password |
Save the password for this connection profile.
Passwords persist only for the current session. If you do not save your password and exit the workbench, you have to enter it when trying to connect to the database server via the connection profile for the new session. Note: Whether you want to save your password depends on your organization's security policy. Passwords are saved in the workspace metadata in the ServerProfiles.dat file with minimal encryption.
|
Optional |
- In the
text box, specify connection properties using the KEY=value format, or choose
from the drop-down list, and click
Add.
For example,
DYNAMIC_PREPARE=true.
- Use the
Up,
Down,
Remove, and
Clear All buttons to delete or
change the order of the connection properties.
|
Test Connection |
Ping the
server and verify that the connection profile is working. |