ExportConnectionPoolsJSON (OAC)
- Karl Henselin
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 |
| 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 |
| Yes | The RPD will be exported with this filename. |
OAC RPD Password |
| Yes | The RPD password on the OAC server in the current environment. |
Oracle BI Service Instance Name |
| Yes | The Oracle BI Service instance name.(e.g. bootstrap). |
OAC Trust Store |
| Yes | The OAC Trust Store. e.g. $JAVA_HOME/server/jre/lib/security/cacerts. Required to establish an SSL connection to the OAC server. |
OAC Trust Store Password |
| Yes | The OAC Trust Store Password. Required to establish an SSL connection to the OAC server. |
OAC Tools Directory |
| Yes | 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 contain /bitools/bin |
Inputs
Input Name | Input Code | Required | Description |
|---|---|---|---|
OAC RPD Connection Replacement 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.
- style