I am trying to create a json file for listing the connection pools, since this should be a solution for my issue that after importinstanceservice my connectionpool data has "Replace me" values. I found this guide online which contained a script to do so. But since I'm pretty new to OBIEE and Oracle in general I can't seem to figure out what to fill in in the different field. Where do I find this uid? What's parentName (Is this the name of database in the rpd?) and so on. Has anyone already done this and can help me guide through this?
Thanks!
File connPoolList.json content:
{
"Title":"List Connection Pools",
"Conn-Pool-Info":[
{
"uid":"<uid1>",
"connPool":"<conn pool name1>",
"parentName":"<parent name1>",
"user":"<username1>",
"password":"<password1>",
"dataSource":"<data Source value1>",
"appServerName":"<app server name1>"
},
{
"uid":"<uid2>",
"connPool":"<conn pool name2>",
"parentName":"<parent name2>",
"user":"<username2>",
"password":"<password2>",
"dataSource":"<data Source value2>",
"appServerName":"<app server name2>"
}
],
"Variables-In-Conn-Pool":[
{
"uid":"<uid1>",
"variable":"<VARNAME1>",
"value":"'<VALUE1>'"
},
{
"uid":"<uid2>",
"variable":"<VARNAME2>",
"value":"'<VALUE2>'"
}
]
}
If you've configured your Connection Pools, and then use listConnectionPool
, you'll see what values you need to supply and which can be left as is.
BTW this article will probably help you.