What application do you use to write your SQL

Wade Wilson

I wrote a quick plugin for Sublime Text 3 (it will format and execute queries). So if anyone is using ST3 and has some Python 3 familiarity and wants to give it a go, I would be willing to share what I did.

Eric Geddes

I'm intrigued, Wade. Are you saying your plugin executes queries like this against the HCM cloud database from within Sublime?

SELECT
    paam.ASSIGNMENT_ID,
    paam.EFFECTIVE_START_DATE,
    paam.EFFECTIVE_END_DATE,
    paam.PERSON_ID
FROM FUSION.PER_ALL_ASSIGNMENTS_M paam

Wade Wilson

Hey Eric,

It does not execute queries directly against the database per se. But like the other tools that exist, it uses the BI web services to proxy the query through. I personally wouldn't recommend doing a large dataset like this query, but it will work. It just takes a while before returning data with this large of a dataset - I'm sure there could be efficiencies made to the code to make it faster. Screenshot included.

Dan Bedson

I use Notepad++ at the moment, but being able to run SQL from the text editor would really help - is this easy to configure in Sublime? I'm happy to download it (Windows) and run it as it'll save me loads of time over doing it in Notepad++, copying it to a data model and running. Are you able to share how you set it up? and is anyone else clever enough to build a Notepad++ plugin that does the same?

MaartenDIF

Hi Wade,

That looks quite neat. I don't have any Python experience but I can at least read some code. Would this be easy to set up?

I'd use this mostly to see whether my query even executes and if it does, get ~ 100-200 lines of data to see whether the data I've gotten makes any sense at all.
This solution would definitely beat opening up the browser and being forced to use a dummy data model (since Oracle removed direct queries a few patches ago).

Kind regards,
Maarten

MaartenDIF

Hi Matt,

Are you able to connect to the cloud application with SQL Developer? Or have you loaded the schemas manually?

Is there anything you can share on how you've set this up?

Kind regards,
Maarten