This is one of the most common questions developers ask when they start working with Oracle Cloud: Can they use SQL Developer with Oracle Fusion?
Unfortunately, the answer is no.
Oracle doesn’t provide direct database access like it does in traditional systems. You won’t get TNS details or a connection string to plug into SQL Developer, Toad, or any other traditional SQL client. The reason is simple: Oracle wants to protect the integrity of the data. Allowing direct changes could potentially disrupt the application, so all updates must go through the user interface or Oracle’s supported APIs.
But What About Running SELECT Queries?
Good question!
Yes, Oracle does allow read-only access through its BI (Business Intelligence) layer. This means you can still query data using SELECT statements—but it’s not as straightforward as using a normal SQL tool.
We’ve explained the step-by-step process in this blog post if you’d like to try it the official way.
A Better Option: Use CloudSQL
If you’re just looking to run ad hoc queries without the hassle of creating reports and data models every time, there’s a much easier way.
Meet CloudSQL by DataFusing
CloudSQL is a lightweight SQL editor designed specifically for Oracle Fusion users. It gives you a familiar, SQL Developer-style interface to run queries—without needing any special access or complex setup.
Here’s what makes it great:
- ✅ Connect using your Oracle Fusion username and password
- ✅ No installation required—just download, unzip, and run
- ✅ Works from your own network
- ✅ Clean, easy-to-use SQL editor interface
- ✅ Run SELECT queries instantly without building reports
It’s perfect for developers and analysts who want to quickly explore data in Oracle Fusion without jumping through hoops.
Final Thoughts
You won’t get TNS details or a Toad Oracle Fusion connection string—Oracle simply doesn’t allow it through traditional SQL clients. With tools like CloudSQL, you get the simplicity of a SQL editor with the security Oracle requires.
Give it a try and see how much easier working with Oracle Fusion Cloud can be!
