Oracle Transactional Business Intelligence Idea Lab

Home› Oracle Analytics and AI› Oracle Analytics and AI 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

SQL select queries

Submitted
11
Views
2
Comments
Vaughn Hunt-23060
Vaughn Hunt-23060 Rank 2 - Community Beginner
edited May 8, 2025 10:33PM in Oracle Transactional Business Intelligence Idea Lab

Description

Enable Consultants to develop reports in another tool like SQL Developer

Use Case and Business Need

It would be a lot easier if the consultants had read only access to the database for report writing and quick selects. Especially when creating BI Publisher reports.

I know that this is a security risk, but is there no way around this problem?

Original Idea Number: 7988b6e38b

1
Up
1 votes

Submitted · Last Updated

Comments

  • Gail Langendorf-Oracle
    Gail Langendorf-Oracle Rank 5 - Community Champion

    Instead of read only access to the database, do you want to try using a SQL query within BIP that is based on an OBIE subject area? I'm not sure if that helps your particular situation. Here is a video.
    imagehttps://www.youtube.com/watch?v=K7JymaEzz18

  • Vaughn Hunt-23060
    Vaughn Hunt-23060 Rank 2 - Community Beginner

    Hi Gail

    Thanks for the comment.

    I know about this functionality. This request is purely from a convenience point of view.

    It is very tedious working with that small screen when you are testing multiple selects especially when running queries from the tables directly.

    As appose to SQL developer you can have multiple tabs open and you do not need to create a data set or Model every time you need to run a select.

     

     

    Regards

    Vaughn Hunt