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.