Can we trigger oracle Integration based on the BI query output?

Sateesh Reddy

we have a requirement of triggering the Oracle integration based on BI report Output instead of scheduling the integration and run the BI report. if the BI report doesn't have any rows then we shouldn't trigger the integration since we don't have anything to process.

is there anyway we can trigger the integration only when we have data in BI report?

RajeshPolavarapu-Oracle

Hi,

You can schedule report to deliver report content directly from Oracle Analytics to an email inbox.

https://docs.oracle.com/en/middleware/bi/analytics-server/user-oas/automate-business-processes-using-agents.html#GUID-7A0FBFEA-4A3A-483D-9BDF-A59E8BC2F516

Later it is Oracle Integration part -

Poll the inbox periodically for a new email with report, process the report to verify if there are any rows and then trigger the next step in integration.

Hope this one helps.

Sateesh Reddy

Hi Rajesh,

does it works for Oracle Fusion BI Publisher report? we create data model /Report and schedule the report to run the job and check if data is available for the report. if data available then trigger the OIC endpoint if not No.

Thanks,

Sateesh

RajeshPolavarapu-Oracle

Yes it works.

You can burst BIP report to an FTP/SFTP folder . Ref - https://www.youtube.com/watch?v=S1xC9Vziikk

Then using OIC you can poll the FTP/SFTP folder read the contents as first step and then decide to further in the next steps based on the data.