Learn how Keboola and Azure Data Factory stack up against each other in this 8-step comparison post.
ETL pipelines help companies extract, transform, and load data so it is ready to provide insights and value to the company.
But running a smooth data operation depends on building reliable and scalable data ingestion pipelines.
They build software that collects data, transforms and cleans it, and loads it to a destination of your choice, without having to worry about coding the solution yourself, maintenance, or scaling problems.
In this article, we explore the 8 critical differences between Keboola and Azure Data Factory (ADF), to help you better decide which one is best for your DataOps:
Both Keboola and Azure Data Factory are ETL tools (or data ingestion tools) that help you speed up the build and later automate your data pipelines.
Relying on a software vendor for your ETL (extract, transform, load) has multiple advantages:
Both solutions go beyond simple ETL. As end-to-end platforms, they both offer monitoring, data governance capabilities, and managed DataOps deployment and scaling via the use of cloud technologies.
The main use of an ETL tool is to facilitate the movement of data from one location to another without much supervision.
ETL tools achieve this with integrations - often called “connectors” or “components”. Each connector is specialized for one data source or data destination. For example, the “Facebook Ads” connector would be specialized for extracting data from the Facebook Ads platform.
How do the two tools compare on integrations?
Coverage. Azure Data Factory is almost exclusively focused on covering the Microsoft datascape (integrates with Azure Blob Storage, Azure Data Lake, …) with the rare exception of other vendors. For instance, Amazon Redshift for warehousing, SalesForce for CRM, etc. Keboola, on the other hand, covers the most common data use cases in a company:
Sometimes you will have to extract data from sources and 3rd Party Apps that are not covered by the vendor. How are the two solutions prepared for custom sources?
Both Keboola and Azure Data Lake offer users the capacity to build custom data extractors.
Keboola offers its Generic component to import data from almost any REST API and countless other APIs. The component acts as a customizable HTTP REST client. So, you can build your custom data source extractor. The universal extractor does not require programming prowess, you can write your extractor as a JSON.
Data transformations include all the data wrangling and cleaning necessary to prepare data for analysis and insights extraction. For instance, aggregating data into metrics, removing outliers and corrupted metrics, standardizing formats, etc.
Both vendors offer a wide variety of transformations in script-form, using a scripting language.
Keboola focuses on the lingua francas of data scientists and data engineers and exposes transformations in the programming language your engineers and scientists love best (SQL, Python, R, Julia, Spark …).
Azure Data Factory is more imposing regarding transformations. The solution puts PowerQuery as the main transformation tool (better learn it!). You can also pick other Big Data technologies like Spark transformations or Hadoop MapReduce, but you need to configure the transformation environment yourself before accessing the additional languages.
Both vendors understand that there are multiple paradigms and choices of data architectures, so you can run transformations under either the ETL or ELT paradigm.
Azure Data Factory offers advanced analytics, BI, and artificial intelligence by integrating into Microsoft's app ecosystem. Users can send their data to Power BI for business intelligence or machine learning apps like Azure Cognitive Services (check the full list here).
Keboola, on the other hand, lets the user decide what applications they would love to use for their competitive advantage.
It offers a wide variety of integrations to BI tools (Tableau, Looker, Power BI, GoodData, Sisense, ...), machine learning applications (like Google NLP, Azure ML, ...), or pre-built scaffolds (automated recipes) that automatically run common machine learning (and data engineering) tasks.
Both vendors offer the power of automation to their users via orchestrated jobs.
The jobs can cover any data engineering task, such as extraction, cleaning and transformations, and loading data to the destination of your choice.
The orchestration aspect shows maturity in both solutions, since jobs can be scheduled, chained, parallelized, automated, and monitored with little work.
The main difference is in the technical support - when you request help or submit a ticket.
Keboola always offers extensive support at no extra charge to you for any custom inquiries. And it is not just free, it is also of superb quality: users have consistently rated Keboola’s customer service with 5/5.
Unlike Azure Data Factory that only offers paid support starting at $29/month (“developer” support package for non-production environments or during trial and evaluation) to $1000/month (“professional direct” support package for medium-size to large companies using Azure). The support price tag is hidden under Azure’s service charges.
Both vendors are on top of their fields, with extreme user satisfaction in comparison to their competitors. Looking at the Gartner reviews, Keboola scores a whooping 4.9/5 overall satisfaction, while Azure Data Factory scores 4.6/5.
Pricing is a critical factor for making a tooling decision.
Azure Data Factory has a complicated pricing model, where plan costs are computed as a combination of hardware, compute hours, number of orchestrated jobs, and read/write (I/O) operations. The pricing model is hard to understand unless you are familiar with cloud computing cost estimations (you can use a calculator here to make your life easier).
The bottom line is the following:
Contrast this to Keboola.
Keboola offers three plans: an always-free plan ($0/month), a pay-as-you-go-plan (PAYG), and a subscription plan.
You are charged for the Time of processing. Every account gets 300 free minutes a month (free plan), then pays 14 cents per additional minute. In case your needs are greater, custom subscription plans are available.
Both Azure Data Factory and Keboola are state-of-the-art tools in the data integration vertical.
We compared both ETL and DataOps tools across 8 dimensions:
Ultimately, the choice of tools will depend heavily on what your enterprise’s needs will be.
But to make the choice easier, here are three important questions to consider: