Home / Guides

Ways to run SQL queries on Oracle Fusion Cloud, and which to use

You cannot connect a SQL client straight to the Fusion Cloud database, so every route to your data goes through a reporting or integration layer. This guide compares the main options and says when each one fits.

The short answer

Oracle does not generally expose the Fusion Cloud database to customers. To run SQL, the supported route is a BI Publisher data model with a SQL data set. Other routes, such as OTBI, BI Cloud Connector extracts and REST APIs, answer different needs and do not run table-level SQL the same way.

The options side by side

OptionWhat you writeBest forMain limits
BI Publisher data model (SQL data set)SQL against Fusion tables and viewsAd-hoc queries, reports, data checksRead-only (SELECT). Slow edit-run loop in the browser. Needs BI Publisher access
OTBI analysesDrag-and-drop, or logical SQL over subject areasBusiness reporting without SQLWorks on subject areas, not on the physical tables and views
BI Cloud Connector (BICC) extractsChoose view objects to extract to filesBulk loads into a data warehouseScheduled file extracts, not interactive queries
REST APIsHTTP requestsIntegrations and transactionsNot SQL. Returns business objects, not table rows
Developer tools that use the BI Publisher report serviceSQL in an editorFaster interactive SQL developmentSame read-only SQL and the same privileges as your account

Which one should you use?

Why the browser route is slow

With a BI Publisher data model you paste SQL into a data set, save, run the report and open the output, then repeat for every change. There is no autocomplete, so people keep a tables reference open in another tab. How to run SQL against Oracle Fusion from VS Code shows how a developer tool shortens that loop.

What does not change with any tool

Read Fusion SQL security and privileges before choosing a tool that handles your credentials.

Frequently asked questions

Can I connect SQL Developer directly to Oracle Fusion Cloud?

Oracle does not generally expose the Fusion Cloud database to customers. The supported routes are reporting and integration services, such as BI Publisher, BI Cloud Connector and REST APIs.

Can I run INSERT, UPDATE or DELETE on Fusion tables?

No. SQL in a BI Publisher data set is for reading data. Change data through the application, supported APIs or file-based loaders.

What is the difference between OTBI and BI Publisher SQL?

OTBI works over subject areas and uses logical SQL. A BI Publisher data model with a SQL data set queries physical Fusion tables and views directly.

Is FuiSQL the only tool that does this?

No. Other third-party tools also run SQL through BI Publisher. This guide describes the options by category, and FuiSQL is one example of a developer tool.

Run SQL against Fusion from VS Code. FuiSQL has a free trial.

See FuiSQL   Get it from the VS Code Marketplace

Related guides

FuiSQL is an independent product by FuiSQL. Oracle and Fusion are trademarks of Oracle and/or its affiliates; FuiSQL is not affiliated with, endorsed by or sponsored by Oracle.