So did you guys know you can connect to peoplesoft through a webservice called ogate? You can build queries in peoplesoft, and call them in an awesome web service built right here at UTO.  It allows realtime queries to the peoplesoft database (to try and replicate some of the functionality of the data warehouse, enterprise1, which has been shut down). 

I've applied for peoplesoft access and I'm awaiting the ability to use the query manager to create queries in peoplesoft. In the meantime, I'm reading up on the ogate blog. I'm hoping this will be the answer for all those old apps campuswide that used to depend on data warehouse connectivity.