Oracle Transactional Business Intelligence

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

What application do you use to write your SQL

375
Views
16
Comments
2»

Comments

  • Wade Wilson
    Wade Wilson Rank 4 - Community Specialist

    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
    Eric Geddes Rank 3 - Community Apprentice

    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
    Wade Wilson Rank 4 - Community Specialist

    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.

    sublime.png

  • Dan Bedson
    Dan Bedson Rank 1 - Community Starter

    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
    MaartenDIF Rank 4 - Community Specialist

    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
    MaartenDIF Rank 4 - Community Specialist

    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