0

We are trying to get data from HFM (Oracle Hyperion Financial Management) datasource, but unfortunately thats not an option (yet) in powerbi. So we have decided to look into building a custom connector using HFM API's. the problem is that HFM API's are java based, and based on my research so far, im only seeing PowerQuery SDK c# based samples.

Is a java custom connector not possible then? Is the PowerQuery SDK only limited for integration with C#/PowerShell?

Related thread:Is there any way to invoke PowerQuery/M outside of Excel or PowerBI?

Cataster
  • 3,081
  • 5
  • 32
  • 79
  • Well, I think that if you can expose the data you want via RESTful Web Services in java, then it would be possible to consume them with Power Query. – Dreekun Jan 28 '20 at 14:26
  • @Dreekun so you mean we would have a standalone java program/script that would first fetch the data and then we pass that data to the actual custom connector file that would be written in PowerQuery? – Cataster Jan 28 '20 at 15:12
  • 1
    @Dreekun just updated my manager/team. apparently HFM doesnt have REST API's :/ – Cataster Jan 28 '20 at 15:21
  • Yes, that's what I meant. Custom Connectors are just programmed calls to Restful Web Services, iirc. If you build them it should work. – Dreekun Jan 28 '20 at 17:57
  • @Dreekun i see, thanks for the info! – Cataster Jan 28 '20 at 18:03
  • How can we get the java api endpoint? – syam kumar c Jan 31 '23 at 11:44
  • @syamkumarc it's been a while but I remember there was some documentation available on this on Oracle – Cataster Jan 31 '23 at 14:56

0 Answers0