Categories
What application do you use to write your SQL
Comments
-
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.
0 -
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
0 -
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.
0 -
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?
0 -
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,
Maarten0 -
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,
Maarten0