Oracle Service Cloud error when setting up ADF linked service

Question

We have already setup up a vpn tunnel and all the necessary network configuration to Oracle Service Cloud. I created a Linked service to Oracle Service Cloud  but when i test it i get this error: ERROR [HY000] [Microsoft][OSvC] (20) Error while attempting to use REST API: Timeout was reached ERROR [HY000] [Microsoft][OSvC] (20) Error while attempting to use REST API: Timeout was reached

 

Now i am not a network guy but do i need to set some sort of additional connection from azure data factory studio such as "Private EndPoint Connections" ? 

 

What am i missing here?

 

Thank you!

Answer 1

Your connection attempts to connect to the Oracle Service Cloud REST API but it is timing out and I am assuming the following :

• Your VPN tunnel is not properly configured
• Firewall rules blocking the traffic between ADF and Oracle Service Cloud
• Oracle Service Cloud endpoint is not reachable from your network

One other detail, if your Oracle Service Cloud instance is not publicly accessible and requires a private connection, then you might need to set up a Private Endpoint in Azure

So you need to :

1. Verify VPN and network settings
2. Set up a Private Endpoint if necessary
3. Ensure ADF linked service configuration is correct
4. Increase timeout settings in ADF
5. Test connectivity using tools like curl or Postman.

If you still have an issue, don't hesitate to contact the Azure Support.