Thursday, 11 October 2012

Execute Direct SQL (Direct Database Request) feature in OBIEE

The Direct Database Request permits you to perform SQL statement directly to a data source. The Oracle BI Server sends unprocessed, user-entered, physical SQL directly to an underlying database. The returned results set can be rendered in Oracle BI Presentation Services, and then charted, rendered in a dashboard and treated as an Oracle BI request.The Execute Direct SQL (Direct Database Request) feature is seen in Answers page.Under the Subject Area.
 
Direct Database Request
In Answers with the help of this feature Administrator can debug some issues like….
  1. Check physical connectivity to the database.
  2. Check report or dashboard performance (Performance Tuning)
Mostly this feature is not allowed or not considered as a good practice to Production users. The reasons are
  1. User can by-pass a data level security defined in the repository.
  2. They can overload  production database
  3. Users can delete some important database object.
  4. They can see some other tables which they are not permitted to see.

We can disable” Execute Direct SQL” by following the path below:
Answers > Settings > Administration > Manage Privilege.



2 comments:

  1. What are the uses of Direct Database Request ?
    Does this otion affects the OBIEE performance ?

    Please reply back soon...

    Thanks
    Jagadeesh

    ReplyDelete
  2. I really appreciate information shared above. It’s of great help. If someone want to learn Online (Virtual) instructor lead live training in IBM Cognos Transformer Design OLAP Models (v10.2.2) - SPVC (J2A82G-SPVC)
    , kindly contact us http://www.maxmunus.com/contact
    MaxMunus Offer World Class Virtual Instructor led training on in IBM Cognos Transformer Design OLAP Models (v10.2.2) - SPVC (J2A82G-SPVC). We have industry expert trainer. We provide Training Material and Software Support. MaxMunus has successfully conducted 100000+ trainings in India, USA, UK, Australlia, Switzerland, Qatar, Saudi Arabia, Bangladesh, Bahrain and UAE etc.
    For Demo Contact us:
    Name : Arunkumar U
    Email : arun@maxmunus.com
    Skype id: training_maxmunus
    Contact No.-+91-9738507310
    Company Website –http://www.maxmunus.com


    ReplyDelete

Related Posts Plugin for WordPress, Blogger...

ShareThis