Friday, May 31, 2013

[OBIEE 10g] Multiple Connection Pools


OBIEE Multiple connection pools

Most BI-Server setups use shared connections to the database. But if we "generalize" the connection users we can see several groups: 

  • Reportbuilders; needs access to all tables, can transport a lot of data during development, are in the habit of "killing" query's when they "take to long"
  • Answers users: create there own "new" request each time.
  • Dashboard users: Only use predefined query's
  • BI-publisher: Can do a lot of query's in succession.
  • WriteBack users: need insert/update rights on the DB.

The help the DBA ask him for five users named: OBIEE_R (Reportbuilders), OBIEE_A (Answers_users), OBIEE_D (Dashboard users), OBIEE_B (BI-Publisher) , OBIEE_W (WriteBack Users).

In your RPD create five connection pools:

Create five Groups:

Now set the permissions for the Connection Pool:

Don't forget to disable "Everyone".

Assign the users to there groups and check in TOAD or SQL Developer if the right connections are made:

This way you can ask your DBA to assign the right resources to every group instead of an average setting for every one.

No comments:

Post a Comment