A Step-by-Step Guide to Conditional SFTP Bursting in Oracle Cloud BI Publisher

Oracle Cloud BI Publisher users can now dynamically route high-volume system files across separate secure SFTP servers and target sub-folders automatically using a conditional SQL data model and a dynamic Bursting Control XML script. This solves the challenge of delivering files to different third-party SFTP servers or specific, nested directory paths based on business requirements. To implement this, create a dynamic SQL query that routes files based on conditions such as country or business unit, and use the Bursting Control XML script to automate the delivery process. This solution enables seamless file delivery during a single scheduled enterprise process run without manual file splitting by IT administrators. This guide provides a step-by-step walkthrough on how to construct the advanced SQL data model and dynamic Bursting Control XML script.