Skip to main content
Exports the connection pools json file for an environment to a given location using the OAC Client tools installed on an endpoint. The intention of this operation is to export it using a utility project, then modify any values that are different in each environment to be in FlexDeploy Property Replacement format, ${{VAR_NAME}}. Then, store it in Source control, or the endpoint which has the OAC_TOOLS installed. Finally reference the file while deploying the RPD in the plugin input to update the connection pool after deployment. Property Replacement is executed on the json files during deployment, so if storing the file on the endpoint, copy it to the FD_TEMP_DIR before running the deploy or export operation.

​
Target Properties

Property Name

Property Code

Required

Description

OAC Account

FDOAC_CLOUD_ACCOUNT_CODE

Yes

The OAC account includes essential properties such as the URL, Username, Password, and OAuth details for the OAC instance. Cloud account credentials are required for downloading or uploading catalog items.

You can manage the OAC account via the Integrations > Cloud page.

See Configuring OAC Cloud Account for additional details.

OAC RPD Name

FDOAC_RPD_NAME

For RPD Migration

The RPD will be exported with this filename.

e.g. rpd.rpd

OAC RPD Password

FDOAC_RPD_PASSWORD

For RPD Migration

The RPD password on the OAC server in the current environment.

Oracle BI Service Instance Name

FDOAC_SERVICE_INSTANCE_NAME

For RPD Migration

The Oracle BI Service instance name.(e.g. bootstrap).

OAC Trust Store

FDOAC_TRUST_STORE

For RPD Migration

The OAC Trust Store.

e.g. /u01/java17/lib/security/cacerts

Required to establish an SSL connection to the OAC server.

OAC Trust Store Password

FDOAC_TRUST_STORE_PASSWORD

For RPD Migration

The OAC Trust Store Password.

Required to establish an SSL connection to the OAC server.

OAC Tools Directory

FDOAC_TOOLS_DIR

For RPD Migration

Download OAC tools to your endpoint. Reference the path here.

e.g. C:\oracle\Oracle_Home\bi

e.g. /u01/Oracle_Home/bi

The folder you specify should be the parent of the bitools/bin folders.

​
Inputs

Input Name

Input Code

Required

Description

OAC RPD Connection Replacement JSON

FDOAC_RPD_CONNECTION_POOL_JSON

No

After deployment, the connection pools can be updated by a json file at this location.

Property replacement is performed on the file.

You can use the ExportConnectionPoolsJSON operation to get the json from the environment.

​
Artifacts

This operation produces an archive file of the RPD artifact. The archive file is suitable for the importRPD 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.