FREE Cloud based SQL Developer like tool for Oracle Cloud
FREE Cloud based SQL Developer like tool for Oracle Cloud
FREE Cloud based SQL Developer like tool for Oracle Cloud
Total Visits: 38
Todays Visits: 8

In this article we will look into a SQL Developer like tool for Oracle Cloud. We have already seen a similar tool earlier but it doesn’t work post 20D update as REFCURSORS are not supported by Oracle post 20D.

Oracle has released a notification earlier that REFCURSORs are not supported post 20D and most of the tools that were designed earlier using REFCURSORS stopped working or the developers will have to devise an alternative.

Here I come up with another FREE cloud based SQL developer like tool which works post 20D as well. They have designed this tool without REFCURSORS so this tool works post 20D. I have tested this myself to confirm that and here is the genuine review of the tool.

I also got a chance to talk to their Technical Architect/Director Binuraj Nair who was very supportive and provided the background of this tool, its functionality and their roadmap for future.

The tool is called Cloud SQL by DataFusing and you can access the tool here – Cloud SQL

It’s a cloud based tool hosted on Oracle Cloud Infrastructure(OCI) and they have plans in next year to create an offline version of the tool. DataFusing has created this tool for internal purpose and they are giving back to community by making it free for everyone which is echoed in the message on their website.

FREE Cloud based SQL Developer like tool for Oracle Cloud

Here are the main features of this tool:

FREE Cloud based SQL Developer like tool for Oracle Cloud

On the security front also they aren’t storing any credentials on their database and all the SQL run requests are passed using collections and doesn’t hit their database at all.

Here is their FAQ section

FREE Cloud based SQL Developer like tool for Oracle Cloud

DataFusing team is working on adding additional functionality to this tool.

As the password isn’t stored on their database, we will have to enter the password everytime we login to their system or everytime the session expires.

Here is how the UI of the tool looks like:

FREE Cloud based SQL Developer like tool for Oracle Cloud

They have also included a public library with the sample SQL queries for some objects.

FREE Cloud based SQL Developer like tool for Oracle Cloud
FREE Cloud based SQL Developer like tool for Oracle Cloud

We can also add the frequently used queries to our library which is specific to the logged in user. We also have option to contribute to the public library.

Overall I feel this tool can be used to run ad-hoc queries. It would have been better if it was an offline tool which I have also provided as feedback to their team. And they replied in positive tone of taking it up in the near future.

This is my genuine review of this tool and not to be considered as a promotion of any sort. Please do your due diligence before using this tool.

Sricharan Monigari
Sricharan is a Fusion HCM Solution Architect with over 13+ years of overall experience and 5+ years of Fusion experience. He is passionate about technical aspects of Fusion HCM and writes interesting articles on HCM Extracts, HCM Data Loader, Fast Formula, BI Publisher, Integrations and Automation etc.
Sricharan Monigari
Sricharan Monigari

Leave a Reply