Fusion Bursting Examples: FILE Delivery

Variation 1: Save PDF Reports to Local Folder

SELECT Employee_ID AS "KEY",
       'EmployeeReport.rtf' TEMPLATE,
       'en-US' LOCALE,
       'PDF' OUTPUT_FORMAT,
       'Employee_' || Employee_ID OUTPUT_NAME,
       'FILE' DEL_CHANNEL,
       '/reports/output/' PARAMETER1,                 -- Directory
       NULL PARAMETER2,                               -- File Name (can be dynamic via OUTPUT_NAME)
       NULL PARAMETER3,                               -- Not used
       NULL PARAMETER4,                               -- Not used
       NULL PARAMETER5,                               -- Not used
       'TRUE' PARAMETER6                               -- Not used but set for completeness
FROM Employees;