Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 215 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Cache sharing for dedicated users in OBIEE 12c
I need to use dedicated usernames in OBIEE connection pool (no single technical user can be used as per requirement). At the same time, I have enabled BI Server cache and would like to share cache entries between users (in case somebody runs a specific query in the morning and there's another person that runs same/similar query later, the results from previous query would be used). Underlying database is non-Oracle database.
Shared logon option does not help here since in connection pool properties, username and password are specified as values taken from nqsession.
Therefore the question is if it's possible to use dedicated usernames and still share BI Server cache between them (even if it requires some workaround)?
This is in context of OBIEE 12c.
Regards, Luke