Stream data from Pendo to ClickHouse Kafka API
Move data from Pendo to ClickHouse Kafka API in minutes using Estuary. Stream, batch, or continuously sync data with control over latency from sub-second to batch.
- No credit card required
- 30-day free trial


- 200+Connectors
- 5500+Active users
- <100msEnd-to-end latency
- 7+GB/secSingle dataflow
How to integrate Pendo with ClickHouse Kafka API in 3 simple steps
- 1
Connect Pendo as your data source
Set up a source connector for Pendo in minutes. Estuary supports streaming (including CDC where available) and batch data capture through events, incremental syncs, or snapshots — without custom pipelines, agents, or manual configuration.
- 2
Configure ClickHouse Kafka API as your destination connector
Estuary supports intelligent schema handling, with schema inference and evolution tools that help align source and destination structures over time. It supports both batch and streaming data movement, reliably delivering data to ClickHouse Kafka API.
- 3
Deploy and Monitor Your End-to-End Data Pipeline
Launch your pipeline and monitor it from a single UI. Estuary guarantees exactly-once delivery, handles backfills and replays, and scales with your data — without engineering overhead.

Pendo connector details
The Pendo capture connector in Estuary captures product, account, visitor, guide, and event data from Pendo through its API and loads each selected resource into a separate Estuary collection. This makes Pendo data available for downstream analytics, warehousing, and product intelligence workflows.
- API-based data capture from Pendo
- Supports account and visitor data
- Captures product metadata, including features, pages, guides, reports, segments, and track types
- Captures behavioral event data, including page events, feature events, track events, guide events, and poll events
- Separate Estuary collections for each selected Pendo resource
- Configurable replication start date to control how far back data is captured
- Regional Pendo host support for US, US1, EU, Japan, and Australia environments
- Pendo API key authentication
By default, the replication start date is set to one hour before the current time, though you can configure an earlier date when historical data is required. The connector requires a Pendo account with the integration feature enabled and a valid Pendo API key.

ClickHouse Kafka API connector details
The ClickHouse Kafka API connector uses Estuary’s Dekaf compatibility layer to expose Estuary collections as Kafka-compatible topics that ClickHouse Cloud can ingest through ClickPipes. Instead of managing your own Kafka broker, you create a Dekaf materialization in Estuary and configure ClickPipes to read from Estuary using Kafka-compatible connection details. This is useful when your ClickHouse workflow depends on ClickPipes or when you want ClickHouse Cloud to manage the ingestion path.
- Materialize Estuary collections as Kafka-compatible topics that ClickHouse ClickPipes can consume.
- Use Dekaf when you want to ingest into ClickHouse Cloud through ClickPipes instead of writing directly with Estuary’s native ClickHouse connector.
- Connect ClickPipes using Estuary’s Dekaf broker address, schema registry address, SASL_SSL, and the PLAIN SASL mechanism.
- Use the full Dekaf materialization name as the Kafka and schema registry username.
- Use the Dekaf auth token as the Kafka and schema registry password.
- Map each Estuary collection binding to a Kafka-compatible topic for ClickHouse ingestion.
- Stream CDC updates from source systems into ClickHouse with low-latency, incremental delivery.
- Configure deletion behavior based on how you want ClickHouse to handle CDC-aware deletes and Kafka-style delete events.
Estuary in action
See how to build end-to-end pipelines using no-code connectors in minutes. Estuary does the rest.
Spend 2-5x less
Estuary customers not only do 4x more. They also spend 2-5x less on ETL and ELT. Estuary's unique ability to mix and match streaming and batch loading has also helped customers save as much as 40% on data warehouse compute costs.

Pendo to ClickHouse Kafka API pricing estimate
Estimated monthly cost to move 800 GB from Pendo to ClickHouse Kafka API is approximately $1,000.
Data moved
Choose how much data you want to move from Pendo to ClickHouse Kafka API each month.
GB
Choose number of sources and destinations.
Why pay more?
Move the same data for a fraction of the cost.



What customers are saying
Getting started with Estuary
Free account
Getting started with Estuary is simple. Sign up for a free account.
Sign upDocs
Make sure you read through the documentation, especially the get started section.
Learn moreCommunity
Join the Slack community for the easiest way to get support while getting started.
Join Slack CommunityEstuary 101
Watch the Estuary 101 webinar for a guided introduction to using Estuary.
Watch

Frequently Asked Questions
Is this integration suitable for production workloads?
Yes. Estuary pipelines are designed for production use, with exactly-once delivery semantics, automated backfills, and continuous operation at scale.
Can I control where my data runs and is processed?
Yes. Estuary offers multiple deployment options, including fully managed SaaS, private deployments, and bring-your-own-cloud (BYOC). This allows teams to control where their data plane runs and meet security, compliance, and networking requirements. Learn more about Estuary's security and deployment options.
Can I build this Pendo to ClickHouse Kafka API integration manually?
Yes, it's possible to build a manual pipeline using custom scripts, scheduled jobs, or open-source tools. However, manual approaches typically require ongoing maintenance, custom error handling, schema management, and operational overhead. Estuary simplifies this by providing a managed pipeline with built-in reliability, scaling, and monitoring.
Related articles
ClickHouseMarch 6, 2026How to Stream MongoDB Data to ClickHouse in Real Time

ClickHouseDecember 12, 2025How to Move Data from Snowflake to ClickHouse: Real-Time, No-Code Guide

ClickHouseMarch 5, 2026How to Integrate Salesforce with ClickHouse in Real Time (No Code, No Kafka)

ClickHouseMarch 6, 2026How to Replicate MySQL to ClickHouse in Real Time Using CDC (In Minutes)

ClickHouseJune 2, 2026How to Move Data from SQL Server to ClickHouse (No Code Needed)

ClickHouseJuly 9, 2026Postgres to ClickHouse: Real-Time CDC Pipeline Guide

DataOps made simple
Add advanced capabilities like schema inference and evolution with a few clicks. Or automate your data pipeline and integrate into your existing DataOps using Estuary's rich CLI.






































