OracleServiceCloud Is not working while Creating Linked Service

Vamsi Krishna Sahithya Nistala 0 Reputation points
2023-10-24T18:39:17.2266667+00:00

If I give the https://<<>>.oraclecloud.com I'm getting the Below error.

ERROR [HY000] [Microsoft][OSvC] (20) Error while attempting to use REST API: Couldn't resolve host name

If I remove it and use <<>>.oraclecloud.com I'm getting the below error

ERROR [HY000] [Microsoft][OSvC] (100) Error parsing JSON: Invalid value. while parsing string <!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML 2.0//EN"> <html><head> <title>404 Not Found</title> </head><body> <h1>Not Found</h1> <p>The requested URL was not found on this server.</p> </body></html>

Tried several combinations and none of them are working. Any quick help is appreciated.

Below is the screen shot of details I provided. Masked the Secure Info

User's image

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,553 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Smaran Thoomu 11,370 Reputation points Microsoft Vendor
    2023-10-25T10:03:41.8266667+00:00

    Hi @Vamsi Krishna Sahithya Nistala
    As I understand your query you are facing an issue while creating a linked service for OracleServiceCloud.

    The error message "Couldn't resolve host name" indicates that the URL you are using is not valid or cannot be resolved. On the other hand, the error message "Invalid value. while parsing string" indicates that the JSON response received from the REST API is not in the expected format. There could be several reasons for this error, including network connectivity issues, incorrect connection settings, or authentication errors.

    Here are some troubleshooting steps you can follow to resolve the issue:

    1. Verify the endpoint URL you are using to connect to the OracleServiceCloud REST API is correct.
    2. Check if your firewall or network is blocking your connection to Oracle Service Cloud. If it is, you may need to allow the IP address of your Azure Synapse instance to access Oracle Service Cloud.
    3. Check the credentials used for authentication. Ensure that the username and password are correct and have the necessary permissions to access it.
    4. Ensure that the OracleServiceCloud REST API is accessible from your network. You can try accessing the REST API using a tool like Postman to verify if it is accessible.

    If you're still having trouble, you can try installing the self-hosted integration runtime. This is a server that you manage yourself, and you can install the Oracle Service Cloud connector on it to connect to your on-premises Oracle Service Cloud instance.

    Reference: Copy data from Oracle Cloud Storage - Azure Data Factory & Azure Synapse | Microsoft Learn

    Hope this helps. Do let us know if you any further queries.


    If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.