« SZRADMT - Admitted students by Term/Level | Main | Work Report »

February 07, 2007

Virtual Data Warehouse

The Virtual Data Warehouse is a program that we use to provide real-time student data for our SIS BI-Query clients on campus. It's a fairly complex process that involves both our local DB server (as a listener) and our remote SIS database. It uses embedded perl code to fetch real-time data from the SIS database. It recently broke and since a few of staff and I spent a good amount of time trying to get it going again I figured I'd write up an overview and some technical notes on how it runs. You can find the documentation and a backup of of important files in this directory: I:\Programmers\Banner SIS\oracle_obj_srvr\

Posted by soukupm at February 7, 2007 09:33 AM

Comments

Post a comment

Thanks for signing in, . Now you can comment. (sign out)

(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)


Remember me?