OBIEE - Connection Script

1 - 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

3 - Examples

3.1 - Execute on (connect|disconnect)


insert into login_table(:user,sysdate)

3.2 - Execute (before|after) query

You can call an autonomous function/store procedure.

3.3 - With variable

with a server variable

Setting a database session variable.


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


Data Science
Data Analysis
Statistics
Data Science
Linear Algebra Mathematics
Trigonometry

Powered by ComboStrap