Matillion Data Loader offers a number of different source connectors for CDC pipelines. This list is independent of the list of sources available for Batch pipelines.
Credentials for accessing these sources will be required during pipeline setup but cannot be stored in Matillion Data Loader for security purposes. Instead, it is required that you store your passwords in either Amazon Secrets Manager or Azure Key Vault.
You can expect the following documentation on supported CDC sources:
These articles are for those setting up a CDC pipeline in Matillion Data Loader and are looking for details on connection details, available tables and some background information on how that connector works.
Configuring Database documentation
These articles detail the process for configuring your database to be enabled for CDC. This is a process independent of Matillion Data Loader. It is important to recognise that configuring your source database for CDC can be a manual and complicated task that should be completed under the supervision of your database administrator or similar expert.
Advanced Settings documentation
Many sources offer optional advanced parameters that can be included during the pipeline creation process in Matillion Data Loader. It is highly unusual for users to require these and they should not be used without expert understanding of the technology.
We also provide links to the official documentation for your chosen source. It is highly recommended to consult the official documentation for any source before deciding to use it as a source for a CDC pipeline.