Skip to main content
Docs
Feature Requests Onboarding Trust Center Status Page

Community

Connector Improvement: SQL DB - CT vs CDC Toggle

Brian Fuqua User

https://fivetran.com/docs/databases/sql-server#updatingdata

In the hyperlink, it states that Change Tracking is done by default and Capture Data Changes is done second - meaning that you must have CT disabled for CDC to work.  Can you create a toggle on the connector so the user can select what their preferences is?  We had a two week sync issue because of this that we just corrected.  Both were enabled, but the Change Tracking query is so heavy that it gave us massive issues.

Please sign in to leave a comment.

Comments

2 comments

Date Votes
  • Official comment
    Kevin Kim Fivetranner

    Hi Brian,

    Thanks for your post in our feature requests portal!

    I agree that the current behavior should not default to CT when both CT and CDC are enabled for a given table in SQL Server. Rather than a configuration option, would you prefer for the default to be CDC when both are enabled, and then use CT for any tables that do not have CDC enabled?

    I have provided this feedback to our engineering team and we will work on rolling out a change to this behavior gradually.

  • Brian Fuqua User

    Hi Kevin,

    Yes, I personally would prefer that because CDC is faster by design.  I doubt other users would prefer CT over CDC, but I thought the option might make it easier for every user.  It would also highlight the options available to them, hence why the toggle gives incredible visibility.  So there are really two asks: 1) make it easier to use CDC and 2) make it more obvious what is being used in Fivetran (CT v CDC).  Currently, the only way to know which is being used in Fivetran is by looking at the logs, reading the SQL statement being run, and understanding what the aliases CT and CDC mean.

    Thanks for getting back to me!