Azure data factory, self hosted IR copy activity fails

Prashanth Rathinavel 0 Reputation points
2023-03-22T21:01:53.4033333+00:00

Hi

I'm trying to create a copy activity with the self-hosted IR connected to on-premise oracle db and the destination is azure SQL db. i have installed self-hosted IR and the linked service for oracle db is working fine and i can preview the data from the tables.

but during the copy activity fails and says the connection is not established. and in the IR config. manager the https proxy should be enabled or direct access has to be set up ..

thanks in advance

Azure SQL Database
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,517 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Nandan Hegde 29,886 Reputation points MVP
    2023-03-23T03:23:45.7766667+00:00

    Hey,

    whenever you use an IR in either source or sink dataset within a copy activity, it is needed that the IR should be able to access both the source and sink.

    Based on the error message it seems either of the one is unable to be accessed from the IR.

    So to debug your issue, please login within the IR and try accessing the oracle db and Azure SQL database and which ever is not being accessed, you would need to make the necessary network changes in IR.

    In case of an Azure SQL DB access issue:

    https://learn.microsoft.com/en-us/answers/questions/1021875/cannot-connect-to-sql-database

    0 comments
  2. ShaikMaheer-MSFT 37,896 Reputation points Microsoft Employee
    2023-03-24T12:40:31.08+00:00

    Hi Prashanth Rathinavel,

    Thank you for posting query in Microsoft Q&A Platform.

    Please note, if your Source linked service uses selfhosted IR and Sink linked service uses some other IR, still in copy activity, both source and sink uses Selfhosted IR only to access. Click here to know more.

    In your case, it seems Azure SQL cannot be accessed using self hosted IR, kindly make sure your selfhosted IR machine IP to add to firewall rules of Azure SQL and make sure your selfhosted IR able to access it. That way you can avoid this error.

    Hope this helps. Please let me know how it goes.

    Please consider hitting Accept Answer button. Accepted answers help community as well.

    0 comments