Want to learn more about event driven ELT? Extract, Load, Transform (ELT) is a process where data is extracted for the source, then loaded into a staging table in the database, transforming it where it sits in the database and then loading it into the target database or data warehouse. In a recent webinar, Principal Consultant Michael French, gives a practical demonstration of how to move data from Azure Blob Storage to an Azure SQL Database using Azure Data Factory and Logic Apps.
Lately we’ve been in conversations with customers about using either Data Factory or Logic Apps for pulling data from applications, maybe using REST API Calls. We’ve discussed why you would use one over the other and we’ve shared how we now favor patterns that use Data Factory and Azure Logic Apps, so it’s not a choice of one or the other.
If you’re just starting out with Azure, you may wonder whether you should use Azure Data Factory or Azure Logic Apps when doing a data integration project in Azure. We get this question a lot. My question is, why not use both? They both have use cases where one may be better than the other but it’s no longer a question of either/or.
If you’re just starting out with Azure Logic Apps and Azure Functions, the difference between these two can be a slightly confusing. In this brief post, I’d like to point out the difference between them and where each fit in the ecosystem.