SOS : Setting up Debezium SQL server Source Connector

[Sokunrithy Tiv]

Hello everyone, 

I need help in configure the Debezium SQL server source connector. There are 2 parameters that i am not sure . 

The following parameters are : 

1) schema.history.internal.kafka.bootstrap.servers

2) schema.history.internal.kafka.topic

I already refer to the debezium documentation, but still no luck . 

Best Regards, 
Rithy

[Chris Cranford]

Hi Rithy -

All relational connectors, with the exception of PostgreSQL require the use of a schema history configuration, where Debezium records the schema changes so that it can resume with all the necessary state where it left off. The two settings you referred to are necessary when using the Kafka-based schema history topic, which is the default when deploying Debezium in Kafka Connect.

schema.history.internal.kafka.bootstrap.servers
    This points to your Kafka broker, i.e your-kafka-broker-hostA:9092,your-kafka-broker-hostB:9092

schema.history.internal.kafka.topic
    This is the name of the topic that Debezium will use to store the schema change history. This can be any name you like. The only requirement is that this topic must not have compaction enabled [1].

Let us know if you have any other questions.
-cc

[1]: https://debezium.io/documentation/reference/3.4/install.html#configuring-debezium-topics

--
You received this message because you are subscribed to the Google Groups "debezium" group.
To unsubscribe from this group and stop receiving emails from it, send an email to debezium+u...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/debezium/2a8cbb66-2626-4e69-858b-e08d11c889c9n%40googlegroups.com.

[Sokunrithy Tiv]

Hello Chris, 

Thank you so much for the detail's explanation of each parameters as well as the link reference. 

Appreciate your help :) . 

Best Regards, 

Rithy