What should I put the "Host" while linking the Oracle Service Cloud to Azure Synapse Analytics?

Pallav Kulkarni 1

I want to link the Oracle Service Cloud to Azure Synapse Analytics portal, but I am not getting what should be the "Host"

12296-screenshot-65.png

1 answer

HimanshuSinha-msft 19,381 Reputation points Microsoft Employee

2020-07-15T21:34:18.637+00:00

Hello @PallaviKulkarni-5080 ,

Thanks for the question and using this forum,

I see that you have already reached out to the MS support team for help .

I think the host in the case should be https://adb.us-phoenix .......................... . admin is the user name . My apoloziges i don't oracle subscription to test this .
Please do let me know how it goes .

Thanks Himanshu

Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members
Please sign in to rate this answer.
Pallav Kulkarni 1 Reputation point

2020-07-16T05:42:46.15+00:00

Thank you @HimanshuSinha-MSFT for your answer.
I tried the suggested hostname, adding "https" instead of "admin", but it's still giving me the same error.

Connection failed
ERROR [HY000] [Microsoft][OSvC] (20) Error while attempting to use REST API: Couldn't resolve host name ERROR [HY000] [Microsoft][OSvC] (20) Error while attempting to use REST API: Couldn't resolve host name Activity ID: 0c49ca16-d423-40c1-ab33-fcfd7ded

HimanshuSinha-msft 19,381 Reputation points Microsoft Employee

2020-07-20T03:08:14.82+00:00

Hello @pallav ,

Assuming Oracle cloud host is configured for internet connection, please follow https://docs.cloud.oracle.com/en-us/iaas/Content/Database/Tasks/connectingDB.htm# for insight.

I think we need to pass adb.us*****.com as host name. Good luck.

Thanks
Himanshu

HimanshuSinha-msft 19,381 Reputation points Microsoft Employee

2020-07-21T20:49:07.15+00:00

Hello ,
Just wanted to follow up and check if the suggestion helped you resolve the issue . Also if case if you have a better work around or resolution please do share that with the community as it will help other community members .

Thanks & stay safe

Himanshu
Sign in to comment

Share via

What should I put the "Host" while linking the Oracle Service Cloud to Azure Synapse Analytics?

1 answer