rpdUploadAndConfigure

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.

Target Properties

Property Name

Property Code

Required

Description

Property Name

Property Code

Required

Description

Oracle Middleware Home (MW_HOME)

FD_ORACLE_MW_HOME

Yes

The oracle middleware home (which has sub folders such as oracle_common, wlserver, coherence*, etc.) (e.g. /u01/oracle/products/fmw)

Oracle BI Home

FD_ORACLE_BI_HOME

No

The oracle BI home. (e.g. /oracle/Middleware/Oracle_Home/Oracle_BI1)

OBIEE Server Host

FDOBIEE_SERVER_HOST

Yes

The managed server host name for OBIEE.

OBIEE Server Port

FDOBIEE_SERVER_PORT

Yes

The managed server port number for OBIEE.(e.g. 9502 or 9704)

OBIEE Server Use SSL

FDOBIEE_SERVER_USE_SSL

Yes

Check if the connection to the managed server should be made using t3s. Otherwise, it will be made using t3. Defaults to false.

OBIEE Server User

FDOBIEE_USER

Yes

The user to log into OBIEE. Should have sufficient privileges to move and upload data.

OBIEE Server Password

FDOBIEE_PASSWORD

Yes

The password for the user to login to OBIEE.

OBIEE RPD Name

FDOBIEE_RPD_NAME

Yes

The RPD name on the OBIEE server. (e.g. liverpd). Do not put .rpd extension on this value.

OBIEE RPD Password

FDOBIEE_RPD_PASSWORD

Yes

The RPD password on the OBIEE server.

OBIEE RPD Source Password

FDOBIEE_SOURCE_RPD_PASSWORD

No

The RPD password from the Source Environment. Used if the RPD password changes between environments. If source password is different than rpd password then password will be updated on rpd prior to upload.

WebLogic Domain Directory

FDWLS_DOMAIN_DIRECTORY

No

WebLogic Domain Directory.(e.g. /u01/oracle/config/domains/soa_domain)

WebLogic Admin Domain Directory

FDWLS_ADMIN_DOMAIN_DIRECTORY

No



Inputs

Input Name

Input Code

Required

Description

Input Name

Input Code

Required

Description

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.

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

  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)

{ "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}}'" } ] }



Artifacts

This operation consumes an archive file of the RPD artifact. This artifact can be created by the rpdBuild operation.

Endpoint Selection

This operation delegates endpoint selection to the workflow developer. The workflow editor will default the selection to "All", which selects all available endpoints associated to the Target. Selecting a specific resource will result in selection of endpoints associated to the Target which have that resource defined.

Endpoint Execution

This operation delegates endpoint execution to the workflow developer. The workflow editor will default to "Any", which will execute on any one of the selected endpoints, which will be randomly picked from selected endpoints or a specific endpoint where previous step may have executed. Changing this value to "All" to will result in execution on all selected endpoints.

The following macros are not currently supported in the footer:
  • style