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 0 KEY,
'<template_name>' 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 "Retail Insights As-Is"

Key parameters that are specific to object storage are:

  • DEL_CHANNEL — This needs to be keyed in as OBJECTSTORAGE.
  • PARAMETER1 — 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.
  • PARAMETER2 — 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.
  • PARAMETER3 — File name. The file will be created under the prefix; for example a filename of order_list with type as PDF will be created as ris/outgoing/order_list.pdf