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:

The variables you need to input are:

• $your_ip
• $your_port
• $service_name

3) Connect to the source.