Connecting to any database from SQL Editors such as Toad, SQL Developer require the ability to use a SQL*Net connection. Since Oracle Fusion Cloud does not allow this type of connection, it is not possible to use SQL Developer, Toad, or similar tools to connect to Oracle Fusion database.
Instead, Oracle recommends using BI Publisher to run queries against the Fusion Applications database. While this works, it can feel limiting for users who are accustomed to the flexibility of direct SQL tools.
CloudSQL Desktop bridges this gap by securely using BI Publisher’s SaaS APIs behind the scenes, enabling you to write and execute SQL queries against your Fusion ERP data without breaking Oracle’s access rules.
Why SQL Developer & TOAD Won’t Connect by Default?
Traditional tools like SQL Developer, TOAD, or standard JDBC clients rely on a SQL*Net connection to access a database. In the case of Oracle Fusion SaaS, these direct SQL*Net connections are intentionally disabled for security and multi-tenant architecture reasons.
This means you cannot simply point SQL Developer or TOAD at your Fusion database and start running queries. Oracle’s official guidance is to use BI Publisher as the supported interface to connect to Oracle Fusion database and query Fusion data.
CloudSQL Desktop leverages BI Publisher’s SaaS APIs to provide secure, SQL-based access to Fusion ER, offering the flexibility of direct querying without bypassing Oracle’s security model.
Solutions for Connecting to Fusion Database
BI Publisher (Native Method)

The most common and Oracle-supported approach is to use BI Publisher in Oracle Fusion. You create a data model and a corresponding report to extract the required data in your preferred output format (CSV, Excel, XML, etc.).
While reliable, this method can feel cumbersome for those who prefer ad-hoc SQL querying. For a detailed guide, see how to create a BI Publisher report in Oracle Fusion
This method allows you to connect to Oracle Fusion database safely, but the process is time-consuming for developers handling multiple reports.
CloudSQL (Enhanced Approach)

