Configuring Burst Reports for Object Storage

• After configuring the Publisher data model, as you build your burst query by navigating to the bursting section, you need to be aware of some of the key parameters to be supplied to the burst query that are specific to Object Storage.

• Sample Bursting Query for object storage as the delivery channel:

select DISTINCT

RESORT KEY,

'Arrivals_Report’ TEMPLATE,

'RTF' TEMPLATE_FORMAT,

'en-US' LOCALE,

'PDF' OUTPUT_FORMAT,

'OBJECTSTORAGE' DEL_CHANNEL,

'<output_name>' OUTPUT_NAME,

'OS' PARAMETER1,

'<prefix>'PARAMETER2,

'<file_name>' PARAMETER3

from RESORT

Key parameters that are specific to object storage are:

Once the template is pasted, modify the Query as below:

• RESORT KEY – No need to modify.

• TEMPLATE – The report name that will be used for bursting. The report name can be retrieved from the Properties menu of the report.

• TEMPLATE_FORMAT – No need to modify. The resulting report will still be delivered in the format that was specified in report properties.

• LOCALE – This defaults to the user account’s locale/location setting.

• OUTPUT_FORMAT – The output format of the delivered report such as PDF.

• DEL_CHANNEL – This indicates the delivery channel for the report. This needs to be keyed in as OBJECTSTORAGE.

• REPORT OUTPUT_NAME – The output name is not used. In this case, leave the line as “REPORT OUTPUT NAME.” The actual file name will be indicated in Parameter 3.

• PARAMETER 1 – Use OS as the parameter value for this, because this is the preconfigured server name. The value for this should be kept as OS and should not be changed.

• PARAMETER 2 – Prefix under the object storage bucket where the file will be uploaded. The prefix should not start or end with a / character; for example ris/outgoing is a possible prefix to use.

• PARAMETER 3 – This indicates the file name. File name. The file will be created under the prefix; For example, shared/chainname/Arrivals_Report - '||Resort||'_'||to_Char(Sysdate-1,'YYYYMMDD')|| '.pdf' is used.