Etl Tool reviews from Reddit

Summary

We analyzed 333 Reddit reviews across 12 subreddits and 45 posts to rank the best Etl Tool brands recommended by redditors, including communities like r/dataengineering, r/ETL, r/salesforce, r/BusinessIntelligence, r/datascience. Top-rated brands include Talend (3.8/5), Fivetran (4.0/5), dbt (4.4/5).

Stats

Reviews333

Subreddits12

Posts45

Brands84

Products19

Top communities

r/dataengineering222 r/ETL46 r/salesforce19 r/BusinessIntelligence18 r/datascience15

333 reviews from

and

By Brand

By Product

Talend

3.8

(28)

"Has been a game-changer for our team."

"Talend also offers a free version."

"I loved using Talend Open Studio and orchestrating with Rundeck back in the day"

"Pretty terrific"

"Best bets"

"Top free tool right now"

"Talend is easy to use, have lot of integrations inbuilt."

"If you are a small team I can suggest Talend, you can quickly build up ETL with minimum infrastructure setup."

"Talend offers an intuitive interface and strong data transformation features."

"Cost effective"

Fivetran

4.0

(26)

"Fivetran + dbt will solve it for most use cases."

"Fivetran is very popular - they are an industry leader and have a ton of rebuilt connectors. Fivetran just works..."

"Fivetran is my favorite, but also i believe it is probably the most costly of those options."

"Handles data loading from various services"

"Fivetran / airbyte / dlt for data extraction and ingestion"

"Fivetran for the repository and data replication."

"The most common tools are Fivetran and Airbyte."

"Fivetran is only for Extract and Load and it is simple to use so gets wider adoption."

"Fivetran/ Qliks are not ETL per say, but great ELT enablers."

"It's good"

dbt

4.4

(21)

"Dbt simplifies the data transformation process."

"DBT is just a build/modeling tool run on straight sql"

"We actually like our work because of them."

"Dbt is a good option."

"Dbt."

"Run snapshots on raw or staged tables"

"A lot of buzz about dbt lately, it’s focused on SQL, look into it."

"Dbt is a great tool for modeling data, all SQL driven."

"I personally love DBT for a framework."

"DBT for modeling"

Airbyte

4.1

(17)

"Just started exploring airbyte."

"The pricing is fair and per use"

"Both an open-source version and a cloud one"

"I’ve been running Airbyte in a commercial setting for years now. It has gotten substantially better over that time and works well enough for reasonable use cases where data volume is not massive and transfer speed is not expected to be near real time."

"The most common tools are Fivetran and Airbyte."

"Airbyte and Fivetran should be seen as EL tools, not transformation tools"

"**Open-source**: sling-cli, airbyte, peerdb"

"We currently use Airbyte + dbt and built custom connectors for ERP’s."

"Https://airbyte.com is worth checking out. Kind of like FiveTran except open source"

"I would recommend to look into Airbyte."

Apache Airflow

4.0

(15)

"Open source job orchestrator would do the trick for you. Something like Apache Airflow or Prefect if you're a Python user."

"Go for open-source tools like Apache Airflow for data extraction"

"Consider Apache Airflow for orchestration"

"Airflow (orchestration)"

"Airflow should be mentioned. Situation needs to be right though."

"Dbt or sqlmesh + Airflow"

"Dbt and Apache air flow"

"For open-source ETL tools compatible with GCP, consider Apache NiFi, Talend Open Studio, and Airflow."

"I’ve suggested using a mixture of Lambda + Airflow to build a somewhat 'Event-Driven' system."

"Surprised to not have seen Airflow mentioned for scheduling yet. GCP has a lot of connections available for Airflow (e.g. GCS, BigQuery) and you can deploy managed Airflow via Cloud Composer too so you only have to deal with writing Python."

Informatica

3.1

(16)

"Depends on your budget, timeframe and your skillset."

"Informatica all day."

