Oracle Transactional Business Intelligence

Products Banner

How to connect Power BI with Oracle in OTBI?

Received Response
240
Views
3
Comments

Hello everyone,

Does anyone know if there is currently a manual with the steps to follow to connect the Power BI application with the Oracle Cloud application to import reports and analysis?


Currently I have tried to connect but I am getting the message that it cannot connect due to the error: "Oracle: ORA-12538: TNS:no such protocol adapter"


I appreciate your comments.

Answers

  • Nathan CCC
    Nathan CCC ✭✭✭✭✭
    edited March 8

    Hi Fernando,

    No. I am not sure what you mean by "import analytics and report from OTBI to PBI?". But will assume your use case is to view data from Oracle Fusion Cloud Applications in Power BI. Obviously you can build a data extract to get data out to put it somewhere external that can be connected to by PBI. Or use the various web services to call analytics and reports synchronously. But you would rather just connect direct to view the same data as you get in your analytics and reports in real time in PBI?

    Oracle Fusion Cloud Applications is SaaS. Therefore connectivity is very restricted. You databases in your cloud system have a big wall built around them to protect them. You cannot connect to the database from an external tool. You cannot connect from powerbi to either database. You cannot connect from power bi direct to the standard application tables and views in the application database. You cannot connect from power bi direct to query subject areas in the metadata repostitory database (rpd) in OTBI.

    The only tool I am aware of that can connect direct to data via OTBI is Oracle Analytics Cloud (OAC) purchased as PaaS in addition to your SaaS. This comes with an adapter to view data from Saas. The features in OAC and PBI are almost identical. Here is some more information

    About OAC Applications Connector 

    OAC includes a “real time” applications connector to Oracle Fusion Cloud Applications. The access is provided using Oracle Transactional Business Intelligence (OTBI). Authentication can be configured for users to enter their own username and password for the data source such that they can only access the data for which they have already setup in the permissions, privileges, and role assignments in the source transaction system. 

    Oracle® Cloud Connecting Oracle Analytics Cloud to Your Data F25037-47 

    July 2023 Part II Connecting Oracle Analytics Cloud to Your Data 

    Connect to Oracle Fusion Cloud Applications Suite 

    https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsds/connect-oracle-fusion-cloud-applications-suite.html#GUID-FDC9B8BD-4CC4-4AA2-8C02-1078E4FA32A2 

    Connect to Oracle Fusion Cloud Enterprise Performance Management (EPM) 

    https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsds/connect-oracle-epm-cloud.html#GUID-3DF935C1-82D2-49BB-A0E4-4848BA3D2602 

  • Nathan has answered it very well. Just want to add that the feature FAW/OAC has to connect to Oracle Fusion Application using OAC connection can't be achieved by Power BI or another Analytics platform. This is because both are Oracle suites, so Oracle has build the pipelines.

    For Power BI or other Analytics platform, the only main option is to get BICC extracts from Fusion and build a whole data model in the data warehouse.

  • Hi,

    I really appreciate the response from both of you. Your comments were very helpful in helping me understand more about how this works.


    Best regards,

    Fernando.