Skip to content

Microsoft SQL advanced settings

In most cases, the advanced settings mentioned below aren't required; however, Matillion CDC does offer some additional configuration items when setting up your pipelines. Take a moment to understand what these advanced settings are and what they achieve before incorporating them within your pipeline.

You can add advanced settings at the end of the Add Pipeline journey via the Data Loader UI.


Encryption

In Connect to Microsoft SQL Server, set the encryption advanced parameters. This dialog lets you configure the connection to Microsoft SQL Server.

Microsoft SQL Server connections use encryptions by default. You can specify security settings with advanced settings including:

  • encrypt: Connect with encryption. true by default. Set to false to disable encryption.
  • trustServerCertificate: Implicitly trust a certificate provided by the server. Set to true to trust (skip validation of) the Microsoft SQL Server TLS certificate.

Note

The encrypt and trustServerCertificate parameters should be set as source advanced settings in the Connect to Microsoft SQL Server dialog.

Trusting the server certificate can allow users to connect with encryption on. Due to the CDC Agent being containerized, it is not currently possible to add certificates to the TrustStore.

For more information, see Microsoft's documentation on Connecting with encryption.


database.applicationIntent

In the Pipeline Settings dialog, if required, set the Debezium advanced connector property database.applicationIntent as a pipeline setting.

The Microsoft SQL Server connector can capture changes from an always-on, read-only replica.

  • ReadOnly: This is required to support the Microsoft SQL Server Always ON (Read Replica) structure. Read SQL Server Always On to learn more.