"Cost effective"

"Informatica is a good option for file-based integrations."

"Talend, Mulesoft, Informatica"

"DataStage, Informatica, Talend could be some traditional ETL choices."

"You may want a standard ETL tool like Informatica."

"Some people will have a lot of business people involved, where it can make sense to use visual tools, like Talend and Informatica."

"Cost effective"

"Informatica have modernized for cloud, but, it's for large enterprise."

Matillion

4.0

(12)

"Great program"

"I would suggest giving Matillion Productivity Cloud a go (Cloud SaaS). I'm yet to come across an equivalent ELT Cloud hosted tool that covers both integration and transformation."

"Fantastic"

"GUI based tooling"

"If the datasets are average and transformation are not complex, Matillion works and goes above a simple EL solution."

"Matillion is a top choice for its user-friendly design."

"Your credits are universal within Matillion, so you can start building out jobs in Matillion Data Productivity Cloud any time you like."

"Matillion Cloud is a scalable solution for ETL."

"GUI-based and powerful"

"Good performance and reasonable cost"

Apache

4.9

(8)

"Pyspark is the way to go."

"Airflow"

"Open source. Visual low code / no code. Metadata driven. It is a fork of Pentaho Kettle. It is easy to learn but with a lot of features."

"Pyspark is an excellent tool for big data processing."

"Apache Beam makes this pretty easy with the documentation."

"Lots of good choices mentioned here already, but one more is Apache Hop."

"Apache Airflow is scalable, extensible, and dynamic with configuration-as-code in Python."

"You'll still want to get to know Apache Spark in general."

Pentaho

4.1

(9)

"Best bets"

"Free edition is available and very full featured"

"I'm quite fond of Pentaho personally - free edition is available and very full featured."

"Big fan of Pentaho. Open source and free goes a long way, if you don't mind the occasional bug."

"We have been analyzing Hevo, Talend, Pentaho, Airbyte, etc. They suit very well for SMEs."

"Pentaho is also a strong contender in the free ETL tools space."

"More user-friendly and easier to use"

"It is free and has lots of connectors."

"Pentaho is a good solution if the team building and maintaining the ETL jobs aren't comfortable with Python."

#10

Apache NiFi

4.0

(8)

"Also would recommend checking out Apache NiFi. It’s easy to start with, pretty powerful out of the box and you can customize where you want/need."

"For open-source ETL tools compatible with GCP, consider Apache NiFi, Talend Open Studio, and Airflow."

"If you want a low code versatile data broker, NiFi is a great choice, lots of features and capabilities."

"Apache NiFi could be a good option for you."

"Apache Nifi"

"Have you considered Apache NiFi?"

"You might want to give a tool like nifi a try"

"Apache Nifi"

#11

Airflow

4.3

(7)

"Using airflow for orchestration"

"Python-based"

"Consider running your scripts as Airflow tasks."

"Good for orchestration."

"Airflow for ingress with DBT for transformations."

"Airflow or dagster may be something you'd be interested in."

"If, however, you're going to deal with multiple independent data sources, you might want to look into more complex solutions like Airflow or Nifi."

#12

PySpark

4.0

(7)

"PySpark has become a pretty standard part of many DE stacks, and it's pretty battle-tested"

"Widely applicable and a more generalized skillset in addition to allowing ETL"

"Just use Pyspark."

"Going with something like Pyspark is great if you have a strong team."

"Learning PySpark is valuable, but most ETL work can be automated."

"Pyspark is fine if you have large datasets to process using spark/databrick clusters."

"Haven't used pyspark but we don't have big data requirements (yet)."

#13

dlt

4.5

(6)

"Dlt worked great for me getting salesforce to big query."

"Has a small learning curve compared to a gui tool, but absolutely was worth the investment for me."

"Open source, external (us) maintenance, runs on any env, means you cannot beat it in terms of price and privacy."

