Visual Builder

Get Involved. Join the Conversation.

Topic

    absalvi
    How to pull Cloud ERP Report data in VBCSAnswered
    Topic posted June 13, 2019 by absalvi Red Ribbon: 250+ Points, tagged Business Objects, REST, SaaS Integration 
    107 Views, 8 Comments
    Title:
    How to pull Cloud ERP Report data in VBCS
    Summary:
    How to pull Cloud ERP Report data in VBCS
    Content:

    Hi,

    We are trying to create a service connection via REST end point to Cloud ERP SaaS which would fetch BI Report data into VBCS.

    The REST service we are using is /xmlpserver/services/rest/v1/reports/<reportpath> (documentation: https://docs.oracle.com/middleware/12212/bip/BIPAP/rest-endpoints.html )

    However, this REST service is valid for BIP version 12c whereas SaaS BIP version is 11g till now.

    In this case how do we create a service connection which would fetch SaaS BIP data into VBCS?

     

    Thanks,

    Abhishek

    Best Comment

    Kanchankumar Khedkar

    Hi,

    Since you might not be able to call SOAP service from  VBCS. This can be done by creating a wrapper REST Service in OIC.

    This REST OIC service when called from VBCS does following 

    • Call BIP SOAP service by passing Report Name etc. 
    • Write ourput received base64 content to stage
    • Read data from Stage
    • Send JSON response back to VBCS

    Steps Write and Read from Stage are optional if you directly handle it in XSLT.

     

    Regards,

    Kanchan

    Comment

     

    • Shay Shmeltzer

      I think that you are asking this on the wrong forum, you should ask on the BIP forum which APIs they provide for invoking reports with your specific BIP version.

      Once you know the answer we can further discuss the options to call that API from VB. In general VB calls REST services - so if you don't have a REST endpoint for invoking BIP, you might need to have a middle layer that calls the BIP with whatever API they expose on one side, and exposes a REST method on the other side for VB to interact with. 

      • absalvi

        We do have an API which is not compatible. However the intention of posting this question here is to see if any other folks have done something similar.

        That would help us as well.

    • John Ceccarelli

      Remember you should never call a BIP report transactionally every time you run the page. That's not what the APIs are meant for and you can affect the performance of your entire ERP instance. If you need access to data from BIP report from a VB app you should replicate the data into a DB and expose that as REST. VB business objects can work here if it's simple data with very light security model. Otherwise, move it onto DBaaS/ATP and expose using REST layer of your choice (OIC DB adaptor, ADF-BC, Java or Node.js microservice). Sync your replicated data from ERP nightly using an OIC integration.

      • absalvi

        Thanks for the suggestion John. however what we are trying to implement is a mobile app in VB. so effectively we are looking for real time data whenever the user wants it.

        • John Ceccarelli

          Mobile or Web shouldn't make a difference when accessing BOs. But if you want real-time data then data replication won't work. Have to do SOAP<->REST

    • John Ceccarelli

      BIP REST endpoints are not meant for this, you shouldn't implement them in this way. You'll have to find the SOAP APIs to pull the data out then do a SOAP-REST bridge somewhere in OIC or in code and consume that REST endpoint.

    • Kanchankumar Khedkar

      Hi,

      Since you might not be able to call SOAP service from  VBCS. This can be done by creating a wrapper REST Service in OIC.

      This REST OIC service when called from VBCS does following 

      • Call BIP SOAP service by passing Report Name etc. 
      • Write ourput received base64 content to stage
      • Read data from Stage
      • Send JSON response back to VBCS

      Steps Write and Read from Stage are optional if you directly handle it in XSLT.

       

      Regards,

      Kanchan