Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

PBCS connection

Hi, does anyone know if you can create a connection to PBCS or import data from PBCS to Power BI? Also are you able to write back data from Power BI to PBCS? Thanks,

3 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion

    PBCS = ?

    • Performance-based Communication and Surveillance
    • Oracle's Planning and Budgeting Cloud Service
    • Project Based Calendaring System
    • ?
    • Anonymous's avatar
      Anonymous
      Not applicable

      Oracle's Planning and Budgeting Cloud Service

      • Greg_Deckler's avatar
        Greg_Deckler
        Community Champion

        There appear to be multiple ways. From this document: http://www.oracle.com/us/solutions/cloud/planning-budgeting-cloud-service-1851924.pdf

         

        Integration Capabilities

        Oracle Planning and Budgeting Cloud Service includes integration capabilities that enable automated data imports from and extracts to on premise or cloud based applications. Oracle Planning and Budgeting Cloud Service is integrated out of box with Oracle ERP Cloud Service to enforce closed-loop processes for planning, budgeting, transacting, and measuring results. The Service provides open interface REST based Web Services that can be used to customize connections with any third party source or target system.

         

        So it sounds like you could export the data to some kind of on-premises data source or utilize the REST API's which might return data in JSON, XML, etc. Tough to know without trying it.