Here's Chasing Blue Skies' website tools diagram showing from the front-end through backend connections and tools used. It might not always be up to date, but the core elements are pretty stable.