An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
@cthivierge Thanks for the question and using MS Q&A platform.
In a high availability scenario for the Self-Hosted Integration Runtime, you only need to configure “Remote access to intranet” on the first node. This is done before adding any other nodes to ensure that the first node can communicate with the other nodes that will be added later.
Once the first node is configured with “Remote access to intranet”, you can then add other nodes to the Self-Hosted Integration Runtime These additional nodes do not require the “Remote access to intranet” to be configured individually.
This setup allows for higher availability of the self-hosted integration runtime, ensuring it’s not a single point of failure in your data solution. It also improves performance and throughput during data movement between on-premises and cloud data stores.
Please refer this thread https://learn.microsoft.com/en-us/answers/questions/818758/high-availability-or-multiple-node-setup-for-self
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.