Thursday, 4 June 2020

Sample Bursting query for FTP file in BI Publisher

SELECT 'JOB' as "KEY",
     'eText_Job' TEMPLATE,
     'ETEXT' TEMPLATE_FORMAT,
     'en-US' LOCALE,
     'TEXT' OUTPUT_FORMAT,
     'JOB_FTP' output_name,
     'FTP' DEL_CHANNEL,
     'INTERFACE_TEST' PARAMETER1,--server name set on xmlpserver as admin
     'userid' PARAMETER2,--userid
     'password#1234' PARAMETER3,--password
     '/DIR_TEST/FOLDER' PARAMETER4,--file path
     'JOB_FTP.txt'  PARAMETER5,--file name
     'true' PARAMETER6--secure ftp or not
FROM dual