Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Input Name

Input Code

Required

Description

Connection Pool JSON FileFDOBIEE_INP_CONN_POOL_JSON_FILENo

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
languagebash
themeRDark
titleExample 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

  1. Save JSON file during build operation as artifact, or
  2. Extract it from SCM during deploy workflow or
  3. Use absolute path to location on server. (not recommended as it requires manual setup on server)
Code Block
languagejs
themeRDark
{
    "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}}'"
        }
    ]
}


...