I am trying to retrieve some data from an Oracle DB through Flows and followed the steps mentioned here: https://powerapps.microsoft.com/en-us/blog/connecting-to-oracle-database-from-powerapps-flow-and-log...
I installed a Gateway and got help in installing an Oracle client on the same server where the gateway resides. Now when i create a flow and try to setup the Oracle connection, i get an error as below:
This is the error message:
Test connection failed. Details: An error happened while reading data from the provider: 'Object reference not set to an instance of an object.' inner exception: An error happened while reading data from the provider: 'Object reference not set to an instance of an object.' clientRequestId: 7F4B5640-CF33-421B-A57A-E39F8E55E3C1
Verified the Oracle client works too. But is there any step i am missing? Would be of great help if someone could share the step by step process if what i followed is not right. Thanks in advance.
Please check if you can log into Oracle POC server seperately , using the username and password which you used to connect here . What other options you see other than Oracle POC , share me the information.
Check these links and make sure the oracle connection is established as expected::