You’re offline. This is a read only version of the page.
You can connect Microsoft Copilot Studio to an on-premises Oracle Database by using the Oracle Database connector through the Power Platform On-premises Data Gateway.
This integration allows Copilot Studio to access structured data in Oracle securely and in real time — without replicating or moving the data to the cloud.
Install the On-Premises Data Gateway
The gateway acts as a secure bridge between your on-premises Oracle environment and Microsoft cloud services (like Copilot Studio, Power Apps, or Power Automate).
You only need one gateway installation to connect multiple data sources or services.
Install the Oracle Client on the Gateway Machine
Ensure the 64-bit Oracle Data Provider for .NET (ODAC) is installed — version 11.2 or later.
The Windows installer version must be used (the xcopy version isn’t supported).
You can verify installation using PowerShell:
You should see “OracleClient Data Provider” listed in the output.
Create the Connection in Copilot Studio / Power Platform
Navigate to Data → Connections → New Connection.
Choose Oracle Database, then provide your server name, port, SID or service name, and credentials.
Test the connection to validate access through the gateway.
Oracle Database: 9 and later
Oracle Data Access Client (ODAC): 11.2 and later
Microsoft only indexes metadata (like table and column names).
There is no data movement between systems — each query runs directly against your Oracle instance at runtime.
All requests use the user’s authenticated identity, ensuring that existing Oracle access controls remain enforced.
Share
Report
All responses (
Answers (
2
