Has anyone researched using Oracle streams with Banner database , inorder to integrate other applications with Banner Database , or any other suggestions.
Yes, we are using Oracle Streams, in a down stream mode to keep the load off the production database. Currently we are streaming data to our custom built warehousing environment in order to remove the Extract from our Banner database. We use triggers and delta tables on the down stream database that receives the replicated data to capture and process only the true delta. As you may know, activity date cannot be relied upon across all Banner tables (and some do not have the column). We're also using Streams in dev currently to ship data to a new "Global Campus" initiative we're building.
If you would like more info on how we're using Streams send me an email at sharden@uillinois.edu
Banner - Oracle Streams
Yes, we are using Oracle Streams, in a down stream mode to keep the load off the production database. Currently we are streaming data to our custom built warehousing environment in order to remove the Extract from our Banner database. We use triggers and delta tables on the down stream database that receives the replicated data to capture and process only the true delta. As you may know, activity date cannot be relied upon across all Banner tables (and some do not have the column). We're also using Streams in dev currently to ship data to a new "Global Campus" initiative we're building.
If you would like more info on how we're using Streams send me an email at sharden@uillinois.edu
Scott Harden
Univ. of Illinois