About Show #573
How do you ETL? Richard chats with Tom Kerkhove about Azure Data Factory, now previewing V2 features. We've had Extract-Transform-Load workflows since databases were first invented, but the concept was really formalized back in the data warehouse days. With the cloud, there are more tools, more data sources and more compute to enhance your ETL experiences. Tom talks about how V2 of Data Factory adds SQL Server Integration Service functionality so that you can put your SSIS packages directly into Azure. Data Factory is tied in with Logic Apps, including supporting features like Azure Key Vault. This leads to a great conversation about data-centric vs. application-centric workflows. Your company is sure to have both!