Episode 215: Azure Data Factory

Episode 215: Azure Data Factory

Episode 215: Azure Data Factory 560 420 Carlos L Chacon

We have been moving data for years with technologies like DTS and SSIS; however, these were very much designed for on-premises moves in mind. As more cloud services were being offered Microsoft needed a service to help customers using those services move data around. Azure Data Factory was born with the initial premise of moving data between cloud services; however, it has added the ability to connect with on-premises systems and continues to add a variety of connectors it can now natively support.

In this episode, we chat with our friend Andy Leonard about Azure Data Factory, his experience working with the product team, and how customers can leverage the cloud to get business done faster.

Episode 215: Azure Data Factory

Our Guest

Andy Leonard

Andy Leonard is founder and Chief Data Engineer at Enterprise Data & Analytics, Microsoft Data Platform MVP, creator of the DILM (Data Integration Lifecycle Management) Suite, an SSIS trainer, consultant, developer, Business Intelligence Markup Language (Biml) developer and BimlHero, SQL Server database and data warehouse developer, community mentor, engineer, and farmer. He is author and co-author of several books about SSIS, Biml, Managing Teams, and Azure Data Factory. Andy blogs at andyleonard.blog where you can learn more on the About Andy page.

Never Miss An Episode

Subscribe to get podcast notifications by email.

“[If you’re moving data on-premises and in the cloud] you’re not doing it wrong in my opinion and experience. Hybrid has just emerged as the dominant force among people using the cloud at all. It’s a surprising amount.”


Andy Leonard
Episode 215: Azure Data Factory

3 Takeaways

  1. The way you approach cloud architecture will probably look different than what you do on-premises.
  2. The change in architecture can lead to a performance increase at no additional expense.
  3. Azure Data Factory continues to merge the experience between the cloud and on-premises for a more seamless transition.

Imagine what’s possible with a dedicated SQL specialist on your team.

Leave a Reply

Back to top