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

361
Views
16
Comments
2»

Comments

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

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

  • 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? :)

  • 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

  • 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

Welcome!

It looks like you're new here. Sign in or register to get started.