Objectives:	Key design considerations when planning a Change Data Capture configuration. Design considerations for setting up change notifications. Design pattern for interacting with a JMS queue from an Oracle stored procedure.
Abstract:	This case study describes the implementation of a near real time data integration using Oracle change data capture, database change notification, and Java Message Services. The feeding system is an in-house developed provider information application running on Oracle 10g on AIX. The receiving system is a commercial contract management system using a SQL Server database. The business requirement is for changes to specific data in the provider information application to generate updates to the contract management system within minutes. Database change notification is used to initiate a stored procedure which checks the CDC change set to determine the type of change. The procedure applies the appropriate business rules based on the type of change and prepares a message that is delivered to the contract management system via the Java Message Service.
Audiernce Focus:	Architects
Expertise:	Intermediate
Track:	Business Intelligence/Warehousing
Date:	Tuesday, April 15, 2008
Time:	11:00 AM - 12:00 PM