Oracle Analytics Cloud and Server

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

variabilize DSN in connection pool

Received Response
1
Views
2
Comments
Rank 6 - Analytics Lead

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

  • Rank 8 - Analytics Strategist

    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

  • Rank 6 - Analytics Lead

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

    Hope this helps.

Welcome!

It looks like you're new here. Sign in or register to get started.