Extract and load operational data into your cloud
data platform in near-real time, without coding.
Using Matillion CDC, we unlock the ability to deliver complex insights significantly faster. This led to a 95% improvement in time-to-complete which is a real game changer for us.
Analyzing operational data quickly can make the
difference between success and failure. Waiting a
day or even an hour for data to arrive, only to find out
that some data changes may not have been
captured, is not a recipe for success.
But there's a better way. Matillion Data Loader uses log-based CDC tocapture every change event as it occurs, with no impact to database performance. Data is securely delivered to its destination in near-real time.
1. Configure your CDC Agent.
The Agent runs in a container
within your private cloud or on-
premises data environment.
2. Create your CDC pipeline.
Select the CDC Agent you want
to use, and configure your pipeline
with your source and destination
3. Deploy your CDC pipeline.
Instruct your CDC Agent to
perform an initial load, and then
monitor your database log file,
extract changes as they occur, and
load them into cloud storage.
Unlike point-in-time snapshots that may miss multiple data changes in between snapshots, Matillion CDC monitors low-level database change logs to capture every event as it occurs. You get complete, accurate, and timely data for near-real time analytics.
Matillion CDC loads raw data in standard Avro format into your cloud storage* destination. This maintains an immutable history for audits, and enables data scientists and AI/ML modelers to use the data immediately to perfect their algorithms and models.
*Amazon S3, Azure Blob Storage, or Google Cloud Storage
Matillion CDC uses a containerized Agent, deployed in your private cloud or on-premises environment, to securely extract change data and load it into your cloud storage.
* Only configuration details, commands, and metadata are passed to or from Matillion. No data or access credentials are ever exposed outside of your firewall.
Keep data flowing through “self-healing” pipelines that automatically adapt to schema changes and propagate them to the destination, without assistance from IT or the need to code.
Once raw data is loaded, you can use Matillion ETL to transform your data for near-real time analytics. Build sophisticated data workflows through an intuitive ‘code optional’ interface, and quickly prepare data for consumption in your cloud analytics tools.
Extract and load operational data into your cloud data
platform in near-real time, without coding, with Matillion
Change Data Capture.