The following settings can be defined for the Oracle destination.

XU_oracle_connection_test_1

Alternatively you can enter the connect descriptor, such as:

(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)
(HOST = [oracle host name])(PORT = [port number]))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = [oracle service name])))

XU_oracle_connection_test_2

Connection

Host / Data source
Defines the name of the Oracle server or the connect descriptor.

Port
Defines the Oracle server connection port (Default: 1521).

SID / Service name
Defines the unique name (SID) or the alias (service name) of the Oracle database.

Username
Defines the user name.

Password
Defines the password.

Test Connection
Checks the database connection.