How to connect On premise Terradata server with Azure Function without doing any migration

Question

I am configuring the azure function to run python code with CSV file as source and writing the dataframe into Terra data destination . Need guidance to configure the connection configuration between Azure function app cloud and on premise Terra data server . Because there is no outbound configuration in Azure function app for Terra data .

Can you tell how to connect Onpremise terradata server with azure function

Answer 1

Hi,

Welcome to the community.

I do not know of Terra data but I do know of Azure App Service Hybrid Connections.

https://learn.microsoft.com/en-us/azure/app-service/app-service-hybrid-connections

That basically allows you to connect to an endpoint on premises via port 443 / TLS1.2.

Pretty certain this will be what you are looking for.

Let me know if that helps.

Answer 2

Hi @sangeetha san ,

Assuming that you have a working code that would write data into on premise terra data server, you will have to configure a hybrid connection in Azure Function app. Please make sure that the function app is either created in Dedicated App service plan or Premium SKU which supports networking options. The following articles would help in configuring hybrid connectivity with the on prem server.

https://devblogs.microsoft.com/premier-developer/using-azure-app-services-with-hybrid-connections/#how-it-works
https://learn.microsoft.com/en-us/azure/app-service/app-service-hybrid-connections

Once the configuration is complete, please try to reach the on prem server from function app console, by doing a tcpping test. If you are able to reach the on prem server, then you can deploy the code to the Function app.

Hope this helps! Feel free to reach out to me if you have any questions or concerns.