Blogsby GlyphHow to Build Customer-Facing Analytics Pipelines with CDC
A practical architecture guide to customer-facing analytics with CDC, covering data freshness, serving layers, tenant isolation, and real-world SaaS examples.
13 of 800 posts
Yesterday1 post
Fri Nov 69 posts
NetSuite to ClickHouse: SuiteAnalytics Connect, Sync Methods & Ledger Modeling Guide
Move NetSuite data to ClickHouse with SuiteAnalytics Connect, an ELT tool or a script. Compare 5 methods and plan for deletes, custom fields and limits.
Kafka to ClickHouse: Streaming Ingestion, Duplicates & Tombstones Guide
Stream Kafka to ClickHouse with the Kafka table engine, ClickPipes or Kafka Connect. Compare 4 methods, delivery guarantees and duplicate handling.
Salesforce to S3: Export Objects as Parquet and Capture Changes
Move Salesforce to S3 as Parquet with Amazon AppFlow, AWS Glue, Python or a managed pipeline. Compare how each handles types, formula fields and deletes.
Salesforce to Iceberg: How to Load CRM Objects and Keep Tables Current
Salesforce to Iceberg: compare 4 ways to load CRM objects into Iceberg tables, see where Data 360 zero copy fits, and handle deletes and formulas.
Oracle to ClickHouse: CDC, Batch & Type Mapping Guide
Move data from Oracle to ClickHouse: map types, handle updates and deletes with ReplacingMergeTree, and compare 4 CDC and batch methods.
S3 to Kafka: How to Turn New S3 Files into Kafka Messages
Move S3 data into Kafka with an S3 source connector, AWS Lambda, Spark or a managed pipeline. Compare file ordering, formats, duplicates and setup.
Webhooks to Kafka: How to Receive Events and Publish Them to Topics
Send webhooks to Kafka with a webhook source connector, an HTTP gateway, AWS Lambda or a managed pipeline. Compare signatures, retries and duplicates.
Oracle to S3 as Parquet: Export Tables and Replicate Changes with CDC
Move Oracle to S3 as Parquet with AWS DMS, AWS Glue, GoldenGate or a managed CDC pipeline. Compare how each handles NUMBER, DATE, LOBs and deletes.
What your CDC pipeline does when a primary key changes
A hands-on look at how CDC pipelines handle primary key updates, deletes, and orphan rows, with tests using MySQL, Debezium, and Estuary.
Wed Nov 42 posts
MongoDB to S3: Parquet Files, Change Streams & Nested Documents Guide
Move MongoDB to S3 as Parquet with Atlas Data Federation, AWS DMS, Spark or a managed pipeline. Compare how each handles nested documents and deletes.
HubSpot to ClickHouse: Sync Methods, Setup & API Limits Guide
Sync HubSpot to ClickHouse with a managed tool, open-source ELT or the HubSpot API. Compare 4 methods, plan for rate limits and dedupe with FINAL.
Tue Nov 31 post
Multi-Tenant CDC: Database-per-Tenant SaaS Architecture Guide
A practical guide to multi-tenant CDC with PostgreSQL, tenant-aware keys, and shared analytics tables using Estuary.