SQL Server CDC readers
Striim offers two CDC readers to read data from your SQL Server databases in real time: MS SQL Reader and MSJet. MSJet’s primary advantage over MS SQL Reader is higher throughput and lower resource consumption at the source database server (compute, memory, and disk I/O). On the other hand, MS SQL Reader can support older versions of SQL Server databases and a wider variety of cloud SQL databases.
The following table provides an overview of the two adapters' capabilities:
Feature comparison: MS SQL Reader and MSJet
MS SQL Reader | MSJet | |
|---|---|---|
supported versions | ||
| ✓ | |
| ✓ | |
| ✓ | |
| ✓ | |
| ✓ |
|
| ✓ | ✓ |
| ✓ | ✓ |
| ✓ | ✓ |
| ✓ | ✓ |
Supported cloud database services | ||
| ✓ | |
| ✓ tables with binary or varbinary values ≥64KB cannot be read | ✓ in Mine mode |
| ✓ tables with binary or varbinary values ≥64KB cannot be read | ✓ in Mine mode |
can read from | ||
| ✓ | |
| ✓ | |
|
| ✓ |
| ✓ | |
key features | ||
| INSERT, UPDATE, DELETE | INSERT, UPDATE, DELETE, BEGIN, COMMIT |
|
| ✓ |
| when Transaction Support is True (see MS SQL Reader properties for more information) | ✓ |
| ✓ | ✓ |
| ✓ | |
| ✓ | |
| ✓ | ✓ |
| ✓ | |
| ✓ | ✓ |
| ✓ | |
| ✓ | when Mode is Mine |
summary of supported data types (for full details, see SQL Server readers data type support and correspondence) | ||
| ✓ | ✓ |
| ✓ | |
| ||
Striim provides templates for creating applications that read from SQL Server and write to various targets. SeeCreating an application using a template for details.
To learn more about these CDC readers or purchase them, Contact Striim support.