what is the best way to extract the data from the EPM Cloud?

Bhumin Kamdar

1. Extract data via EPM extract and load it to the SFTP folder and utilize it
2. Connect EPM cloud with OAC directly to capture the data for PBCS

JohnW-Oracle

Hi @Bhumin Kamdar,

Thank you for the question. The answer is probably 'it depends'.

If you are using OAC in a standalone way and EPM>PBCS is your only source, then OAC's Oracle EPM Cloud connector would likely be the best choice.

If OAC is being used as a part of FDI or if you have other data sources and especially other CSV data sources, then you could consider SFTP.

Regards,

John

ramesh balasubramanian

For FDI there is a new connector being developed and its a roadmap item. One other option if you run into performance issue with existing FDI connector is to create groovy export of EPM and load the data into FDI

Wayne Van Sluys

Connect Directly either via semantic model or the direct connector

Bhumin Kamdar

We are in process of doing the same, but I have question regarding the performance and connectivity with the other datasets.