You’re offline. This is a read only version of the page.
Announcements
145
Hi I am trying to set up a dataflow for our dynamics entities to connect to oracle db. I supplied the server info in the following format:
(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = x.x.x.x)(PORT = xxxx))(CONNECT_DATA =(SERVICE_NAME=nnnn.nnn.org))). I have chosen the on-prem data gateway that was provided to us and using basic authentication supply username and password. I am getting "An exception occurred: Oracle: ORA-12170: TNS:Connect timeout occurred (Session ID: 97672db7-6a93-4590-a093-bb8e5a67b891).
I have used the same info above to connect power bi to the same database and it has worked. Appreciate the help. Thanks.
Did you install on premise data gateway for power apps? It can't use the same one as power bi
The error you posted is a general connectivity issue.
Please follow the steps in this post to connect to your oracle database https://powerapps.microsoft.com/en-us/blog/connecting-to-oracle-database-from-powerapps-flow-and-logic-apps/
Also note that it is finicky about version of database and data tools.
Supported versions: Oracle 9 and later, Oracle client software 8.1.7 and later.
@UC3378 if this answers your question please mark it a solution
Share
Report
All responses (
Answers (
