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,244 questions
express route and integration runtime and linked serrvices
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(166.4, 15%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anshal
2,251
Reputation points
Hi friends, should we also use integration runtime and linked service along the express route or express route is only enough.
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 48%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH%3C/text%3E%3C/svg%3E)
Harishga 5,995 Reputation points Microsoft External Staff2024-01-25T09:15:49.7166667+00:00 Hi @Anshal
Welcome to Microsoft Q&A platform and thanks for posting your question here.could you please provide more details about your specific scenario and what you are trying to achieve with Azure ExpressRoute, integration runtime, and linked services? Any additional information you can provide will help us provide a more accurate response.
-
Harishga 5,995 Reputation points Microsoft External Staff
2024-01-29T06:10:59+00:00 Hi@Anshal
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help. -
Harishga 5,995 Reputation points Microsoft External Staff
2024-01-30T03:50:54.5633333+00:00 Hi @Anshal
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution, please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help. -
Anshal 2,251 Reputation points
2024-02-08T10:36:55.4433333+00:00 Hi Harishga, Thank you,my question is whether we need to use linked service as well when we use express route.
-
Harishga 5,995 Reputation points Microsoft External Staff
2024-02-08T11:45:10.76+00:00 Welcome to Microsoft Q&A platform and thanks for posting your question here.
Whether you need to use Linked Services and Integration Runtime along with ExpressRoute depends on your specific requirements.
ExpressRoute provides a private connection between your on-premises infrastructure and Azure datacenters, which can be used to move data between the two. However, if you need to connect to external data sources such as on-premises databases, SaaS applications, or other cloud services, you will need to use Linked Services.
Integration Runtime is used to connect to data sources that are not publicly accessible, such as data sources behind a firewall or in a private network. If you need to connect to such data sources, you will need to use Integration Runtime along with ExpressRoute and Linked Services.
In summary, if you only need to move data between your on-premises infrastructure and Azure datacenters, ExpressRoute may be enough. However, if you need to connect to external data sources or data sources that are not publicly accessible, you will need to use Linked Services and Integration Runtime along with ExpressRoute.
For more information on using ExpressRoute, Linked Services, and Integration Runtime together, you can refer to the following Azure documentation:
https://learn.microsoft.com/en-us/azure/data-factory/create-self-hosted-integration-runtime?tabs=data-factory
https://learn.microsoft.com/en-us/azure/data-factory/connector-overview
https://learn.microsoft.com/en-us/microsoft-365/enterprise/azure-expressroute?view=o365-worldwideI hope this information helps you. Let me know if you have any further questions or concerns.
Sign in to comment
Sign in to answer