Changed Data Capture

THE KEY TO INTEGRATION

SQData supports the near real time capture and apply (replication) of IMS, CICS/DLI, DB2/390 and VSAM data to any SQData supported datastore format. This capability allows you to keep your source and target databases in sync without having to schedule costly full data extracts.

As the changed data is captured, you can leverage the power of the SQData Integration Engine to perform the data transformation,
conditional logic, filtering, JOINs, lookups, normalization, etc.

Key Features:


• Non Intrusive changed data capture for all sources, requiring no application changes.
• Smart Apply feature facilitates the coordination of full data refresh process with ongoing propagation.
• Near Real Time data/event capture of:
          • IMS data for both IMS/DC and CICS/DLI
          • VSAM for both CICS and batch programs
          • DB2/390 databases
          • Distributed databases such as DB2, UDB, and Oracle
• Extended data replication framework features include:

          • Capture data changes into MQSeries queues and/or an SQData VSAM CDC Journal
          • Deferred (asynchronous) changed data capture of IMS for both IMS/DC and CICS/DLI
          • Assign certain captured objects (i.e. segments, files, tables, etc.) to specific MQSeries queues.
          • Include or exclude specific programs/transactions from changed data capture.
          • Auto-disable - allows critical applications to complete in the event of error (i.e. queue full condition)

Download Product Information