YugabyteDB
YugabyteDB is an open-source relational database management system.
Yugabyte Reader requires YugabyteDB release 2.21 or later as that was when support for logical replication was added. Stiiim does not yet support YugabyteDB Aeon on AWS, Google Cloud, or Microsoft Azure as logical replication is not yet available on those platforms.
You can read from YugabyteDB as follows, and write to any target supported by Striim. Typically, you will set up data pipelines that read from YugabyteDB in two phases—initial load, followed by continuous replication—as described in Building pipelines from YugabyteDB.
YugabyteDB feature summary
Feature | Initial load with Database Reader | Continuous real-time replication using Yugabyte Reader | Continuous incremental replication with Incremental Batch Reader |
|---|---|---|---|
Security and governance | |||
connection profile | |||
Operations | |||
initial load | ✓ | ||
initial schema creation | with supported targets | ||
schema evolution | ✔ | ||
DML operations replicable in target | INSERT, UPDATE, DELETE, TRUNCATE | INSERT (UPDATE handled as INSERT, DELETE ignored) | |
Building applications / programmability | |||
automated pipelines | ✓ | ✓ | |
other wizards | initial load only | initial load only, change data capture only | initial load only |
Flow Designer | ✓ | ✓ | ✓ |
TQL | ✓ | ✓ | ✓ |
Runtime | |||
event type of output stream | WAEvent | WAEvent | WAEvent |
network connection fault tolerance | by JDBC driver | configurable automatic retries | by JDBC driver |
recovery | ✓ | ✓ | ✓ |
parallel threads | ✓ | ✓ | |
metrics & auditing | ✓ | ✓ | ✓ |