topic PBCS connection in Developer

PBCS connection

Anonymous — Fri, 13 Sep 2019 16:51:25 GMT

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,

Re: PBCS connection

Greg_Deckler — Fri, 13 Sep 2019 17:48:50 GMT

PBCS = ?

Performance-based Communication and Surveillance
Oracle's Planning and Budgeting Cloud Service
Project Based Calendaring System
?

Re: PBCS connection

Anonymous — Fri, 13 Sep 2019 17:52:09 GMT

Oracle's Planning and Budgeting Cloud Service

Re: PBCS connection

Greg_Deckler — Fri, 13 Sep 2019 17:58:49 GMT

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.