• Post category:BI Publisher
  • Post comments:0 Comments
  • Post last modified:February 8, 2021
  • Reading time:5 mins read
You are currently viewing DataFusing FREE Cloud based SQL Developer like tool for Oracle Cloud
DataFusing FREE Cloud based SQL Developer like tool for Oracle Cloud

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.

We have earlier posted on similar tool. Check the previous post here. However that tool doesn’t work 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.

image 14 1024x337 1 - DataFusing FREE Cloud based SQL Developer like tool for Oracle Cloud

Here are the main features of this tool:

image 15 1024x496 - DataFusing 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

image 16 1024x558 - DataFusing 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:

image 17 1024x325 - DataFusing 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.

image 18 - DataFusing FREE Cloud based SQL Developer like tool for Oracle Cloud
image 19 1024x329 - DataFusing 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.