Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Accepted answer
62
Views
4
Comments
Bhumin Kamdar
Bhumin Kamdar Rank 2 - Community Beginner
in Oracle Analytics Forum
  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
Tagged:

Best Answers

  • JohnW-Oracle
    JohnW-Oracle Rank 7 - Analytics & AI Coach
    Answer ✓

    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
    ramesh balasubramanian Rank 3 - Community Apprentice
    Answer ✓

    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

Answers