Oracle Analytics

Get Involved. Join the Conversation.

Topic

    Paresh Bhangle
    connect OAC - BIP to on Prem database
    Topic posted May 2, 2019 by Paresh BhangleGreen Ribbon: 100+ Points, last edited September 11, 2019, tagged Access & Manage Data, Administration, Packaging & Licensing, Reporting 
    112 Views, 3 Comments
    Title:
    connect OAC - BIP to on Prem database
    Content:

    Hi,

    How to connect OAC ( Oracle Managed) BI Publisher to On Prem Database? We have already setup RDC to connect BI to On Prem database. Can we use the same for BIP too?

    Anyone achieved it?

    Regards,

    Paresh

    Comment

     

    • Noelle Bartlam

      Please refer to the user's guide for how to set up datasources for Oracle BI Publisher;  https://docs.oracle.com/en/cloud/paas/analytics-cloud/acabi/set-data-sources.html#GUID-13359663-9030-4E6F-B5CC-2D63E43E456F

    • Paresh Bhangle

      Hi,

      Documentation shows how to setup JNDI connection OAC Classic. I am talking about autonomous OAC ( SaaS) based.

      Did you achieved the same for OAC?

      When i tried putting RDC JNDI url in JNDI Connection is showing error as 

       nested exception is: java.rmi.ConnectException: No available router to destination.

      Regards,

      Paresh

    • ravikiran goda

      Hi

      BI Publisher in Oracle Fusion Apps Cloud is designed to access data from Fusion Apps transactional database.
      Creating a new data source to access external database or external webservices is currently not supported. 

       

      Regards,

      Ravi