Open Source Visual ETL

Apache NiFi

• A powerful data integration tool that supports data routing, transformation, and system mediation logic.

• Features a user-friendly web interface for designing data flows visually.

Talend Open Studio

• An open-source integration software with a graphical interface for designing ETL jobs.

• Supports various data sources and has a vibrant community around it.

Pentaho Data Integration (PDI)

• Also known as Kettle, it provides a comprehensive set of features for data integration, transformation, and loading.

• Offers a user-friendly graphical design environment.

Apache Hop

• A newer project aimed at simplifying data orchestration and transformation.

• Features a visual interface for designing complex data workflows.

KETL

• An open-source ETL tool that provides a web-based interface for building data workflows.

• Supports various data sources and transformations.

Airflow

• While primarily a workflow orchestration tool, it can be used for ETL processes with the right operators.

• Offers a web-based UI for monitoring workflows.

Mara ETL

• A lightweight ETL framework that focuses on simplicity and usability.

• Provides a way to create and manage data pipelines with minimal overhead.

Luigi

• A Python package for building complex data pipelines.

• While it requires some coding, it can be visually monitored through a web UI.

Amphi ETL

• A user-friendly tool designed for data integration, transformation, and loading.

• Features a visual interface, supports multiple data sources, and offers job scheduling capabilities.

KNIME

• An open-source analytics platform that supports data integration, processing, and visualization.

• Offers a visual workflow designer and a vast array of extensions for advanced analytics and machine learning.

Talaxie

• A visual ETL tool that focuses on data integration and transformation.

• Provides a user-friendly interface for designing data workflows and supports various data sources.