mywiki x

install

https://docs.confluent.io/platform/current/installation/installing_cp/deb-ubuntu.html (But only the first chapter)

https://docs.confluent.io/home/connect/self-managed/userguide.html#connect-installing-plugins

https://docs.confluent.io/kafka-connect-jdbc/current/

https://docs.confluent.io/home/connect/self-managed/userguide.html#connect-userguide-standalone-config

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/7c2d2e4b-0570-4b65-92fd-ebb3e4990c3b/trying-to-achieve-real-time-integration-with-ssis?forum=sqlintegrationservices

https://medium.com/clay-one/kafka-connect-cluster-an-introduction-26522e72a9af

Detailed Connection Schema https://www.confluent.io/blog/kafka-client-cannot-connect-to-broker-on-aws-on-docker-etc/

Topics and Partitions https://stackoverflow.com/questions/38024514/understanding-kafka-topics-and-partitions

https://www.confluent.io/hub/confluentinc/kafka-connect-http

https://www.confluent.io/hub/debezium/debezium-connector-sqlserver

https://www.confluent.io/hub/confluentinc/kafka-connect-jdbc

all are either build ,test and support by confluent or tested and supported by confluent

== Protect Kafka Connect Rest API with authentification

https://www.active-directory-faq.de/2021/07/iis-als-reverse-proxy-einrichten/

https://techexpert.tips/de/nginx-de/nginx-ldap-authentifizierung-im-active-directory/

https://docs.confluent.io/platform/current/connect/logging.html

Worker configurations

https://docs.confluent.io/platform/current/connect/references/allconfigs.html

Connector Configurations

https://docs.confluent.io/platform/current/connect/references/connector-configs.html

The Apache Kafka® Admin client library https://docs.confluent.io/platform/current/installation/configuration/admin-configs.html

REST API https://docs.confluent.io/platform/current/connect/references/restapi.html

create role kafkacdc AUTHORIZATION db_datareader
GO
create login kafkaconnect with password=***
GO
create user kafkaconnect for login kafkaconnect
GO
alter role kafkacdc add member kafkaconnect
GO
EXEC sys.sp_cdc_enable_db
GO
EXEC sys.sp_cdc_enable_table
@source_schema = N'dbo',
@source_name   = N'Products', 
@role_name     = N'kafkacdc',  
@filegroup_name = N'PRIMARY',
@supports_net_changes = 0
GO