OBIEE - How to define one different database credential for each user (the shared logon) ?

Bi Server Architecture With Client


For system architecture reasons, you may want to have one database credential by user.

Example :

  • When one schema (of one user) is the logical entity of one company, you may decide to have the same table in two different schema but with the data for only one company

How to do

To achieve it, you have to unmark the check box “Shared Logon” of the connection pool property in the physical layer. You can remark that the user and password box become gray.

Obiee Connection Pool Shared Logon

Now, the Obiee users don't share no the same credential and you have to define for each Obiee user, one credential (one username, one password).

To define the new credentials :

Obiee Logon By User

The importance of disabling the cache

If the user don't share the same data, you have to disable the query cache by setting NO on the Obiee Bi Server Application Cache Parameters parameter in the cache section of the file Nqsconfig

If you don't disable the query cache, Obiee will perform an hit cache and retrieve the data from its cache as you can see in the log :

Obiee Bi Server Cache No Shared Logon

Discover More
Obiee Connection Pool
OBIEE - Connection Pool

This articles regroups all the articles and talk the connection pool features of the BI Server such as: the connection script tab ... see below 10G 11G To automate connection pool changes...
Obi Edition
OBIEE - Security

To determines who has the ability to view data and objects, you can combine several parameters configuration on different security levels: Object Security: business logic security (repository) and catalog...
Obiee Agent Cache Seeding
OBIS 10G/11G - BI Server (Logical Query|Result) Cache

Query caching is a persistent cache mechanism. When you ask for data with a query, the data are retrieved from the cache instead to ask again the data source. The BI Server Query Cache The Presentation...

Share this page:
Follow us:
Task Runner