When connecting to SQL server which origin module do I use.

QUESTION:

When connecting to SQL server, should I use SQL Server CDC Client or SQL Server Change origin?

ANSWER:

MS SQL supports two different changes tracking mechanisms. CDC and "Change Tracking". We provide different origins for each.

From our documentation:
Use the SQL Server CDC Client origin to generate records from CDC tables. To read data from Microsoft SQL Server change tracking tables, use the SQL Server Change Tracking origin. For more information about the differences between CDC and change tracking data, see the Microsoft SQL Server documentation.

Did this topic help you find an answer to your question?

Be the first to reply!

Sign up