Add Oracle as a Knowledge Source in Microsoft Copilot Studio

January 6, 2026 | Copilot and AI | 5 min read

Add Oracle as a Knowledge Source in Microsoft Copilot Studio


I came across one exciting update in the Power Platform 2025 release wave 1 that will truly resonate with makers and analysts building AI-enabled agents, the ability to use Oracle databases directly as a knowledge source in Microsoft Copilot Studio. This enhancement unlocks seamless access to live transactional data without replication or custom coding, marking a major step forward for enterprise AI scenarios.

What’s the Feature?

With this new capability, Copilot Studio agents can connect to Oracle databases and reason over external data in real time, without ingesting or duplicating that data into Microsoft Dataverse or other storage.

That means:

  • Live Oracle data is queried directly as users ask questions.
  • No SQL coding required because natural language queries are translated automatically.
  • Responses are contextual, conversational in actual Oracle tables selected as knowledge sources.

This feature appears automatically in the "Agent → Add knowledge" section when you’re creating or updating a Copilot Studio agent.


Why It Matters

Here’s why this enhancement is significant for makers and businesses:

👉 Real-time insights without data duplication

Traditionally, bringing data into a Copilot agent involved copying or indexing external records, often leading to delays and complexities around data pipelines. With native Oracle support:

  • Data stays where it belongs, integrity and security remain with your Oracle system.
  • Fresh data every time, agents reason on live transactions without latency issues.

This is especially important for business domains where real-time decisions matter such as finance, supply chain and operations.

👉 Natural Language Queries Instead of SQL

One of the most powerful elements of this feature is querying with natural language. Makers and business users can ask questions like:

"Show me the top 10 customers by revenue for last quarter."

Without needing to write SQL. Copilot Studio interprets the intent, accesses the relevant Oracle tables and constructs responses conversationally.


How It Works

Here’s what happens when you add Oracle as a knowledge source:

  1. Select Oracle tables, makers choose which Oracle tables should be included
  2. Copilot Studio connects securely , using connectors built into the platform, Copilot Studio establishes a low-code connection.
  3. Natural language querying, users ask questions in the Copilot chat interface.
  4. Conversational, grounded responses, Copilot agent reasons over the live Oracle data and returns answers.

Because the data never leaves Oracle, there’s no overhead of extract, transform or loading of data, making it simpler and faster to build enterprise AI experiences.


Conclusion

The introduction of Oracle as a knowledge source in Microsoft Copilot Studio represents a meaningful step toward enterprise-ready AI experiences. By enabling natural language access to live Oracle data, directly from Copilot agents, organizations can build more intelligent, responsive and scalable solutions without complex integration work.

If your organization runs Oracle in production, this feature is worth exploring as part of AI-powered workflows and internal knowledge assistants.


  • Enabled for : Users by admins, makers, or analysts
  • Public Preview : May 19, 2025
  • General Availability: -