"Dlt (the python library, dlthub.com not Databricks Delta Live Tables) is great, but has a pretty steep learning curve."

"+1 to dlt, dbt, and sqlmesh."

"Gonna give this a try."

#14

Apache Hop

4.0

(6)

"Apache Hop (ETL pipeline)"

"Have you checked out Apache Hop?"

"Apache hop."

"Check out Apache Hop!"

"You might want to also check out Matt Casters' latest project, Apache Hop."

"Apache hop easily does all that"

#15

Integrate.io

4.6

(5)

"Streamlined our data processes significantly."

"Integrate.io has done the job for my team for 3 years. No complaints."

"We did a pilot with Integrate.io three months ago and found they make data pipelines work faster than anyone else's."

"Is user-friendly."

"Gave Integrate.io a try and was straightforward overall, which is a win when I have a billion-and-one-things on our plate."

#16

Meltano

4.4

(5)

"Meltano + dbt is a great option."

"Use airbyte or meltano, or the best tool ever python, but if you wanna give a good platform, use meltano + python and dbt with airflow or dagster as orchestrator."

"Using meltano for staging/replication"

"Meltano for ingestion DBT (Core) for transformation, if you're good with ELT"

"Can probably make things work"

#17

Hevo

4.4

(5)

"Really like it"

"We use Hevo for E&L for easy built-in integrations and webhooks."

"If you want a no-code kind of thing, go for Hevo."

"We have been analyzing Hevo, Talend, Pentaho, Airbyte, etc. They suit very well for SMEs."

"If you want to use a single platform for both of your needs, I recommend using Hevo Data."

#18

Azure Data Factory

3.5

(6)

"Azure data factory the best one. Easy to maintain, easy to develop, easy create dynamic pipelines."

"Azure Data Factory is a solid choice"

"Then now using azure data factory. But that’s not open source."

"No one uses azure data factory?? It's common where I've been..."

"I’ve heard of Data Factory, and a tool hosted by any of the cloud services (AWS, GCP, Azure) is going to have better support and lifespan than something like the version of Pentaho that’s still around today."

"IICS, GCP Datafusion , azure data Factory"

#19

Snowflake

4.2

(5)

"One of the best etl tools"

"Snowflake, Fivetran for the repository and data replication."

"Snowflake is a lot easier to use compared to other solutions."

"Snowflake is among the top technologies to consider."

"Snowflake also has some integrations that work directly with Azure Blob storage."

#20

4.5

(4)

"Dagster is great, and it’s open source."

"Great too"

"Dagster for orchestration"

"Dagster and dbt."

#24

KNIME

4.3

(4)

"I like KNIME"

"KNIME all the way."

"If open-source is appealing, be sure to check out KNIME"

"KNIME. You need to install a separate node to allow python scripting but it is a great mix of both worlds IMO."

#25

Stitch

4.0

2.5

(2)

"Redshift is missing a lot of functionality inherent in Postgres."

"The issue with Redshift, and probably the main driver for us moving to Azure, is that it's really designed to ingest from S3 only."

#53

Atlan

5.0

(1)

"Made tracking lineage and ownership way smoother."

#54

Pentaho Data Integration (PDI)

5.0

(1)

"My engineer built a very complex and fully automated ETL solution with PDI, a VM, and a cron job scheduler. Currently migrating it to Apache Hop. He won’t use anything else. He is obsessed with PDI/Apache Hop."

#55

SQL Server Integration Services

2.0

3.0

(1)

"I use Data360 Analyze. It has connectors to a lot of the applications you mentioned. You can get a free download of the desktop product."

#84

R

2.0

(1)

"I've used R as an ETL tool to build a data warehouse from scratch."

Discover your audience

GummySearch is an audience research toolkit for 130,000 unique communities on Reddit.

If you are looking for startup problems to solve, want to validate your idea or find your customers online, GummySearch is for you.

Tell me more

Get started