In business environments where database changes and updates must be synchronized and communicated to other systems, Unwired Orchestrator works together with Database Event Management and the Sybase Replication Server to meet this need.
Replication Server can be an event source for Unwired Orchestrator. Database events produced by Replication Server are captured and managed by Unwired Orchestrator, enhancing traditional replication event handling by the ability to manage the events using business processes. The ability to proactively push significant database events into business management systems makes Replication Server an excellent fit with Unwired Orchestrator.
The following diagram shows a sequence of processing whereby a database event is replicated by Replication Server, retrieved and processed by the RepConnector component of Unwired Orchestrator with Database Management, placed on a transport, and retrieved and processed as part of an Unwired Orchestrator business process that uses a replication event service.
Replication Server simplifies data movement and synchronization across the enterprise. Using replication, the process of creating and managing duplicate versions of a database, database events are copied and synchronized as a set of replicas so that changes made to one replica are reflected in all the others. Replication Server allows DBAs to quickly setup redundant disaster recovery sites and synchronize data across heterogeneous database platforms -- Sybase ASE, Oracle, IBM DB2 and Microsoft SQL Server. By moving and synchronizing data easily, companies gain economic value by sharing data sitting in application silos with other applications when and where needed.
Replication Agents are configured to detect changes to data in source databases. The agents then publish, or send, the change data to Replication Server. Replication Server routes the change data, as a database event, to its designated destinations. Replication Server can be configured to initiate a database event, based on a insert, update, or delete database operation, whose destination is RepConnector, a component of Unwired Orchestrator with Database Management.
To configure database event management, Unwired Orchestrator with Database Event Management must be licensed and installed and an existing implementation of Replication Server must be available in your environment. Installed with Unwired Orchestrator with Database Event Management, the RepConnector component is configured to listen for database events from Replication Server. RepConnector transforms each database event to an XML document, then uses a message transport to push the events to Unwired Orchestrator.
The database event is retrieved by the RepConnector component of Unwired Orchestrator and formatted into a database event message. The RepConnector component places the database event message on a message transport, typically a queue, that is polled by Unwired Orchestrator.
The arrival of the database event message on the message transport instantiates an Unwired Orchestrator business process. Once instantiated, the business process can transform, aggregate, and re-publish the original database event to interested systems, or coordinate the application of updates to non-database systems.
Business processes are designed to incorporate a Replication Event service, using the Unwired Orchestrator tooling. The Replication Event service provides the connection where the database event instantiates the business process.
Review Database Event Management Requirements before Configuring Database Event Management.