vixtract
ViXtract is an open-source ETL platform built on Python that enables BI analysts to independently extract, clean, and transform data without relying on ETL developers. It combines three main components: Jupyter as an interactive Python environment, PETL as a straightforward data transformation library, and Cronicle as a task scheduler with monitoring and orchestration capabilities. The platform is installed via a single command on Ubuntu 18.04 LTS, with optional HTTPS setup through Let's Encrypt, and includes preconfigured JupyterHub with JupyterLab, Anaconda environment manager with separate dev and prod kernels, PostgreSQL with an etl database, Nginx, S3FS for cloud storage mounting, and Papermill for notebook-based task execution. Installation prompts for domain settings, HTTPS consent, user credentials, Cronicle admin password, and PostgreSQL etl password. Post-installation configuration is handled through a conf.sh script supporting options for user account management, SSL toggling, hostname settings, S3