OBIEE - Connection Script

> Reporting and Data Access Tools > Oracle Business Intelligence (OBIEE/Siebel Analytics) > OBIEE - BI Server (OBIS|nqsserver|nqs)

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
Advertising

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)'