HFM connector on synapse

Question

HFM connector on synapse

Rekha 21

Do we have a connector which helps us to read/write data from/to HFM(Hyperion Financial Management) from Azure Synapse Analytics

Accepted answer

0 additional answers

Your answer

Answer 1

ShaikMaheer-MSFT 38,551 Microsoft Employee Moderator

Hi @ChandraRekhaBobba-9422 ,

Thank you for posting query in Microsoft Q&A Platform.

Azure Synapse Analytics or Azure Data factory doesn't have connector of HFM(Hyperion Financial Management). Click here to see all list of connectors which are currently available.

I would encourage you to log feedback item for this. Product team will actively validate feedbacks and consider them for further implementations.

Please Note, If you have REST APIs available which can communicate with HFM and do your job, then you can consider using web activity to make API call from Synapse Pipelines. If API calls can get you data and want to load that data for some destination systems, then you can use HTTP connector or REST connector datasets in Copy activity.

Hope this helps. Please let us know if any further queries.

------
Please consider hitting Accept Answer. Accepted answers help community as well.

Rekha 21 Reputation points

2022-06-16T10:36:06.55+00:00

Hi @ShaikMaheer-MSFT ,

Thanks For the Response , can you Also please suggest all the possible ways of connecting to HFM similar to REST API calls.
ShaikMaheer-MSFT 38,551 Reputation points Microsoft Employee Moderator

2022-06-17T06:28:12.76+00:00

Hi @Rekha ,

Only REST API call you can do to HFM from ADF or Synapse pipelines as there is no connector available. From HFM side you need to identity right APIs available or not for your task.

Between below video helps you to get idea about web activity in ADF that helps to make API call.
Web activity in Azure data factory.

Hope this helps.

------------

Please consider hitting Accept Answer button. Accepted answers help community as well.
ShaikMaheer-MSFT 38,551 Reputation points Microsoft Employee Moderator

2022-06-27T03:54:20.86+00:00

Hi @Rekha ,

Just checking in to see if the below answer helped. If this answers your query, do click and upvote for the same. And, if you have any further query do let us know.
Rekha 21 Reputation points

2022-06-27T04:28:58.553+00:00

Hi @ShaikMaheer-MSFT
Although i am yet to verify the suggested approach ,Thanks for sharing the possible ways of connecting.

Share via

HFM connector on synapse

0 additional answers

Your answer