Blog & Company Updates

Why Not Use Azure Data Factory AND Logic Apps?

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.

Here are my thoughts about how there’s room for both:

  • Azure Data Factory is better designed for retrieving data sets from cloud sources like databases or an online app like Salesforce that has direct integration with Data Factory, as well as something that provides larger data sets that can be loaded into a table or a flat file, for example.
  • Logics Apps would be better compared to Azure Data Factory with other data sources, like when you need to reference a REST API, for instance.

We’ve worked on many projects recently where we’ve got a lot of data coming from set-base sources where Data Factory is a logical fit, but we also have other data that we need to access an application via a REST API and Logic Apps works better in that case. So, in this situation, it’s not a matter of choosing one vs the other but we use an approach using both.

As with many cloud technologies today, neither of these require any upfront costs or equipment to get started, so you don’t have to choose one over the other – as cost is not a factor, I encourage you to use both.

Need further help? Our expert team and solution offerings can help your business with any Azure product or service, including Managed Services offerings. Contact us at 888-8AZURE or  [email protected].

Author

  • Bob has broad experience designing and implementing Business Intelligence and Data Warehouse solutions on the Azure and Microsoft SQL Server platforms. He has spoken at SQL Saturdays and has presented webinars on various cloud architecture and data management topics.

Bob RubockiWhy Not Use Azure Data Factory AND Logic Apps?