Oracle Transactional Business Intelligence Idea Lab

Home› Oracle Analytics› Oracle Analytics Idea Labs› More Solutions Idea Labs› Oracle Transactional Business Intelligence Idea Lab

Categories

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

Feasibility of having SQL Developer Connection to Oracle HCM Cloud Enviornment

Submitted
673
Views
43
Comments
245

Comments

  • rob1604
    rob1604 Rank 2 - Community Beginner

    This functionality would be extremeley useful for both us and our clients. Current development and issue resolution SQL requirements result in inefficiencies.

  • rob1604
    rob1604 Rank 2 - Community Beginner

    current development functionality is inadequate, and resolving issues for clients is inefficient

  • A J-113800
    A J-113800 Rank 1 - Community Starter

    Have been using SQLConnect (www.oraclecloudtools.com/downloads) for quite some time now. It was recommended by a friend. It saves a lot of time when it comes to running Adhoc query and doing data analysis across various pods. I was told it used standard Oracle BI APIs.

  • Claudio Civati
    Claudio Civati Rank 2 - Community Beginner

    Hi all,

    I think that granting access in read-only from tool like SQL Developer would really be helpful!

    Thanks,

    Claudio

  • Anoop Sukumaran
    Anoop Sukumaran Rank 1 - Community Starter

    Hi all,

    This would be life saving feature and would save a lot of effort during the build phase.

    Thanks,

    Anoop

  • User_P0X4I
    User_P0X4I Rank 1 - Community Starter

    Hi Everyone,

    Yes, the current data model for the BI publisher is not efficient at all and that would be great if Oracle offers this option of connecting to HCM through SQL developer.

    Thanks,

  • rob1604
    rob1604 Rank 2 - Community Beginner

    This functionality would enable issue resolution, and would reduce the need to raise SR's with MOS.

  • Community DW Integration
    Community DW Integration Admin

    Being able to use tools like "Oracle SQL Developer" or "Toad for Oracle" in read-only mode with the Cloud would be a very good improvement. Not only for HCM Cloud, but also for ERP Cloud. Using the current functionality (BI Publisher and Data Model) to create SQL queries is painful and not efficient.

  • Bruno Meunier
    Bruno Meunier Rank 1 - Community Starter

    I am totally agree with the fact than creating Data Model and have to create report to export the result of the script to Excel is not an efficient way.

    We lose a lot of time each time we have to analyse some transaction in error or need specific informations.

  • Wim Bos [MLE]
    Wim Bos [MLE] Rank 3 - Community Apprentice

    Definitely needed, we fully support this idea yes