Source configuration.

DBS readers collect data from external sources such as MySQL and PostgreSQL and write the collected events to the target system of your choice.

This section provides general information about source configuration options. Some specific configuration options for different source types are described in the relevant sections.

Here is an example of a JSON source config object.

JSON

"source": {
    "mode": "reader-mode",
    "type": "source-type",
    "connection": "connection-string",
    "settings": {
      //settings are unique for each source type
    },
    "filter": {
      "tables": [
        { "name": "table1", "operations": ["insert", "update", "delete"]},
        { "name": "table2", "operations": ["insert", "update", "delete"]}
      ]
    }
  }

property	type	description
mode	source	represent mode to read the source. It may be either cdc or convert
type	string	Source type. It can be either `mysql` or `postgresql`.
connection	string	Connection settings. See the relevant sections for specific data sources.
settings	-	The settings are unique for each source type. Find more details about the settings in the relevant sections of the documentation.
filter/ tables	object	Tables for which change data is returned. Tables must have primary keys (required for logical replication).
operations	enum	A set of Change Data Capture types (insert, update, delete) of events to track.

Source configuration. #

Source configuration.