Connect Power Bi to Oracle Fusion

Hi,

It is impossible as direct connection - but you can have it similar to scheduled export but with extended amount of data.

This can be done by using SOAP for OBI/BIP.  But you need some sort of middleware anyways, external server running the script or as in my case - MS Power automate.

First you need to learn how to extract the data from BI publisher:
https://docs.oracle.com/cd/E28280_01/bi.1111/e22259/webservices.htm#BIPDV002
Use soapUI (https://www.soapui.org/) application to test and develop connections to WSDL's mentioned in above link.

Create BIP sql report that will suit your needs. Use soapUI to get proper package back.

This guy describes the process nicely:

https://blogs.oracle.com/fadevrel/calling-bi-services-from-external-applications 

Keep in mind he uses obsolete WSDL link (use one from Oracle doc I placed above).

Then you need to rewrite working soapUI request code to app you're gonna use.

In powershell you can use Invoke-WebRequest or Invoke-restmethod.

In ms Power Automate you can use HTTP connector, post method with WSDL of your interest as URI, with single empty header SOAPAction and request code from soapUI in the body. It gets the job done.

Last point If you want huge amount of data extracted asynchroneously (I had to do it async due to mspa html request timeouts):

Use one SOAP request to schedule the report - you will get parent jobID back. Increment it and use to run getAllScheduledReportHistory which confirms if your incremented id is child of parent jobID received in first place.

Then run some until loop on getScheduledJobInfo to wait and confirm the file is ready. 

Finally use getScheduledReportOutputInfo to get document ID and getDocumentData to get the document (it is base64 encoded - ms flow allows to decode it using expressions: base64ToString() for xml, csv overal txt data or base64ToBinary() for other filetypes. For other apps than mspa you need to code something of your own). My output gets uploaded to sharepoint and sourced to PowerBI from there.

That way you can completely control what will be extracted from your fusion OBI by crafring BIP SQL yourself, by letting the process to schedule the report you will make it completely independed and waiting for report process/file preparation to be finished on its own.

Excuse me for quite a messy reply but I finished developing above just last week in my company so for me this is quite fresh and gamechanging knowledge I am yet to utilize in its full potential.

Kind Regards,

Matt