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. This 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
| Feature | CloudSQL | BI Publisher Connect |
| User Interface | Rich SQL editor with syntax highlighting, formatting, and auto-completion | Basic text editor |
| Connection | Uses Oracle Fusion credentials with full role-based security | Uses Oracle Fusion credentials |
| SQL Execution | Single-click data retrieval | Requires full BI report creation, more time-consuming |
| Result Analysis | Interactive result grid with search, sort, and filter | Must export to external tools for analysis |
| Database Structure Lookup | Built-in database browser | Requires switching back and forth to Oracle documentation |
| SQL Error Analysis | Smart error analysis with AI-assisted fixes | Only basic error messages provided |
| Code Management | SQL history saved automatically, with options to search and reuse | No built-in code management |
| Price | $20/month subscription | Included in Oracle Fusion subscription |
Common Issues & Troubleshooting
Large Data Set Query Errors
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 Access Issues
To run a single SQL query in BI Publisher, users must be granted BI Publisher Developer access. This can be risky in production, as third-party users may gain the ability to modify data models, effectively bypassing established release controls.
Instead of granting full BI Developer access, CloudSQL provides a shared credential mode, where users can securely use an encrypted connection file. This allows them to run queries safely without direct access to the full Oracle Fusion environment.
Also Read: Running your First SQL with CloudSQL
Use Cases & Persona Fit
BI Report Developers
Report developers frequently create custom BI reports, which involves running partially developed SQLs hundreds of times over several days. Doing this in BI Publisher is slow and cumbersome. CloudSQL makes this process faster and smoother with one-click execution and quick corrections.
ERP Administrators & Support Consultants
ERP administrators are often responsible for troubleshooting issues across Oracle Support, in-house IT, and third-party service providers. With CloudSQL, they can extract and validate data quickly, significantly speeding up root-cause analysis and resolution.
Independent IT Contractors
Independent contractors play a key role in Oracle implementations and ongoing support, handling both technical and functional tasks. They need fast, reliable access to data for development, configuration checks, and reconciliation. CloudSQL boosts its productivity with instant query execution and easy data analysis.
Oracle Integration Developers
Integration developers (using Oracle Integration Cloud or other tools) rely on SQL for building outbound integrations, validating inbound data, and extracting lookup tables. CloudSQL enables rapid SQL development and seamless data extraction to support integration projects.
Data Migration Consultants
Data migration work requires frequent SQL runs for reconciliation, lookup, and configuration data extraction. CloudSQL streamlines these tasks, allowing consultants to build and execute SQLs quickly and efficiently.
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.
