How to access Fusion Cloud for building custom BI?
Posted by Dylan Wan on December 20, 2016
It was a challenge when we tried to build a BI application for Fusion Cloud application as Fusion Cloud applications, unlike those acquired solutions, such as RightNow, Elouque, and Taleo, do not have web services at that time.
It was the reason why Oracle BI Application Configuration Manager was introduced. It fills the gap by building an agent at the Fusion cloud application side. The agent talks to Fusion Apps like how OTBI talks with Fusion Apps. It queries the physical layer of the objects from Fusion Apps and download the data into csv files. It is not a web service based solution but for building a custom BI that requires bulk access any way, it is a goo choice.
Once the data is downloaded from Fusion Apps as CSV files, it can be accessible via FTP. Here is the documentation about configuring Oracle BI Apps but I guess that it will work for other FTP client as well.
It seems that the situation improved and now multiple alternates are available.
Another possible way is to use BI Publisher. If you have the BI Publisher Data Model Developer role, you will be able to “data model” in publisher. Here is the documentation.