In a logic app, for example, you can use the Request/Response trigger to start your logic app, and then add the Oracle Database connection to see its actions. So, use another trigger at the start of your workflow. The Oracle Database connection does not yet support any triggers. I will not go into the details here, but the steps for creating the connection should be very similar to the steps listed above. You can use the steps for Flow and Logic Apps to create a flow or a logic app and use the Oracle Database connection. Creating a flow using the Oracle Database connection You can refer to PowerApps documentation for more information. You may want to customize these screens, add more tables into your app to finish up your app.
If required, you can also install a gateway.
Create an app using Oracle Database connectionĭepending on the service you are using, follow the appropriate steps to create a connection. If you do not have the Oracle client installed, you will see an error when you try to create or use the connection (see the known issues below).
You can use the following link to download and install the Oracle client: Specifically, the Oracle Database connection requires the installation of the 64-bit Oracle Data Provider for.
To connect to Oracle, you will also need to install the Oracle client software on the machine where you have installed the on-premises data gateway. More about gateways can be found here ( ). So, you will probably need to do this only once. The same gateway can be used with multiple services and multiple data sources.
Based on the service that you want to connect to, you can follow the steps defined below to install:Ī note about the on-premises data gateway: The on-premises data gateway acts as a bridge, providing quick and secure data transfer between on-premises data (data that is not in the cloud) and the Power BI, Microsoft Flow, Logic Apps, and PowerApps services. The Oracle Database connection requires the On-premises data gateway to be installed. The Oracle Database connection requires the installation of the on-premises data gateway and Oracle client SDK. Supported versions: Oracle 9 and later, Oracle client software 8.1.7 and later. It does not support triggers or store procedures yet.
In addition, it supports full delegation of PowerApps’ filtering, sorting and other functions.
The Oracle Database connection allows you to list tables, and perform standard create, read, update and delete of rows in an Oracle databases. You can now connect to your Oracle Database from PowerApps, Flow and Logic Apps.