Connector Improvement: Support ApplicationIntent=ReadOnly for SQL Server Connectors

Answered

Anth

• January 15, 2021 16:14

SQL Server supports scaling out via read-only replicas to reduce load on a primary read/write server.  To take advantage of this feature, the connection string needs to include "ApplicationIntent=ReadOnly".

So, this is a feature request to enable Fivetran Connectors for SQL Server and Azure SQL Database to be configured so that the connection string will include this "ApplicationIntent=ReadOnly" parameter.

Thanks!

0

• Official comment

  

  Kevin

  • February 12, 2021 20:18

  Hi Anth,

  Thanks for your feedback! One of the key processes of our SQL Server replication is reading from either Change Tables or Change Data Capture.

  For Azure SQL specifically, we need to connect to the primary as AGs are not supported.

  One possibility is to read from a secondary for the import phase using the ApplicationIntent parameter, and then leverage the primary only for the change logs. This is certainly something we can discuss internally.

  We are always looking to improve performance for our connectors, and SQL Server is a priority for us. This feedback helps us make decisions for the product and is much appreciated!

  We don't have this on our roadmap at the moment, but I will bring it to the team for discussion.

Please sign in to leave a comment.