downloadWebCatalog

Extracts WebCatalog objects from an OTBI server to the file system.  This operation can be used from a utility workflow, which can also be augmented to sync the files to a source control management system (such as Git or Subversion). This allows the OTBI project which is used for build and deployment to source from a source code repository rather than directly from a development instance of OTBI.

Endpoint Tip

This operation uses HTTPS to communicate remotely to the OTBI server, and therefore, can be executed on any endpoint (including LOCALHOST).

Target Properties

Property Name

Property Code

Required

Description

Property Name

Property Code

Required

Description

OTBI Server Host

FDOTBI_SERVER_HOST

Yes

The server host name for Oracle Transactional Business Intelligence.

OTBI Server Port

FDOTBI_SERVER_PORT

Yes

The HTTP port number for Oracle Transactional Business Intelligence.  Default is 443.

OTBI Server User

FDOTBI_USER

Yes

The user to log into Oracle Transactional Business Intelligence. User must have BI Service Administrator role to archive catalog.

OTBI Server Password

FDOTBI_PASSWORD

Yes

The password for the user to login to Oracle Transactional Business Intelligence.

OTBI Server SSL Connection

FDOTBI_SERVER_USE_SSL

Yes

Indicates whether to connect to OTBI server using SSL.  Default is true.

Project Properties

Property Name

Property Code

Required

Description

Property Name

Property Code

Required

Description

Analytics WSDL Path

FDOTBI_ANALYTICS_WSDL_PATH

No

The path to the analytics WSDL. We don’t recommend changing this option unless the OTBI instance you are using has a different path to the analytics WSDL. Use at your own risk.

Default value - /analytics-ws/saw.dll/wsdl/v12

Discover Sub-Files

FDOTBI_DISCOVER_SUB_ITEMS

No

Select the objects to make their sub-files to be discoverable in the file catalog.

Inputs

Input Name

Input Code

Required

Description

Input Name

Input Code

Required

Description

WebCatalog Object Path

FDOTBI_INP_OBJECT_PATH

Yes

CSV list of WebCatalog path to be downloaded. Separate folders with a forward slash (/). Path can be for folders or individual files or both.

Examples

/shared/Custom/Financials/Payments,/shared/Custom/Financials/Fixed Assets/Tracking

/shared/Custom/Financials/Enterprise Contracts/HIERDMS.Folder,/shared/Custom/Financials/Enterprise Contracts/Contract Hierarchy.xdo.Report

Download Folder

FDOTBI_INP_DOWNLOAD_FOLDER

No

Absolute or relative target folder path. Relative path will be assumed in FD_TEMP_DIR.

Copy Object Permissions

FDOTBI_INP_COPY_PERMISSIONS

Yes

Copy object with current permissions. If false, parent folder permissions in deploy environment will be used.

Keep Timestamps

FDOTBI_INP_PRESERVE_TIMESTAMPS

Yes

Download object with timestamp details.

Discover Sub-Files

FDOTBI_INP_DISCOVER_SUB_ITEMS

No

Select the objects to make their sub-files to be discoverable in the file catalog.

Artifacts

This operation does not produce any artifacts.

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