opensearch-project / opensearch-project/data-prepper

Support CDC from Postgresql

Open
#3,234 0 comments 2 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

enhancement
Dominant language
Java
Stars
374
Forks
354
Avg merge
3d 18h
Merged PRs (30d)
8

Description

Is your feature request related to a problem? Please describe.
I would like to use data-prepper to ingest CDC from Postgresql database, including Aurora DB

Describe the solution you'd like
Support Kafka Connect with Debezium Postgresql connector plugins

Describe alternatives you've considered (Optional)
N/A

Additional context

connect-pipeline:
  source:
    kafka_connect:
      worker_properties:
        group_id: group
        config_storage_topic: pipeline-configs
        offset_storage_topic: pipeline-offsets
        status_storage_topic: pipeline-status
      postgresql:
        hostname: localhost
        credentials:
          type: aws
          region: us-east-1
          secretId: secretId
        tables:
          - topic_prefix: prefix1
            database_name: dbname
            table_name: public.tableName1

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

The request defines a Kafka Connect source using Debezium's PostgreSQL connector, including Aurora DB credentials and table configuration, but names no files, tests, or entry points. Start by locating the existing Kafka Connect source configuration and determine how PostgreSQL CDC support should fit; done means the proposed configuration is supported and the integration is verified.

Written by the indexing model from the issue text.

Assessment

Tech stack
aws, java, kafka, postgresql
Domain
data-engineering, databases, stream-processing
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.