Frequently asked questions

It connects to your existing Oracle Cloud ERP (Oracle Fusion) instance through the BI Publisher SOAP API, an interface your Fusion instance already exposes. You write SQL in the desktop app, it runs through that API using your own credentials, and the results come back to your machine. There is nothing new to stand up — it's the Oracle Cloud ERP SQL alternative to building BI Publisher data models, with no separate database connection required.

Oracle Cloud ERP doesn't expose a direct database connection for most users, so desktop tools like SQL Developer or Toad can't reach Fusion Cloud tables at all. ERP Query Studio reaches them through the supported BI Publisher path instead — giving you a familiar SQL-Developer-like worksheet and real SQL for Oracle Fusion, without a direct DB connection.

You authenticate with your own authorized credentials — username/password or SSO. Each user connects as themselves, which keeps query activity tied to the right identity rather than a shared service login.

Yes. ERP Query Studio supports SSO login alongside username/password, so you can connect using your organization's standard Oracle Cloud ERP sign-in flow.

Data flows from your Oracle Cloud ERP instance directly to your desktop. There is no third-party server in the data path — your results aren't routed through, stored on, or processed by any infrastructure we run. The query goes out with your credentials and the rows come back to your machine.

Saved credentials are encrypted in your operating system's keychain — Keychain on macOS, Credential Manager on Windows. They are not stored in plain text and are not transmitted to us. SSO follows your organization's normal sign-in flow.

No. ERP Query Studio runs the SQL you write using your own authorized access. It does not bypass Oracle security, escalate privileges, or expose tables you aren't entitled to query. If you couldn't reach a piece of data through your existing Oracle Cloud ERP permissions, you can't reach it here either.

It's a desktop client built to survive a security review: credentials encrypted in the OS keychain, your own authorized access only, no third-party server in the data path, a strict Content-Security-Policy, a sandboxed renderer, and a hardened Electron runtime. There's no server component for an attacker to target and no central store of your data or credentials.

ERP Query Studio is built for querying, extracting, reporting, and analyzing data — not for mass-modifying production ERP records. What runs is constrained by your own Oracle permissions: the app can't perform anything your authorized access doesn't already allow. As with any SQL tool, treat production as production, review what you run, and apply your organization's change-control practices.

Oracle Cloud ERP — Oracle Fusion. It's purpose-built as an Oracle Cloud ERP query tool and an Oracle Fusion BI Publisher query tool, giving SQL-fluent users a self-serve way to query Oracle Fusion tables. (Oracle, Fusion, and BI Publisher are referenced descriptively to explain compatibility.)

You can query the tables your Oracle Cloud ERP access authorizes — no more, no less. It's not a backdoor to the whole database; it's a SQL worksheet that respects the permissions you already hold. An object and schema explorer helps you browse the tables and columns available to you, with a reminder when the cached schema is stale.

Large queries don't choke the app. Results load in batches with pagination rather than pulling everything at once, fetch timeouts are configurable, and when you need the full set you can run a streaming full-query export straight to CSV, Excel (xlsx), or JSON for large extracts. You stay responsive while big Fusion tables stream back in the background.

Sort, apply Excel-style and cascading column filters, search across columns and cell values, pin/hide/reorder columns, open a Single Row View, and copy as delimited, distinct, or HTML table. You can export to CSV, Excel (xlsx), and JSON, including streaming full-query export for large result sets. ORA-##### errors are decoded into plain-English titles, likely causes, the offending line, and a docs link.

No. ERP Query Studio is a desktop app you install on your own machine (macOS or Windows). There's no middleware, agent, or server component to deploy, and nothing to provision inside your Oracle environment beyond the access you already have.

Yes — it's a cross-platform desktop app for both macOS and Windows, with the same SQL worksheet, results grid, and export tools on each.

There's a 14-day free trial with no credit card required to start. After that it's an annual per-seat subscription — $249 per seat for individuals, with volume pricing ($219 per seat) for teams of 3 or more. Reach out about Enterprise licensing.

Running queries requires a live connection to your Oracle Cloud ERP instance, so you need network access to fetch data. Once results are loaded, working with them locally — sorting, filtering, exporting — happens on your machine.

No. ERP Query Studio is an independent product and is not affiliated with, endorsed by, or sponsored by Oracle. Oracle, Oracle Fusion, and BI Publisher are referenced descriptively only, to explain what the tool is compatible with and how it connects.