question

PatilPravin-2780 avatar image
0 Votes"
PatilPravin-2780 asked KranthiPakala-MSFT commented

SAP HANA DB on Premise to Azure eventhub -> can it be Azure Functions -> self Hosted IR -> HDB pull?

Looking to get data from HDB on premise, already have CDC ability, we can use ADF micro batch approach, but ADF does not support target to be eventhub :(.
hence checking what are the options?

can it be Azure functions ? if so can it use self hosted IR? (because we can not expose the HDB data over https service at this time.

azure-data-factoryazure-functionsazure-event-hubs
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

KranthiPakala-MSFT avatar image
0 Votes"
KranthiPakala-MSFT answered KranthiPakala-MSFT commented

Hi @patilpravin-2780,

Welcome to Microsoft Q&A forum and thanks for posting your query.

You could expose it via VPN/ExpressRoute to an Azure VNET and then leverage Azure Functions Premium to access that data securely. Function apps deployed to a Premium plan can take advantage of VNet integration for web apps. When configured, your app can communicate with resources within your VNet or secured via service endpoints. IP restrictions are also available on the app to restrict incoming traffic. For more info about Azure Function Premium plan and its benefits, please refer to this doc: Azure Functions Premium plan

And yes, if you are planning to execute that Azure function in Azure Data factory pipeline then you can use Self Hosted IR in Azure Function linked service. For more info about the activity, please refer to this doc: Azure Function activity in Azure Data Factory

Hope this info helps.

Thanks



Please don’t forget to Accept Answer and Up-Vote wherever the information provided helps you, this can be beneficial to other community members.


· 7
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @patilpravin-2780,

Just checking in to see if the above suggestion was helpful. If it answers your query, please do click “Accept Answer” and/or Up-Vote, as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

0 Votes 0 ·

Hi @patilpravin-2780,

We still have not heard back from you. Just wanted to check if the above suggestion was helpful? If it answers your query, please do click “Accept Answer” and/or Up-Vote, as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

0 Votes 0 ·

@KranthiPakala-MSFT

Thank you for the details, we are reviewing the possibilities internally, this may take some time. I will update in couple of weeks on this.

0 Votes 0 ·

Sure, thanks for the update @patilpravin-2780!

0 Votes 0 ·

Iin above suggested approach though, there is a need to expose the source from OnPremise over ExpressRoute and does not seem to be utilizing SelfHotsed IR.
is there an option where we can utilize SelfHosted IR capabilities to batch the pull every few minutes.

0 Votes 0 ·

Hi @PatilPravin-2780 ,

Thanks for your response. In the above approach, it is recommended to use VPN/ExpressRoute to an Azure VNET and then leverage Azure Functions Premium to access that data securely in which SHIR is not involved and I don't think it is possible to utilize SHIR in this case.

Do let us know if you have further query.

0 Votes 0 ·

Hi there,

Following up to see if the above response was helpful or if you have any further query? - Thanks

0 Votes 0 ·