cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
iamsaanvi Frequent Visitor
Frequent Visitor

EPBCS(Planning and Budgeting Cloud Service) data connector to BI tools?

Hi,

 

Does someone know how to connect Oracle EPBCS directly to BI tools, such as Qlik or PowerBI?

 

Or what is the IP/port of the XMLA service for EPBCS? 

 

Sometimes there are alternatives.  For example, Qlik can support many connectivity protocols such as ODBC/REST/HTTP/SOAP/.NET etc…  but it really depends on what EPBCS provides for access.

 

Thanks in advance

Saanvi S

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-qiuyu-msft
Moderator

Re: EPBCS(Planning and Budgeting Cloud Service) data connector to BI tools?

Hi @iamsaanvi,

 

You need to research by yourself or contact the Oracle support to find if the Planning and Budgeting Cloud Service provides REST api to access its data. Then you can call REST api use the web data source in the Power BI desktop. You can see this example about call REST api. 

 

As currently the Power BI desktop doesn't provide the OOTB connector to get data from Oracle Planning and Budgeting Cloud Service, you can also try to custom your own connector follow this blog

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
Moderator v-qiuyu-msft
Moderator

Re: EPBCS(Planning and Budgeting Cloud Service) data connector to BI tools?

Hi @iamsaanvi,

 

You need to research by yourself or contact the Oracle support to find if the Planning and Budgeting Cloud Service provides REST api to access its data. Then you can call REST api use the web data source in the Power BI desktop. You can see this example about call REST api. 

 

As currently the Power BI desktop doesn't provide the OOTB connector to get data from Oracle Planning and Budgeting Cloud Service, you can also try to custom your own connector follow this blog

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

iamsaanvi Frequent Visitor
Frequent Visitor

Re: EPBCS(Planning and Budgeting Cloud Service) data connector to BI tools?

Thank you @v-qiuyu-msft

nhol Member
Member

Re: EPBCS(Planning and Budgeting Cloud Service) data connector to BI tools?

Hi,

 

Since this is a post from 2016, I wonder if there was any change in Power BI desktop providing the OOTB connector to get data from Oracle Planning and Budgeting Cloud Service.

If not, I would appreciate if anyone can articulate my options to connect to PBCS.

 

Thanks!

Nir

Highlighted
karaoan
Advisor

Re: EPBCS(Planning and Budgeting Cloud Service) data connector to BI tools?

Hi @iamsaanvi, if you can't get the EPBCS connection to work you could look at planning solutions particularly designed for Power BI like www.acterys.com

 

Martin

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 59 members 1,139 guests
Please welcome our newest community members: