Connecting Power BI to Oracle Fusion (Cloud)

[Oluwapelumi]

Hello community,

I am trying to connect Power BI to Oracle Fusion (Cloud) but I found a connector called BI Connector after my research. I found out that the connector is not free but my organization would not mind paying for it but I need to be sure if the connector will help out. Has anyone connected Power BI to Oracle Fusion (Cloud) with BI Connector in Power BI before or with any other connector? If yes, I wil appreciate if you can help with the process how you went about it?

More information about our Oracle Fusion:
1. OTBI is used for anaysis & reporting

2. ODBC Data Source Name (DSN)

• ApplicationDB_FSCM
• ApplicationDB_HCM

Looking forward to seeing our responses.

Thanks.

[Anonymous · Accepted solution]

Hi, @Oluwapelumi 
Thanks for reaching out to the Microsoft fabric community forum.

1.Based on my research, the Power BI connector is indeed a good solution. Users in the Power BI forum have successfully used this method for connections.
Here are some screenshots of relevant responses:

2.Regarding connection guidance, Oracle Fusion provides a blog titled "Using Oracle Fusion Analytics with Microsoft Power BI." This blog details how to connect Oracle Fusion Analytics with Microsoft Power BI, including specific configuration steps and considerations. Below are some screenshots from the blog:

For further details, please refer to the following link:

Using Oracle Fusion Analytics with Microsoft Power BI
 

3.Additionally, forum users have shared their experiences of extracting data from Oracle Fusion OBI, uploading it to SharePoint, and then importing it into Power BI. Here are some screenshots of relevant responses:

For further details, please refer to the following link:

Connect Power Bi to Oracle Fusion - Microsoft Fabric Community
 

4.Lastly, there are related discussions in the Oracle forum that might be helpful to you:

 How to Connect Power BI Desktop to Oracle Fusion Cloud 24c FSCM database — Cloud Customer Connect

Of course, if you have any new discoveries or questions, please feel free to get in touch with us.
 

Best Regards,

Leroy Lu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Oluwapelumi · Accepted solution]

Hello @Anonymous ,
Thanks for your help I really appreciate.

From the solutions you shared, the BI Connector seems to be the feasible solution and straightforward to connect Power BI Desktop to Oracle Analytics Cloud.

[Anonymous · Accepted solution]

Hi, @Oluwapelumi 
Thanks for reaching out to the Microsoft fabric community forum.

1.Based on my research, the Power BI connector is indeed a good solution. Users in the Power BI forum have successfully used this method for connections.
Here are some screenshots of relevant responses:

2.Regarding connection guidance, Oracle Fusion provides a blog titled "Using Oracle Fusion Analytics with Microsoft Power BI." This blog details how to connect Oracle Fusion Analytics with Microsoft Power BI, including specific configuration steps and considerations. Below are some screenshots from the blog:

For further details, please refer to the following link:

Using Oracle Fusion Analytics with Microsoft Power BI
 

3.Additionally, forum users have shared their experiences of extracting data from Oracle Fusion OBI, uploading it to SharePoint, and then importing it into Power BI. Here are some screenshots of relevant responses:

For further details, please refer to the following link:

Connect Power Bi to Oracle Fusion - Microsoft Fabric Community
 

4.Lastly, there are related discussions in the Oracle forum that might be helpful to you:

 How to Connect Power BI Desktop to Oracle Fusion Cloud 24c FSCM database — Cloud Customer Connect

Of course, if you have any new discoveries or questions, please feel free to get in touch with us.
 

Best Regards,

Leroy Lu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.