Connector that lets Power BI, Logic Apps and Power Apps reach data held on-premises. Azure Data Factory does not use it.
Read more: Microsoft Learn
In the Ultra Transcenders books
AZ-305AZ-104AZ-700SC-500DP-600DP-700PL-300
Each book explains On-premises data gateway in context, with comparison tables and the common traps.
Terms in this definition
- Power BI
Microsoft's analytics and reporting service. It reaches data held on-premises through the on-premises data gateway.
- Logic Apps
Low-code Azure service for building automated workflows from triggers, actions and connectors, used for things like integrating systems or sending approval emails.
- Azure Data Factory
Managed data integration service for ETL and ELT, built from pipelines, copy activities, triggers, mapping data flows and integration runtimes. It works in batches rather than routing individual transactions.
Related terms
- Azure Relay
Messaging service connecting cloud and on-premises endpoints through outbound connections on port 443, without a VPN, inbound ports or VNet routing. The on-premises data gateway and App Service Hybrid Connections rely on it.