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

Patil, Pravin 1 Reputation point
2021-08-09T15:05:00.757+00:00

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 Functions
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
4,306 questions
Azure Event Hubs
Azure Event Hubs
An Azure real-time data ingestion service.
560 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,617 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. KranthiPakala-MSFT 46,422 Reputation points Microsoft Employee
    2021-08-10T10:37:25.347+00:00

    Hi @Patil, Pravin ,

    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.