There are several SQL Server Origin connectors
- The SQL Server 2019 BDC Multitable Consumer origin reads data from Microsoft SQL Server 2019 Big Data Cluster (BDC) through a JDBC connection. Use the origin to read multiple tables from one or more schemas in the same database. For example, you might use the origin to replicate a database.
- The SQL Server CDC Client origin processes data in Microsoft SQL Server change data capture (CDC) tables. The origin fetches changes in time windows and uses multiple threads to enable parallel processing of data.
- The SQL Server Change Tracking origin processes data from Microsoft SQL Server change tracking tables. The origin can process data from tables with simple numeric primary keys. The origin cannot process data from tables with compound or non-numeric primary keys.
This connector is part of StreamSets Data Collector. Data Collector is a component of the StreamSets DataOps Platform.
Solace is a StreamSets reseller partner.