pythonicshahdev/datahub-mysql repository overview

⁠Boomi DataHub Accelerator — Academic Source (MySQL)

⁠What's Inside

A single database (academic_sis) with 5 tables pre-populated with realistic academic institutional data — real university names, realistic field values, and FK relationships baked in.

⁠FK Hierarchy

Institution (20)
    └── Department (200)
            ├── Faculty (200)
            ├── Course (200)
            └── Student (200)

All tables include a modified_date TIMESTAMP column that auto-updates on every row change — ready for incremental polling patterns out of the box.

⁠Quick Start

docker run -d \
  --name datahub_mysql \
  -p 3307:3306 \
  pythonicshahdev/datahub-mysql:latest

Connect immediately — no wait for seed scripts:

mysql -h 127.0.0.1 -P 3307 -u root -proot academic_sis

⁠With Docker Compose (recommended)

services:
  mysql:
    image: pythonicshahdev/datahub-mysql:latest
    container_name: datahub_mysql
    environment:
      MYSQL_ROOT_PASSWORD: ${MYSQL_ROOT_PASSWORD:-root}
    ports:
      - "${MYSQL_EXTERNAL_PORT:-3307}:3306"
    volumes:
      - mysql_data:/var/lib/mysql
    restart: unless-stopped

volumes:
  mysql_data:

⁠Connecting from Boomi

This image is designed to be consumed by a Boomi local atom running alongside it. Use host.docker.internal as the hostname from within Docker containers:

Boomi Connector: Database V2 (officialboomi-X3979C-dbv2da-prod)

⁠Sample Data

Institutions include real universities with realistic data:

• University of Texas at Austin, MIT, Stanford, Harvard, and 16 others
• Fields: national ranking, endowment ($B), acceptance rate, graduation rate, student:faculty ratio

Students include realistic profiles:

• GPA (0.0–4.0), enrollment status, degree type, advisor assignment
• Emergency contact, scholarship, tuition balance

⁠Environment Variables

⁠Part of the Boomi DataHub Demo Accelerator

This image is one component of a multi-source DataHub demo. The full stack includes:

Together they feed Boomi DataHub as golden record hub via 7 inbound integration processes, demonstrating scheduled polling and event-driven enrichment patterns.

⁠Architecture

MySQL (Academic SIS)          FastAPI (Commercial)
  institutions_raw    ──┐       /customers
  departments_raw     ──┤       /products          
  faculty_raw         ──┼──▶  Boomi Integration  ──▶  Boomi DataHub
  courses_raw         ──┤       Groovy Transform        Golden Records
  students_raw        ──┘       DataHub POST

⁠Source & Issues

Built and maintained by Shah