Project / Employee API

Tired of querying the same databases over and over I decided to write my own API.

I created read only / local copies of the accounting database, employee database and project records (Deltek Vision), cross referenced that with internal MySQL databases and OpenAsset to create a single point of access for anyone to use.

A boring looking output for the amount of work, but already being used on multiple projects including some not before thought of use cases like Bluebeam.

Technologies used: Javascript, PHP, JSON, MariaDB, MSSQL, Powershell