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.
