Share via

Can I use the same self-hosted IR in multiple linked service in synapse?

Federico Sardo 91 Reputation points
2023-08-02T18:22:08.2966667+00:00

Hi,

I am working with 3 different synapse workspaces (dev-qa-prod) and I need to use Self-host IR to copy data from SAP and a Postgres.

I already know that shared-IR can't be use in Synapse, so I am creating 3 different windows virtual machines (one per environment) and I am going to install self-hosted IR in each vm. So far, so good.

What is not clear for me is the following situation:

  • Working in dev synapse workspace (with a self-hosted IR installed in it's Windows vm, let's call it selfhostedIR-dev) If I need to create a linked service in order to connect to SAP I will use the selfhostedIR-dev, that's clear for me
  • Now spouse that I need to copy data from postgres, Can I use the same Integration Runtime (selfhostedIR-dev) already installed? As I mentioned, I know that there is one IR per synapse workspace.

Because if not, looks very weird if I need to install X numbers the IR in the same windows vm for any source.

Thanks in advance.

Fede

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.
5,380 questions
Accepted answer
  1. Nandan Hegde 36,156 Reputation points MVP Volunteer Moderator
    2023-08-03T02:55:46.74+00:00

    Hey,

    Within a workspace. you can use the same SHIR in any number of linked services as long as you are able to access those services from the server on which the IR is installed.

    But as you stated, you cannot share that IR with other workspaces unlike ADF

    1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Javier Villegas 905 Reputation points MVP
    2023-08-09T18:12:17.8666667+00:00

    Hi @Federico Sardo

    As long as the IR have network access to the the local resource you should be able to use it to get from multiple sources

    Create and configure a self-hosted integration runtime

    Regards

    Javier

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.