Data Engineering on Microsoft Azure - Azure for DE: 13 - Azure Data Factory integration runtimes (part 2)

Hey data engineers! In my last video I talked about two ADF integration runtimes, including the super cool one - Azure IR with managed virtual network. However, none of them allows us to install anything on them and sometimes it is required when we just need to have some particular ODBC driver installed or a client certificate available. In this video I'm talking about two remaining ADF integration runtimes, and yes - one of them gives us the full control and flexibility. Also, I'm showing the way to connect to on-premises environment from Azure Data Factory. Finally, I summarize the episode by giving you some guidelines you can follow when deciding which integration runtime to use. Enjoy! ▬▬▬▬▬▬ IMPORTANT LINKS ▬▬▬▬▬▬ My LinkedIn profile: https://www.linkedin.com/in/piotr-tybulewicz-81a8793/ GitHub with my drawings: https://github.com/TybulOnAzure/DP-203 SSIS IR pricing: https://azure.microsoft.com/en-us/pricing/details/data-factory/ssis/ ▬▬▬▬▬▬ MEMBERSHIP ▬▬▬▬▬▬ Join this channel to get access to perks: https://www.youtube.com/channel/UCLnXq-Fr-6rAsCitq9nYiGg/join ▬▬▬▬▬▬ CHAPTERS ▬▬▬▬▬▬ 00:00 Introduction 01:45 Azure-SSIS integration runtime 03:35 Self-hosted integration runtime 31:51 How to choose proper iR?