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