Join our newsletter

#noSpamWePromise

Thank you! Your submission has been received!

Oops! Something went wrong while submitting the form.

Integrate your data through CDC

Use less resources with Change-Data-Capture.
Eliminate the need for bulk load updates and analyze data faster.

Request a Demo

How does it work?

Our CDC extractor connects to the SQL server and downloads the so-called log (binary log).

Using the binary log, the extractor is able to capture all events happening to each row in every table of your database instance. Whether it be an update, insertion or even deletion of a row.

These events are then converted into a table in Keboola (usually SnowflakeDB) and replicate what your table actually looks like in your database server.

Keboola offers this functionality to both Keboola-provided and independent database backends

What are the advantages?

It’s fast

Each replication starts where the last one finished, meaning no event gets processed twice.

It’s lightweight

Performance of the SQL server will in no way be affected by the replication.

It’s scalable

There's no limit on how many tables you can replicate - even 200+ tables is okay.

It’s automated

The whole process can be automated using a companion app. If new tables are added to your database, the companion app can fetch these and automatically add them to the replication process. The same applies to the schema changes.

How often can replication be run?

That's completely up to you. You can have the replication running once a day or even every 5 minutes. The CDC replication is fast enough to handle it.

Keboola supports these CDC technologies:

MySQL CDC
AWS Aurora CDC
Oracle CDC
PostgreSQL CDC

Join our newsletter

#noSpamWePromise

Thank you! Your submission has been received!

Oops! Something went wrong while submitting the form.

Join our newsletter

Integrate your data through CDC

How does it work?

Keboola offers this functionality to both Keboola-provided and independent database backends