Skip to content

swayam9705/ETL-Workflow-Creator-using-Node-Based-Visual-Programming

Folders and files

NameName
Last commit message
Last commit date

Latest commit

ย 

History

12 Commits
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 

Repository files navigation

NodeFlow: Visual ETL Workflow Creator

NodeFlow is a high-performance, node-based visual programming interface designed to simplify complex Data Extraction, Transformation, and Loading (ETL) tasks. Built with a focus on stream-processing and developer transparency, it allows users to build robust data pipelines without writing a single line of boilerplate code.

๐Ÿš€ Key Features

  • Visual Logic Canvas: Drag-and-drop nodes to define data flows using a high-performance interactive canvas.
  • Stream-Based Engine: Leverages Node.js Streams to process multi-gigabyte files with a minimal memory footprint.
  • Live Data Peek: Inspect data transformations in real-time at any point in the pipeline.
  • Developer-First Design: Export workflows as version-control-friendly JSON schemas.
  • Modular Node Library:
    • Inputs: CSV, JSON, and API Endpoints.
    • Transformations: Filter, Map, Column Selection, Data Cleaning (Regex/Formatting).
    • Outputs: Updated files (CSV/JSON) and interactive visualizations (Charts/Graphs).

๐Ÿ› ๏ธ Tech Stack

  • Frontend: React 19, React Flow (Canvas Engine), Tailwind CSS, Zustand (State).
  • Backend: Node.js, Web Streams API (Processing), Worker Threads (Parallelism).
  • Data Visualization: Recharts.
  • Security: Isolated-vm for sandboxed transformation logic.

๐Ÿ—๏ธ Architecture

NodeFlow separates the Visual Layer from the Execution Layer. The canvas generates a declarative JSON graph, which is then parsed by the Node.js backend to create a pipelined execution sequence:

[Source Node] -> [Transform Node] -> [Transform Node] -> [Output Node]
      |               |                    |                 |
 (Read Stream) -> (Pipe & Map)      ->  (Filter/Clean)  -> (Write/Graph)

๐Ÿ“ฅ Installation & Setup

Follow these steps to get your local development environment running.

1. Prerequisites

Ensure you have the following installed:

  • Node.js: v20.x or higher
  • npm: v9.x or higher

2. Clone the Repository

git clone https://github.com/swayam9705/ETL-Workflow-Creator-using-Node-Based-Visual-Programming.git

cd client
npm install
npm run dev

About

A node based visual editor orchestrator tool for ETL (Extract Transformation Loading) Workflows.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors