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.
Andy’s blog
Andy’s books
Andy’s podcast with Frank La Vigne
Get your SQL Data Partners Podcast T-shirt!
Support the livestream here

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
3 Takeaways
- The way you approach cloud architecture will probably look different than what you do on-premises.
- The change in architecture can lead to a performance increase at no additional expense.
- Azure Data Factory continues to merge the experience between the cloud and on-premises for a more seamless transition.
Leave a Reply
You must belogged in to post a comment.