Introducing Thinkbox — the neuro-symbolic reasoning engine behind AirQuery Read more →
AirQuery for Oracle Autonomous Data Warehouse | Governed Conversational AI
AirQuery for Oracle ADW · Powered by Thinkbox

Ask your Oracle ADW data anything. Get governed answers.

AirQuery is a fully managed cloud platform for conversational AI analytics. Connect it to Oracle ADW in minutes, with nothing to install. Your experts build Thinkboxes on ADW schemas such as Oracle Fusion and EBS data, you pick the model, and business users ask questions in plain language. Every answer is reproducible, cited, and governed by the security rules in your AirQuery data model. Your existing Oracle Virtual Private Database (VPD) policies are supported too.

Fully managed SaaSNo data copies or pipelinesRow & column security built inSOC 2 Type II
How It Works

From Oracle ADW to trusted answers in three steps

Sign up & connect Oracle ADW

Sign up for AirQuery and connect Oracle ADW from the AirQuery console. Connect securely with your ADW wallet over mTLS. AirQuery uses a read-only connection you control, reads table metadata, and sends queries to your Autonomous Data Warehouse, so your tables are never copied into AirQuery.

  • Autonomous Data Warehouse
  • Wallet / mTLS connection
  • Fully managed, nothing to install

Build a Thinkbox

Your subject matter experts pick the schemas and tables that matter, such as Oracle Fusion or EBS data loaded with Orbit DataJump. Then they define relationships, approved metrics, business rules, and security rules for who can see which rows and columns. Thinkbox assembles these into a living model the agent reasons over.

  • Tables, joins & approved metrics
  • Row & column security rules
  • Choose your model

Ask, Verify, Share

Users ask questions in the AirQuery web workspace, Slack, or Microsoft Teams. Each answer shows its sources, SQL, and reasoning steps. Pin answers, set alerts, or embed them in your own apps through the API or MCP.

  • Plain-language questions
  • Cited SQL & reasoning trace
  • Web · Slack · Teams · API · MCP
AirQuery + Oracle ADW

Oracle ADW holds the data. AirQuery makes it answerable.

Autonomous Data Warehouse gives you a self-managing, secure warehouse on Oracle Cloud, and it's a natural home for Oracle ERP data. AirQuery adds a conversational AI layer on top, delivered as a cloud service, so business users get answers instead of tickets. Thinkbox combines model intelligence with the knowledge of your own experts. The result is analytics your CFO can trust and your analysts don't have to rebuild.

Queries run where the data lives

AirQuery's cloud reasoning layer sends SQL to your Autonomous Data Warehouse. The heavy lifting happens in Oracle ADW, with no extracts, no copies, and no second warehouse to maintain.

Your models, your choice

Use AirQuery's managed models, or connect models you already run in OCI Generative AI. Change models without rebuilding your Thinkboxes.

Security built into the data model

Row-level and column-level security rules live in the Thinkbox data model, next to your metrics. Define them once and they apply to every question, in every channel. Already use Oracle VPD? AirQuery works with your existing policies as well.

Security & Governance

Cloud AI on enterprise data, without giving up control

AirQuery is a SaaS platform built for finance, operations, and regulated teams, where a wrong number or a leaked row is not an option.

Row & column security

Security rules are part of the AirQuery data model. Map users and groups from your SSO to the rows they can see and the columns they can access, and mask sensitive fields such as salaries or personal data.

Works with Oracle VPD

AirQuery supports Oracle Virtual Private Database. It sets each user's context on the ADW session, so your existing VPD policies filter rows inside the database, on top of the rules in the AirQuery data model. The connection itself uses a read-only account you control.

No copies, no pipelines

AirQuery sends SQL to Oracle ADW and receives only the result rows needed for each answer. It never replicates your tables, and your data is never used to train models.

Fully auditable answers

Every answer records the user, question, model, Thinkbox version, security rules applied, generated SQL, and source tables. Re-run it and you'll get the same answer.

One set of rules, every channel

The same metrics and security rules apply whether a question comes from the web workspace, Slack, Teams, the API, or MCP. There are no per-dashboard permissions to maintain.

Secure, managed cloud service

SOC 2 Type II, SSO, role-based access to Thinkboxes, encrypted connections to Oracle ADW, and encryption in transit and at rest.

User questionWeb · Slack · Teams · API
→
AirQuery CloudThinkbox · metrics · security rules
→
Oracle ADWVPD policies enforced
Benefits

Why teams add AirQuery to Oracle ADW

Most Oracle ADW projects end up with clean data and a long backlog of report requests. AirQuery opens that data to the people who need it, with the same guardrails your data team built.

01 / Speed

Live in minutes, answers in seconds

No servers to deploy and no upgrades to manage. Connect Oracle ADW, build a Thinkbox, and business users can start asking questions the same day.

02 / Trust

Same question, same answer

Deterministic reasoning over approved metrics removes hallucinated numbers and conflicting definitions.

03 / Control

Governance by default

Security rules live in one place, the AirQuery data model, and are applied to every answer automatically. No shadow copies of your data.

04 / ROI

More value from your Oracle data

Turn your Oracle ERP and ADW investment into everyday decisions across finance, procurement, supply chain, and HR.

Questions We Answer

Built for the questions your teams actually ask

Finance

"Which cost centers are furthest over budget this quarter, and why?"

GL_BALANCES × BUDGETS × JOURNALS · Oracle Fusion GL

Procurement

"Which suppliers have the most invoice holds over the last 90 days?"

AP_INVOICES × AP_HOLDS × SUPPLIERS · Oracle Fusion Payables

Supply Chain

"Which items are at risk of stock-out at our top warehouses next month?"

ONHAND × DEMAND × PURCHASE_ORDERS · Oracle SCM

HR

"How has headcount and attrition changed by department this year?"

WORKERS × ASSIGNMENTS × TERMINATIONS · Oracle HCM (masked PII)

AI + HI = DI

Put a governed AI analyst on your Oracle ADW data

Connect Oracle ADW to AirQuery and see governed answers on your own data. Start free with a 14-day enterprise trial, no credit card required.

AirQuery
Privacy Overview

This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.