Oracle Fusion Query Tool. Live Data in Excel

Live Oracle Cloud data and reports, directly in Excel

Stop bouncing between Oracle screens, exports, and disconnected spreadsheets. Cloud Query gives business users and power users a faster way to work with Oracle Fusion data — in the Excel environment they already know.

Customers

HR, Payroll, Finance & more

Excel-Oracle Integration

In HR Operations

Solutions for both platforms

Of Industry Expertise

Cloud Query Key Capabilities

Optimized Oracle Fusion reporting, right in Excel

Real-time reporting / extraction
No row limits
Cross-module data access
Scheduled report refresh
Native Excel interface — no new UI
Data dictionary views included

Perfect, Excel-formatted output
Run multiple reports simultaneously
Refreshable dashboards
Multi-environment / pod support
Named ranges and tables for pivot use
Built-in visualization integration

One-click refresh
Dynamic drilldown and drill-across
Run Ad-Hoc SQL (power users)
Adheres to Oracle roles and security
Optional AI integration
Email distribution

Powerful Flexibility

The right tool for every user on your team

Cloud Query supports two distinct ways of working with Oracle Fusion data, licensed and delivered as a single product.

For Business Users

Cloud Query for BI Publisher Reports

Run standard and custom Oracle BI Publisher reports directly from Excel — quickly, easily, and without any technical knowledge. Cloud Query adds a drilldown and drill-across layer that Oracle BI Publisher does not natively provide, letting users navigate from summary to detail and across related reports without leaving Excel.

Run multiple reports into a single workbook and refresh them all with one click — or schedule them to refresh automatically.

Ideal for:

Business users and managers
Business analysts

For Power Users

Cloud Query Ad-Hoc

Write and run your own SQL directly from Excel. Cloud Query provides true, instantaneous ad-hoc access to Oracle Fusion data.

Includes data dictionary views, visualization integration, scheduling, multiple queries in a single worksheet and workbook, the ability to connect to multiple instances simultaneously to compare data between instances, and much more. It’s the easiest and most complete way to do ad-hoc analysis for Fusion Cloud.

Ideal for:

IT
Power users / report developers

Report & Query Types

Report / Query Type	Description
Parameter-Based Reports	Reusable Excel template with input prompts for business users
Drilldown Reports	Drill into details or across business areas (e.g. summary to transactions)
Cross-Environment Queries	Query Prod, Test, and UAT environments in parallel
Excel Dashboards	Use live Cloud data to drive pivot tables, charts, KPIs, etc.
Ad-Hoc SQL Query	Power users write Oracle SQL in Excel and pull real-time data from Cloud

Problems we solve

Limited by Oracle's native reporting tools?

Cloud Query was built to remove the constraints that Oracle Fusion users run into every day with standard reporting approaches.

Too many steps to run a report

Oracle forces users to bounce between screens, BI Publisher, exports, and spreadsheets. Cloud Query runs reports in seconds, from a familiar Excel interface.

OTBI subject area limitations

OTBI restricts what data you can see and join. Cloud Query gives direct access across all Oracle modules with no subject area constraints.

Too much dependency on IT

Oracle data access limitations often require IT involvement. With Cloud Query, users work with live data in Excel and have full control over their data analysis.

No drilldown capability

In Oracle, every report has to be manually submitted. In Cloud Query, users can double-click to drilldown into detail or drill-across to other related information.

Power users need more flexibility

Advanced users need a practical way to run ad-hoc analysis. Cloud Query makes ad-hoc SQL easy in a powerful Excel UI.

Stale exports and manual refreshes

Tired of downloading exports and pasting data? Cloud Query delivers live Oracle data directly to your workbook — one click to refresh.

Why Cloud Query

What changes when you use Cloud Query

Task / Capability	Without Cloud Query	With Cloud Query
BI Publisher report access	Navigate Oracle UI, export manually	Run reports directly from Excel, results in workbook
Report refresh	Manual steps, multiple clicks	One-click refresh — single report or entire workbook
Drilldown across reports	Not natively supported in Oracle BIP	Built-in drilldown and drill-across layer
Row limits	Capped or truncated	No row limits — fetch thousands of rows
Ad-hoc Oracle Fusion queries	Requires BI Publisher or OTBI development	Write SQL directly from Excel, results in workbook
Supporting multiple user types	Separate tools for business vs. power users	One product, two modes, controlled access
Real-time data access	Scheduled exports and stale snapshots	Live Oracle data on demand, every time you refresh
Cross-environment comparison	Complex, requires staging or data mart	Query Prod and UAT side by side in a single workbook
Self-service reporting	Business users depend on IT for every request	Parameterized templates let users run their own reports

Key differentiators

What makes Cloud Query different

Excel-native experience

No new tools to learn. Data comes directly into the workbook your users already work in every day.

BIP drilldown layer

Create relationships between reports. Navigate from summary to detail and across related outputs — natively in Excel.

True ad-hoc SQL

Not a query builder. Power users write and run real SQL against Oracle Fusion data, with full flexibility.

Multi-report refresh

Submit and refresh multiple reports in a single workbook with one click, or schedule them to refresh automatically each morning.

Direct Excel integration

Report output generates named ranges and tables in Excel, ready for pivot tables, charts, and Excel-side data analysis.

One framework for all users

Business users and power users in the same environment. No need to evaluate or manage separate reporting tools.

FORM – Cloud Query

Proven and Trusted Worldwide

Trusted by Oracle teams worldwide, API Wizard helps organizations reduce manual effort while improving speed, accuracy, and control.

FBDI and OTBI weren’t built for flexibility. API Wizard’s Cloud Query finally gave us the real-time Cloud reporting we needed — straight from Excel. Our users refresh reports daily across 4 pods, and we’ve saved 15+ hours/week.