CloudSQL for Oracle Fusion provides an SQL Editor that securely connects to Fusion ERP through the BI layer, giving the appearance of a direct SQL connection for all practical purposes. It eliminates the need for SQL*Net connections while still allowing you to write and execute SQL queries directly.
It integrates seamlessly for BI developers and supports both SSO and shared credential workflows, making collaboration faster and more efficient for teams. If you are just getting started, check out this guide on running your first SQL with CloudSQL.
For anyone looking to connect to Oracle Fusion database more efficiently, CloudSQL offers the best balance of security, speed, and usability.
Other Third-Party Tools
Some tools, such as SQLConnect, also integrate with BI Publisher or Fusion’s reporting APIs to enable SQL access. These can be useful alternatives, but capabilities and performance vary depending on the vendor’s implementation
These solutions also attempt to connect to Oracle Fusion database, though reliability depends on the tool provider.
Also Read: Oracle Fusion Ad Hoc Reporting Made Easy with CloudSQL
CloudSQL vs Direct BI Publisher Connect
CloudSQL vs. BI Publisher: Which Is Best for SQL Development?
Compare the tools for querying and analysing Oracle Fusion Cloud data.
| Feature | CloudSQL Desktop SQL Editor | BI Publisher |
|---|---|---|
| SQL editing | Purpose-built SQL workspace Syntax highlighting, formatting and autocomplete for writing and refining queries in a dedicated editor. | Limited SQL editing window The small SQL editing area can make longer queries cumbersome to develop. Developers often write SQL in external text editors such as Notepad++, then copy and paste it into BI Publisher. |
| Authentication & access | Oracle Fusion authentication Access depends on your Oracle account, assigned roles and privileges. | Oracle Fusion authentication Access depends on your account, roles and report permissions. |
| Running SQL | Single-click execution Run queries directly from the editor and review results without creating a full report for every query. |
A multi-step reporting workflow
|
| Result analysis | Interactive results grid Search, sort and filter returned records directly within the editor. | Export for further analysis Export results to Excel or CSV when you need to examine, filter or analyse data outside the report. |
| Database discovery | Built-in Database Browser Explore supported tables and columns within the application. | Separate reference lookup You may need to consult Oracle documentation separately to look up tables and columns. |
| SQL error assistance | AI-assisted error analysis Available AI features can help diagnose SQL errors and suggest fixes. | Standard error messages Troubleshooting generally relies on available error messages and manual diagnosis. |
| SQL history & reuse | Built-in SQL history Find and reuse previously executed queries without having to maintain every version manually. | Manual version management There is no equivalent automatic SQL execution history in this workflow. Developers may need to save and manage different SQL versions locally. |
| Cost | $20 / month Subscription pricing starts at $20 per month. 30-day free trial | Included with Oracle Fusion BI Publisher availability and entitlements depend on your Oracle subscription. |
Spend less time managing queries. Focus on your SQL.
Explore a SQL editor built for Oracle Fusion developers, data migration consultants and technical teams.
Explore CloudSQL Desktop →Start your 30-day free trial and explore the current subscription options.
Common Issues & Troubleshooting
Large Data Set Query Error
When running queries on large data sets, users often encounter timeout errors or the message:
“Report data size of 524288000 bytes exceeds the maximum limit 524288000 bytes for online reports.”
CloudSQL mitigates this with background execution, allowing long-running queries to complete without interruption.
BI Publisher Security Violation
Oracle Fusion users may encounter an error such as:
Security violation: /Custom/CloudSQL, user: , permission: 16583
This can occur when the user does not have the necessary permissions to access the BI Publisher folder or resource required to execute SQL queries. Resolving the issue may require an administrator to review and update folder permissions.
How CloudSQL Helps? CloudSQL allows users to select their own accessible private BI Publisher folders for SQL execution, reducing dependency on shared-folder permissions and helping avoid this common issue.
Also Read: Running your First SQL with CloudSQL
Built for Oracle Fusion Professionals
From ad-hoc queries and support investigations to integrations, functional consulting and data migration, CloudSQL helps you work with Oracle Fusion data more efficiently.
BI Report Developers
You build custom BI reports and refine complex SQL queries. Testing partially developed queries can mean running them hundreds of times over several days.
The challenge
Repeatedly creating or navigating BI Publisher data models makes query development slow and cumbersome.
How CloudSQL helps
Execute SQL with one click, inspect results immediately and make quick corrections in a dedicated SQL editor.
Oracle Fusion Support Consultants
You investigate incidents across Oracle Support, internal IT teams and third-party service providers, often under pressure to identify the root cause quickly.
The challenge
Finding, extracting and validating the right data can delay investigation and resolution.
How CloudSQL helps
Retrieve and analyse accessible Oracle Fusion data quickly to support root-cause analysis and issue resolution.
Oracle Fusion Freelancers
You handle technical and functional work across Oracle implementations and ongoing support, often juggling multiple client requirements and deadlines.
The challenge
You need a reliable way to check configurations, reconcile data and investigate issues without unnecessary manual steps.
How CloudSQL helps
Run queries quickly and use the results grid to search, sort and filter data during consulting assignments.
Oracle Integration Developers
You build integrations with Oracle Integration Cloud and other platforms, using SQL to validate data, extract lookup tables and support integration workflows.
The challenge
Integration testing often requires repeated data checks and quick access to source information.
How CloudSQL helps
Develop and execute SQL quickly, extract accessible data and validate integration results more efficiently.
Data Migration Consultants
You extract configuration and business data, reconcile source and target records, and investigate discrepancies throughout Oracle Fusion migration projects.
The challenge
Frequent query execution and repeated validation can consume valuable time during migration cycles.
How CloudSQL helps
Build and rerun queries efficiently, then inspect results to support reconciliation and data validation.
Oracle Functional Consultants
You configure Oracle Fusion modules, investigate business process issues and support users across functional areas. You often need to validate transactions and verify configuration data to understand what’s happening.
The challenge
Getting the right data to investigate functional issues, validate configurations and reconcile transactions can require repeated requests to technical teams.
How CloudSQL helps
Run SQL queries to inspect accessible Oracle Fusion data, validate transactions and investigate functional issues more independently, reducing reliance on repeated data-extraction requests.
Make Oracle Fusion SQL Development Easier
Whether you build reports, troubleshoot ERP issues, develop integrations, support functional teams or migrate data, CloudSQL gives you a dedicated environment for writing and executing SQL. Spend less time managing queries and more time getting work done.
Explore CloudSQL Desktop →Frequently Asked Questions (FAQs)
Why can’t I use SQL Developer to connect to Fusion ERP?
SQL Developer requires a SQLNet connection to access a database. Since Oracle Fusion SaaS does not allow SQLNet connections, it is not possible to connect SQL Developer directly to a Fusion ERP database.
Do I need BI Publisher access to use CloudSQL?
Yes. CloudSQL uses Oracle’s role-based security model. To access BI Publisher through CloudSQL, you must have one of the following roles:
1. BI Administrator
2. BI Author
3. BI Consumer (with additional privileges)
Is there a way to grant business users SQL access safely?
Yes. CloudSQL supports a shared credential mode, where credentials are stored in an encrypted connection file that can only be used by the app. This lets business users run queries securely without exposing direct database access.
Can I easily view the structure of tables like PER_ALL_PEOPLE_F or AP_INVOICES_ALL?
Yes. CloudSQL includes a built-in database browser that allows you to explore table structures, columns, and key relationships without switching to external documentation.
Are long-running queries supported?
Yes. CloudSQL supports background execution, enabling long-running queries to complete without timing out.