OBIEE - Connection Script

Bi Server Architecture With Client

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

Examples

Execute on (connect|disconnect)

insert into login_table(:user,sysdate)

Obiee Connexion Alter Nls Date Format

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

Obiee Connection Script Value Of





Discover More
Obiee Database Cast Feature
OBIEE - Cast as date - Which date format to use ?

When you use the cast function to transform a character data type as a date, you may struggle with the date format that you have to give in a formula column because it depends of the configuration. ...
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...
Obiee Session Variable In Connection Pool
OBIEE - Where can I use a BI Server variable (session/repository) ?

When you have create a server variable, you have to reference it. You can use them : in BI Server in BI Presentation Service in Delivers in a logical sql statement through a client connexion....



Share this page:
Follow us:
Task Runner