Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Needs expert opinion -- RPD

Received Response
21
Views
3
Comments
Rai Qaiser Hussain
Rai Qaiser Hussain Rank 5 - Community Champion
edited August 13 in Oracle Analytics Cloud and Server

Hi All

I am working in hospital where 4 major domains

  1. Financial
  2. Administration
  3. Treatment
  4. Diagnostic

I have created on connection pool in RPD for financial and developed some objects suchas analysis, KPI, dashboards etc, now I have some requirements in other domains too, what is recommendation either I should add dimensions / facts in existing connection pool or create new connection pool for every domain.

Answers

  • Teresa Modesta
    Teresa Modesta Rank 5 - Community Champion

    Connection pools are more data source than logical areas.

    Other than writeback I would not see the need to duplicate a connection pool once it is set up.

  • Joel
    Joel Rank 8 - Analytics Strategist

    Additionally, you only need a single connection pool to a single data source so if all 4 domains are all from the same data source, then a single connection pool is sufficient. You may have a scenario where you may need separate connection pools even if the domains are from the same source if there are some security requirements which apply to a specific domain

  • Teresa Modesta
    Teresa Modesta Rank 5 - Community Champion

    Yes - I did have second thoughts and actually came back to append that you might need to apply a different security model for row level security or similar - though in those cases I have seen the requirement be so extreme that the only option is to duplicate the business model / presentation layer.