# Striim

> Real-time CDC platform with in-flight streaming SQL

Striim is a commercial real-time data integration platform combining change data capture with streaming SQL, moving data from operational databases and SaaS applications into warehouses, lakehouses, and Kafka as it changes.

Website: https://www.striim.com

## Use it when

- Changes must be transformed in flight: streaming SQL filters, joins, masks, and aggregates between capture and delivery, before data lands anywhere.
- Sources mix databases and SaaS: Oracle, MySQL, PostgreSQL, SQL Server, and MongoDB alongside Salesforce, Stripe, ServiceNow, and more than a hundred connectors overall.
- Targets are the modern warehouses: Snowflake, BigQuery, Databricks, Synapse, and Kafka, with exactly-once delivery configurable.
- You want the same platform managed as SaaS or self-managed in your own cloud.

## Think twice when

- Replication alone is the need; pure movers (Datastream, DMS, Debezium) do it with less platform to own or license.
- Budget is small; Cloud bills per event and Platform is licensed per connector, and this is enterprise software.
- You would rather transform after landing; the in-flight SQL is the differentiator you would be paying for.

## How it runs

A multi-node Striim cluster with its own metadata repository, run for you as SaaS on the major clouds or self-managed. Sources need log access (ARCHIVELOG plus LogMiner or XStream on Oracle); pipelines apply streaming SQL between source and target, with schema-drift actions configurable per target. Striim Developer is the free sandbox.

## Details

### General

| Attribute | Value |
| --- | --- |
| License | Commercial |
| Deployment | Managed, Self-hosted |
| Workload | Streaming |
| Operational complexity | Medium |
| Pricing | Free, Subscription |
| Documentation | https://www.striim.com/docs/ |

### Change Data Capture

| Attribute | Value |
| --- | --- |
| Sources | Oracle, MySQL, PostgreSQL, SQL Server, MongoDB and SaaS apps |
| Source requirements | Oracle needs ARCHIVELOG, supplemental logging and LogMiner or XStream |
| What you run | A multi-node Striim cluster with its own metadata repository |
| Initial snapshot | Bulk load with CDC capturing during it |
| End-to-end lag | Near real-time; events move through the pipeline continuously |
| Delivery guarantee | Exactly-once (E1P); at-least-once also configurable |
| Schema drift | Per-target DDL action: process, ignore, quiesce or halt |
| Transformations | Streaming SQL in flight: filter, join, mask, aggregate before delivery |
| Destinations | Snowflake, BigQuery, Databricks, Synapse, Kafka |
| Billing unit | Events on Cloud; Platform licensed per connector |

## Capabilities

- [Change Data Capture](https://matca.io/capabilities/change-data-capture)

---

Source: https://matca.io/striim
Last updated: 2026-08-31T11:40:47.070Z