Our application is running on Pega Cloud, and we have a requirement to mirror specific application data (e.g., case data from Work- tables, and custom data from Data- tables) to an external reporting database (e.g., postgres aurora) located outside of the Pega Cloud environment.

Due to the nature of Pega Cloud, we cannot have direct access for external database replication tools (like DMS). While BIX is the standard solution, we are exploring alternatives, specifically for bulk extraction and loading, that bypass the need to write to an intermediary file on the Pega Cloud SFTP/S3 repository.

Excluding BIX and File-Based Data Flows, what are the recommended, enterprise-grade patterns for scheduled, bulk data transfer from Pega Cloud directly into an external reporting database?