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

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

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?

Received Response
53
Views
4
Comments
Bhumin Kamdar
Bhumin Kamdar Rank 2 - Community Beginner
in Oracle Analytics Cloud and Server
  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:

Answers

  • Wayne Van Sluys
    Wayne Van Sluys Mod

    Connect Directly either via semantic model or the direct connector

  • Bhumin Kamdar
    Bhumin Kamdar Rank 2 - Community Beginner

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

  • JohnW-Oracle
    JohnW-Oracle Rank 7 - Analytics Coach

    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 2 - Community Beginner

    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