Oracle Analytics Cloud and Server

variabilize DSN in connection pool

Received Response
1
Views
2
Comments
user12863665
user12863665 ✭✭✭✭✭

i am using 12_3 version of obiee. i would like to variabilize DSN info in connection pool. basically i don't want to change any connection details as part of migrations.everything should be in variables. can you please suggest me how can i variabilize DSN in connection pool.

Answers

  • Joel
    Joel ✭✭✭✭✭

    You’ll need to use the datamodel.sh/cmd script located in your DOMAIN_HOME/bitools/bin directory.
    First step is to use the listconnectionpools parameter to generate a json file which lists your connection pools.

    2nd step is to migrate your updated repository to this environment and finally to use the updateconnectiopools parameter of the data model.sh/cmd script to update the connection pools.

    The same process can be used to update repository variables.

    List rpd variables

    Update rpd variables

  • SonPat99
    SonPat99 ✭✭✭✭✭

    You can define Initialization Blocks (IB), use static Variables fro Connection Pools and then use these variables directly in RPD.

    Hope this helps.