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 Streaming 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.