FDI Data Pipelines Refresh Tigger Automation

Sushanta Chakraborty-Oracle

Hi,

Is there a way to programmatically trigger an FDI data pipeline based on another backend pre-process refresh completion? Currently, we set it up at a given time, for example, 4 AM Eastern. In an ideal world, our ERP backend pre-processes are expected to be completed by 2 AM. However, in some cases, there can be a delay, which might cause them not to be complete by 4 AM. Is there a way we can trigger the pipeline refresh start only after our backend pre-process is completed? Is there an API interface or job orchestration layer that exists for FDI Data Pipeline start? If so, we may be able to configure it using OIC.

Subha_Tripathy-Oracle

Thank you !

Mallikarjuna Kuppauru-Oracle

Hi @Sushanta Chakraborty-Oracle

I don't think we have an Public API call for FDI to do the Refresh calls. I hope this is an ER request.

Regards,

Arjun

Sushanta Chakraborty-Oracle

Assuming that you understood our needs, are there any workarounds that you'd like to suggest?

Subha_Tripathy-Oracle

Hi @Sushanta Chakraborty-Oracle ,

We do understand the requirement. For now there is no workaround available as per product design.

We would request you to log a ER in Idea Lab with business justification for our Development team to consider -

https://community.oracle.com/products/oracleanalytics/categories/idealab-fusion-analytics

Thanks
Subha

Sushanta Chakraborty-Oracle

Done .. thanks.

ramesh balasubramanian

@Sushanta Chakraborty-Oracle, one work around I can think of is to check the status of Warehouse refresh date and time and trigger the back end jobs. The status is available in Common-Warehouse Refresh Statistics subject area.