Views:

Applies to Product - Power Apps

What’s happening?
The customer is encountering a connection error when attempting to create an Oracle Database connection in Power Apps, despite having installed the ODBC driver and Oracle Client.
 

Reason:
This is likely due to one or more of the following:

  • Improper installation or configuration of the Oracle Client or ODBC driver
  • Missing or incorrect TNS (Transparent Network Substrate) configuration
  • Data Loss Prevention (DLP) policies restricting the connection
  • Incompatibility between the installed Oracle components and Power Apps requirements

 

Resolution:

  1. Verify Oracle Client and ODBC Driver Installation
    • Ensure that the Oracle Data Access Client (ODAC) version 11.2 or later is installed on the same machine as the on-premises data gateway.
    • Use the Windows installer version of ODAC, as the xcopy version is not compatible with Power Apps.
    • Reference: Connect to an Oracle database from Power Apps 
  2. Check TNS Configuration
    • Confirm that the tnsnames.ora file is correctly configured and accessible.
    • The TNS alias used in the connection string must match the entry in the tnsnames.ora file.
  3. Validate Gateway Setup
    • Ensure the on-premises data gateway is installed, running, and connected to the internet.
    • The gateway must be selected during connection setup in Power Apps.
    • Reference: https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-introduction 
  4. Review DLP Policies
    • Check if the environment’s DLP policy restricts the Oracle connector.
    • Navigate to the Power Platform Admin Center and review the policy settings under Data Policies.
  5. Test the Connection
    • Use the Power Apps portal to create a new Oracle connection.
    • Provide the server name, username, password, and select the appropriate gateway.
    • If the gateway does not appear, refresh the list or verify its installation.
  6. Further Troubleshooting
    • Review logs from the on-premises data gateway and Power Apps for detailed error messages.
    • Refer to Power Apps and SQL Server for best practices on secure and delegated connections 
    • If the issue persists, escalate to the support team with logs and configuration details.