Click
on the Oracle option to open the Oracle connection options.

Database
|
Enter
the name of the database. The value may be one of the
following:
| ·
|
The
server, port, and service descriptor of the database e.g.
OraSrv:1521/orcl
|
| ·
|
TNS
alias name, specifying the database to connect to e.g. OraSrv
|
| ·
|
The
full connection descriptor, as entered in TNSNames.ora e.g.
|
|
|
(DESCRIPTION
= (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = OraSrv)(PORT =
1521)))(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = orcl)))
|
| ·
|
The
full Oracle connection string e.g. scott/tiger@OraSrv
|
|
User
name
|
Enter
the name of the database user to connect as.
|
Password
|
Enter
the password of the database user.
|
In order to connect to Oracle servers, the Oracle client libraries
must be installed. You can use the full client installation set, or
the Oracle Instant Client pack. If you are using the Oracle Instant
Client pack, the path to the Instant Client folder must be included
as part of the system's PATH settings.