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:
1) Uncheck the Use Direct Connection checkbox.
2) In the Database server location textbox, enter the following:
The variables you need to input are:
3) Connect to the source.