Skip to main content
ClickHouse

  •  Sink Connector

    Innovate Faster, 

    Drive Higer Value

Unlock real-time SAP data and unleash it in Clickhouse, the fastest analytical database, with One Connect.


Key Benefits of the Custom Connector: 


COMPABILITY

Works smoothly with a wider range of ClickHouse versions, without needing frequent upgrades.​​

CUSTOMIZATION

Designed to fit your specific business needs, with flexible ways to process, validate, and insert data.​​​

CONTROL AND VISIBILITY

Offers detailed control over how our data is structured and errors are handled and integrates with our internal monitoring tools.

FEATURES

Idempotent Writes

-Default mode: insert.mode=insert (standard row insertions).

-Optional: insert.mode=upsert (inserts or updates on primary key 

conflict). 

-Ensures idempotent delivery—ideal for exactly-once or retry-safe pipelines. 

Schema Support

-Supports Avro for both key and value schemas. 

-Compatible with Confluent Schema Registry. 

-Strong schema logging for safe pipeline evolution and auditing. 

Auto Table & Column Creation 

-Enable with auto.create=true and auto.evolve=true.

-Automatically creates missing tables and columns in ClickHouse. 

-Dynamically names tables based on Kafka topic names. 

Raw Data Ingestion 

-Mode: insert.mode=insert, pk.mode=none. 

-Allows ingesting raw data without primary keys. 

-Ideal for denormalized or append-only data models. 

TABLE AND SCHEMA SETTINGS

These settings control how tables are named, created, and kept up to date in Clickhouse. 
They help reducemanual work and keep data organized as it flows in.

Example Use Case: SAP Operational intelligence