Connecting to Oracle DB with Service Name (instead of Service ID - SID)

[intapiuser]

Connecting to Oracle DB with Service Name (instead of Service ID - SID)

When a customer tries to connect to an Oracle DB using a Direct Connection option, there's no option in the GUI in the ElastiCube Manager to use a Service Name, only a Service ID:

Solution

1) Uncheck the Use Direct Connection checkbox.

2) In the Database server location textbox, enter the following:

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=$your_ip)(PORT=$your_port))(CONNECT_DATA=(SERVICE_NAME=$service_name)))

The variables you need to input are:

• $your_ip
• $your_port
• $service_name

3) Connect to the source.