


For more information, see Understand gateways. You can use the same gateway with multiple services and multiple data sources. To install a gateway, follow the steps in this tutorial.Īn on-premises data gateway acts as a bridge, providing quick and secure data transfer between on-premises data (data that isn't in the cloud) and the Power BI, Power Automate, Logic Apps, and Power Apps services. Installation of an on-premises data gateway.Oracle Data Access Client (ODAC) software 11.2 or later.

The Oracle Database connection supports full delegation of filtering, sorting, and other functions but not triggers or stored procedures. List tables, and create, read, update, and delete table rows in an Oracle database after you create a connection and build an app in Power Apps.
