|
Change Data Capture |
Scroll |
Every organization has front and back office systems that together form the infrastructure supporting day to day operation and frequently contain the most current information about a particular business function. Precisely's Connect CDC SQData Change Data Capture capability makes that real-time data available to other tactical and strategic business functions without disrupting or requiring modification to both legacy and newer business applications. Changed Data Capture provides a gateway to connect your business infrastructure to Data Warehouses, Data Lakes and analytical tools designed to find the hidden value in all that data as well as improve the accuracy and usefulness of the information through Precisely's full Data Integrity suite.
Technically Change Data Capture Agents operates under constraints that vary from one platform to another. Near Real-Time data capture is accomplished on most platforms using the transaction log, maintained by the database manager for the purpose of database recovery. Historically, these logs have also been the source of data for other purposes including audit or replication. Generally it is necessary to configure the database manager to include additional information in the log for use by these non-recovery related activities.
This Guide provides describes Change Data Capture, its general operational characteristics and role in active/active replication scenarios. It also includes a brief description of the capture agents, publishing options supported, the Engines and information on configuration, and operation.
•Selecting a Data Capture Agent
•Transient storage requirements and Publishing methods
•Apply and Replicator Engine Overview
Other sections below provide a detailed reference to the Connect CDC SQData Change Data Capture for the following database and/or file systems:
