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

Bring back Direct Database Query

Submitted
707
Views
51
Comments
1356

Comments

  • Shyam Patel
    Shyam Patel Rank 2 - Community Beginner

    Hi Chandra,

    If Oracle insisting to using SQL query then remove the 200 Lines Limit as well.

    Regards
    Shyam

    Regards
    Shyam

  • Shyam Patel
    Shyam Patel Rank 2 - Community Beginner

    Must be needed as SQL query limit to 200 lines only and very clumsy. either provide direct database or SQL connectivity to SAAS Application.Hence Either Oracle Re-enable this(Direct DataBase) or Provide the MySQL connectivity for users for faster connectivity to the database

    if oracle is much worried about the "database hit" in the cloud they can put In-memory database systems (IMDS) to overcome this solution

    Regards
    Shyam

  • Jessica D'Apice
    Jessica D'Apice Rank 3 - Community Apprentice

    "creation of report is dependant on template size and user is restricted in extracting all the columns of the table with a large volume"

    This is our biggest issue with using the BI Publisher reports.

  • User_YB2Y6
    User_YB2Y6 Rank 1 - Community Starter

    This function shouldn't be removed at all, it is very important and very powerful tool as it covers missing columns and information in OTBI subject areas.

     

  • Nivya Mathire
    Nivya Mathire Rank 3 - Community Apprentice

    Agree..

  • Ravichandran Raju-80607
    Ravichandran Raju-80607 Rank 1 - Community Starter

    Agreed!

  • Rajeshwar Vuppala
    Rajeshwar Vuppala Rank 2 - Community Beginner

    We are using Direct Database Queries for FAH it is very very useful functionality, if Oracle product team is worries about the BI Server performance, the could add some restriction and not completely takeout the functinality

     

  • rianxavi
    rianxavi Rank 1 - Community Starter

    I agree! 

  • User_DWG1L
    User_DWG1L Rank 1 - Community Starter

    Agree!

  • User_Z8Y6M
    User_Z8Y6M Rank 3 - Community Apprentice

    I agree