• Post category:Others
  • Post comments:11 Comments
  • Post last modified:January 22, 2021
  • Reading time:3 mins read
SQL Developer like Tool for Oracle Cloud, That too for FREE
SQL Developer like Tool for Oracle Cloud, That too for FREE
SQL Developer like Tool for Oracle Cloud, That too for FREE
Total Visits: 15
Todays Visits: 0

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.

SQL Developer like Tool for Oracle Cloud, That too for FREE
Source Code
SQL Developer like Tool for Oracle Cloud, That too for FREE
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:

SQL Developer like Tool for Oracle Cloud, That too for FREE

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>

SQL Developer like Tool for Oracle Cloud, That too for FREE

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.

SQL Developer like Tool for Oracle Cloud, That too for FREE

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

SQL Developer like Tool for Oracle Cloud, That too for FREE

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.

SQL Developer like Tool for Oracle Cloud, That too for FREE

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 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

This Post Has 11 Comments

  1. Suresh

    This is useful. In this tool we cant keep multiple queries and run one after one like SQL developer by keeping ; for each query.

  2. Sricharan

    Yes Suresh. Anand is working on enhancing this tool. For something you get for FREE, you should not complain unless it doesn’t work at all or you have a better alternative. You can provide your feedback to the developer on Linkedin page.

  3. Vijay Shah

    Suresh, You can use SQLConnect (Download for FREE from http://www.oraclecloudtools.com) for running multiple queries, and using Multiple Pods at the same time. It has a lot more features, and ofcourse that is why its a paid tool ($9.99 / month).

  4. Vamsi

    I am getting below error for PROD, can you help?

    oracle.xdo.webservice.exception.OperationFailedException: PublicReportService::generateReport failed: user: xxx.yyy does not have permission to run the report: /Custom/Human Capital Management/FusionSQLtoolTest1/FSTreport.xdo

  5. Charan Teja

    Hi
    I am getting the below error. Can you please help?

    oracle.xdo.webservice.exception.OperationFailedException: PublicReportService::generateReport for reportAbsolutePath [/Custom/Human Capital Management/FusionSQLtoolTest1/FSTreport.xdo] failed: due to oracle.xdo.server.ServerException: oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.XDOException: SQLInjection Error: Invalid parameter value SELECT *
    FROM per_all_people_f
    WHERE ROWNUM < 10

  6. Sricharan

    Hi Charan,
    Looks like an issue with the POD related to some permissions.. Check other POD.
    Thanks,
    Sricharan

  7. Sricharan

    Hi Vamshi,
    Looks like a permissions issue. Check other POD or try using some super user.
    Thanks,
    Sricharan

  8. Shwe

    Hi, Thanks for the tool. The tools disappears as soon as I click on “Initialize environment”. Please advise.

  9. Sricharan

    Hi Swetha,
    try to input the url like “https://abcd-dev.fa.us2.oraclecloud.com”.. if you use “https://abcd-dev.login.us2.oraclecloud.com” then the window is getting closed..
    Thanks,
    Sricharan

  10. Ricardo

    Hi,

    is this tools works when you have SSO configured? I did everything explained here and the tool closes when I cllick on “Initialize enviroment”. By the way, I´m using a user with admin roles.

    Regards,

    Ricardo

  11. 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