Uploads the RPD to a target environment, then updates connection pool information using provided JSON file, which is done by invoking updateconnectionpool command. Property replacement is done on JSON file, which will allow you to update environment specific information in JSON file at update time. This operation is slightly different than rpdDeploy, as it uploads RPD file first as is and then performs connection pool update and is only supported for OBIEE 12c.
Environment/Instance Properties
...
Inputs
| | | |
---|
Connection Pool JSON File | FDOBIEE_INP_CONN_POOL_JSON_FILE | No | You can create connection pool JSON file using link, use datamodel.sh listconnectionpool command. See example below. We are using -V true to get variables as well, look for exported file in /var/tmp folder for this example. Update location of datamodel.sh as per your installation. See oracle document Doc ID 2227845.1 for reference. Code Block |
---|
language | bash |
---|
theme | RDark |
---|
title | Example for listconnectionpool |
---|
| cd /oracle/Middleware/Oracle_Home/user_projects/domains/bi01/bitools/bin
./datamodel.sh listConnectionpool -SI ssi -U weblogic -P welcome1 -V true -O /var/tmp/connectionpool.json |
FlexDeploy will perform property replacement on this file, so you can use ${{...}} notation to replace environment specific values. JSON file can be absolute path or relative to artifacts folder. If you are using config file from temp folder, then use FD_TEMP_DIR variable to indicate absolute path (using groovy expression for input). You can either - Save JSON file during build operation as artifact, or
- Extract it from SCM during deploy workflow or
- Use absolute path to location on server. (not recommended as it requires manual setup on server)
Code Block |
---|
| {
"Title": "List Connection Pools",
"Conn-Pool-Info": [
{
"uid": "215297b0-0c83-1000-8029-0a0a0b690000",
"connPool":"BSC",
"parentName":"\"BSC\"",
"user": "BSC",
"password": "${{FDBI_BSC_PASSWORD}}",
"dataSource":"VALUEOF(BSC_DSN)",
"appServerName":"''"
},
{
"uid": "80d01383-0bd5-0000-714b-e31d00000000",
"connPool":"HR",
"parentName":"\"HR\"",
"user": "HR",
"password": "${{FDBI_HR_PASSWORD}}",
"dataSource":"VALUEOF(FDBI_HR_DSN)",
"appServerName":"''"
}
],
"Variables-In-Conn-Pool": [
{
"uid": "23829710-0c83-1000-8029-0a0a0b690000",
"variable": "BI_EE_HOME",
"value": "'${{FD_ORACLE_BI_HOME}}'"
},
{
"uid": "80d01384-0bd5-0000-714b-e31d00000000",
"variable": "BSC_DSN",
"value": "'${{FDBI_BSC_DSN}}'"
},
{
"uid": "fc3b8480-0c61-1000-8421-0af052d90000",
"variable": "HR_DSN",
"value": "'${{FDBI_HR_DSN}}'"
}
]
} |
|
Outputs
...