Skip to content

osp-ottogroup/movex-cdc

Repository files navigation

Track changes in relational databases and transfer them to Kafka

This product captures data change events (Insert/Update/Delete) in relational databases and immediately transfers them to a Kafka event hub.

The full documentation of this product can be found here:

Introduction

CDC solutions are often based on processing of the write ahead logs / redo logs like using the XStream API, LogMiner etc. for Oracle. Besides the licensing needs this also require intervention in the operation of the DB. This can present hurdles, e.g. in migration scenarios for legacy applications or for managed cloud DBs.

This application addresses these issues:

  • without interfering with DB’s operations or structures
  • with isolation of all DB objects required for CDC in a separate DB schema
  • Scalable up to billions of events/day

The capture of change events is based on table level triggers. All functions for bootstrapping, API, web GUI for configuration, trigger generation and event transfer to Kafka are encapsulated in one Docker container.

Supported database systems

  • Oracle Oracle databases with Release 12.2 and higher
  • SQLite The additional implementation for SQLite ensures that the product remains database independent.

Usage

MOVEX Change Data Capture is available as a comprehensive Docker image.

Quick start demo

Establish change data capture on Oracle DB including the event transfer to Kafka within 10 minutes.
Here you find the how-to guide to quickly get up and running.

Releases

Production-ready releases are tagged with release number and can be pulled from Docker hub by:
docker pull ottogroupsolutionproviderosp/movex-cdc:1.7.0

The current production-ready release is also tagged with :latest and can be pulled without a tag by:
docker pull ottogroupsolutionproviderosp/movex-cdc

The latest build of the development master branch is available by:
docker pull registry.gitlab.com/osp-silver/oss/movex-cdc:master

Release notes

See CHANGELOG.md

License / Support

MOVEX Change Data Capture is a product of the Otto Group One.O GmbH.
This product can be used under the terms and conditions of GPL 3.
One.O is the IT service provider of the Otto Group, formerly known as Otto Group Solution Provider (OSP) GmbH.
If you are interested in commercial support please reach out to movex-cdc@og1o.de.

Roadmap

The tool has been developed independently of a particular database system. First implementations were for SQLite and Oracle with focus on production use for Oracle Enterprise Edition with Partitioning option.
Further planned implementations include:

  • Production readiness for Oracle Standard Edition / EE without Partitioning Option
  • Adaptation for PostgreSQL and MS SQL Server, but only if there are significant advantages compared to the existing solution Debezium

Project status

It is already used in production with Oracle databases. Further development is ongoing.

Further resources

About

Solution for change data capture from relational databases (Oracle, SQLite) to Kafka. This repository is mirrored from https://gitlab.com/osp-silver/oss/movex-cdc

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors