OBIEE - Connection Script

About

The connection pool of the physical layer gives the possibility in the Connection Script tab to execute a command script:

• on connect
• before query
• after query
• on disconnect

Articles Related

Examples

Execute on (connect|disconnect)

insert into login_table(:user,sysdate)

Execute (before|after) query

You can call an autonomous function/store procedure.

With variable

with a server variable

Setting a database session variable.

SET SESSION 'APPLICATIONUSER' = 'VALUEOF(NQ_SESSION.USER)'