• Post author:Sricharan
  • Post published:September 8, 2020
  • Post category:Others
  • Post comments:11 Comments
  • Post last modified:September 8, 2020
SQL Developer like Tool for Oracle Cloud – That too for FREE
SQL Developer like tool for Oracle Cloud – That too for FREE

 1,397 total views

In this article we will look into a standalone tool which can connect to the Oracle Cloud Instances and run SQL queries against them. I know most of you know that such tools are available on the market at some cost with advanced features.

This is not a paid post nor a promotion of any kind. I am going to share a FREE tool which can be downloaded and used by anyone. Of course it is still in nascent stages, but the developer is working on adding new features to it.

This tool (FusionSQLite) has been created by Anand Vamsi Krishna Vegaraju and he was kind enough to share it to everyone. You can reach out to him if you have any questions or want to say to thanks for this tool.

This is a third party tool and not a tool provided by Oracle. So do your due diligence before using it by reading through the documentation.

Download Link for Toolhttps://github.com/anandvegaraju/FusionSQLite

If you open this page, you will see the below info which will help you through the steps to use this tool.

Source Code
Fusion SQLite Steps

Click on the above link to download the executable file.

Once the file is downloaded, you can double click it to open the tool UI. This tool is like a portable software which doesn’t need any installation. If you don’t have admin access on your office laptop, even then you can use this tool as it doesn’t require installation.

This is how the tool UI will look like:

The UI looks self-explanatory..

We need to input the parameters like below:

POD URLhttps://abcd-dev.fa.us2.oraclecloud.com (Remember to include the https:// too and copy the POD link till oraclecloud.com)
Username – <Username> (Ensure you have the Human Capital Management Integration Specialist role)
Password – <Password of user>

After entering these parameters, click on “Initialize environment” which will import a catalog file to the POD using which the SQL Queries would be run from the tool. This is a one time activity for each POD that you use on this tool. You will get a successful message once the catalog file has been copied to the POD. The Catalog file will be copied to “/shared/Custom/Human Capital Management/FusionSQLtoolTest1” folder.

Click OK.

Now you are ready to run the SQL queries using this tool.

Let’s run a sample query..

select * from per_all_people_f where rownum < 10

If you click on Export to Excel option, you can get the data downloaded into the excel sheet. It will ask for a file name and will get saved to the folder in which the exe file is saved.

As seen above it’s very simple to use this tool. Anand Vamsi Krishna Vegaraju is working on adding additional features to this tool. Kudos to his efforts in building this and sharing it to the community for FREE.

Tip: Even though this tool works for bigger data, it might get struck for a while before showing results. It’s better to use the query with rownum condition to restrict the number of rows. Although this cannot be used as efficiently as SQL Developer tool, this is a good starting point to use for smaller queries.

Hope you like this article. You can reach out to Anand on LinkedIn @ https://www.linkedin.com/in/anand-vamsi-krishna-vegaraju-084718b7/

Join our fastest growing technology social groups to interact with experts in the Fusion space and get your queries resolved – Telegram group, Facebook Page and LinkedIn Group

Sricharan

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.

This Post Has 11 Comments

  1. Sricharan

    Hi Ricardo,

    I am not sure if it works with SSO. Can you check with original developer by reaching out to him on linkedin Anand Vamsi Krishna Vegaraju.

    Thanks,
    Sricharan

Leave a Reply