Integration analytics dashboard

Scheduled tasks move staff and student data into the SIS every day, each pulling from a different system in a different way. They ran quietly on their own, so when one failed quietly too, stale or missing data could sit unnoticed for days before anyone caught it downstream.

A monitoring layer sits beside the integrations and makes their daily runs visible, without touching the data itself.

Each scheduled task logs its run: success or failure, and how many rows it moved. From that log, a morning email flags any warnings or failures so bad runs get caught first thing, and a dashboard shows every run's status, row counts, and a health check at a glance.

I scoped the console with the client team and sketched the screens before writing any code. Then I built it in React and Node on SQL Server. The email rules came last, set per integration so every alert means something.

Before the Console, a failed integration only surfaced when someone noticed incorrect or missing data downstream, sometimes days after the fact. Now, failures show up the same morning they happen. Six integrations and 50+ scheduled tasks are monitored in one place, and the team gets a daily email at 8am flagging anything that needs attention. Bad runs get caught before they become data problems.