Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

Initialization blocks in OAC

Received Response
62
Views
5
Comments
Shyam Bobburu
Shyam Bobburu Rank 2 - Community Beginner
in Oracle Analytics Cloud and Server

Summary

OAC capability for custom table authentication using Init blocks.

Content

Hi All,

We are yet to start upgrading from OBIEE 11.1.1.9 to OAC.

In OBIEE 11.1.1.9, currently customer using external table for additional row level security. This was implemented using Init blocks. 

This is very critical requirement and the same functionality should be followed in Oracle Analytics Cloud. I 'am not sure how we can achieve this in OAC.

Really appreciate your responses. Thank you for your help in advance.

Regards,

Shyam

 

 

 

 

Version

OAC Enterprise Edition - 18.3.3-122

Tagged:

Answers

  • Aman Jain-Oracle
    Aman Jain-Oracle Rank 5 - Community Champion

    Hey Shyam,

    The same init blocks can be replicated in OAC RPD as well to implement the row level security.

    Let me know if you need any further clarifications.

     

    Regards,

    Aman Jain

  • Shyam Bobburu
    Shyam Bobburu Rank 2 - Community Beginner

    Thanks Aman.

    Can you please provide steps/documents to implement this scenario in OAC?

    As I mentioned in my post, current system is using external table authentication for row level security.

    Thanks again,

    Shyam

     

  • [Deleted User]
    [Deleted User] Rank 7 - Analytics Coach

    Exactly the same way as in on-premises OBI. You put the table into a database your RPD can access and that's it.

  • Shyam Bobburu
    Shyam Bobburu Rank 2 - Community Beginner

    Thanks Christian.

    This is a hybrid implementation. Connecting OAC to on-premise DB. Row level security still works with Init blocks using custom table for authorization?  Please provide your comments.

     

  • Doug Ross
    Doug Ross Rank 6 - Analytics Lead

    If the custom table is referenced by an init block and that custom table is in an on-premise database, then the physical connection used by the init block will need to have the proper Remote Data Connector configuration referencing the Java Data Source in your on-premise Weblogic Server.  

    If the init block is just accessing that table and populating session variables to use in the row level filtering, then as long as the physical connection via RDC works, it should work fine.