FAQ
Frequently asked questions
Is Fusion SQL free?
Yes. All current features are free. Paid team plans may be added later, but the features available today will stay free.
Do I need to install anything?
No. Fusion SQL runs in your browser. You do not need a database client, a VPN or any changes in Fusion beyond a one-time data model (see below).
What permissions does my Fusion user need?
The first time an environment is used, the user needs write access to the BI Publisher folder /Custom/FusionSQLTool (for example a BI Author or BI Administrator role) so Fusion SQL can create its query data model once. After that, any user who can run that data model can query.
Can I use it if I sign in to Fusion with SSO only?
Not yet. Fusion SQL needs a Fusion username and password to call BI Publisher. Ask your Fusion administrator for a user that can sign in with a password.
Can Fusion SQL change data in Fusion?
No. Only SELECT and WITH statements are accepted, and they run through BI Publisher, which is read-only.
Does it respect Fusion data security?
Queries run as the BI Publisher database user, so application-level row security (business units, inventory organizations and so on) does not apply. Follow your company data policies and only query data you are allowed to see.
How is my Fusion password protected?
If you choose to save it, it is encrypted with AES-256-GCM on the server. If not, it is kept in server memory for your current session only and cleared when you sign out.
What are the limits?
Up to 50,000 rows and 1,000,000 cells per query, 3 concurrent queries per user and a 300-second timeout. Exports are available for 15 minutes after a query finishes.
Is Fusion SQL affiliated with Oracle?
No. Fusion SQL is an independent tool and is not affiliated with, endorsed or sponsored by Oracle.
Run your first Fusion query in three minutes
Free to start. No installation. No BI Publisher report to build.