Hi Jeff, can you tell me more about how are you handling your clients? Can you guide me on a better approach?
My system provides api for 4 partners (and keep on growing). I cannot control each partner requests and needs. I wanted to put a middle-tier server to manage connections and load on the system, but this wasn't enough for me - The third partner required some extra api requests that I cannot expose to all other partners, this includes additional indexing, columns & procedures. Ah, and I need to give free SQL access to each partner for his own real-time data, without exposing other partners (That's part of the basic requirement, note that I am the system architect but each partner have his own DBAs as well).
Thanks