Integrate Data from FCCS Cloud to Postgres Database

Hi All,

I’m looking for best practices or recommended approaches to load financial data from FCCS into a Postgres database for reporting and downstream integrations.

Source system: Financial Consolidation and Close Process Cloud Service

Target system: Postgres Database (more like SQL)

Specifically:

• What is the recommended method to export from FCCS to Postgres?
  • Using EPM Agent
  • Via REST APIs
  • Third-party middleware
• Has anyone implemented a similar integration and can share architecture recommendations (e.g., middleware tools, ETL solutions, OCI components, etc.)?

Any guidance, documentation references, or sample approaches would be greatly appreciated.

Thanks,

Vasuki.