# JDBC Sink connector not writing to SSMS

**URL:** <https://forum.confluent.io/t/jdbc-sink-connector-not-writing-to-ssms/37469>\
**Category:** Schema Registry\
**Created:** [12 March 2025 20:32 UTC](https://forum.confluent.io/t/jdbc-sink-connector-not-writing-to-ssms/37469 "2025-03-12T20:32:53Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Nerd2025](https://avatars.discourse-cdn.com/v4/letter/n/b487fb/32.png) [@Nerd2025](https://forum.confluent.io/u/Nerd2025)\
**Post date:** [12 March 2025 20:32 UTC](https://forum.confluent.io/t/jdbc-sink-connector-not-writing-to-ssms/37469/1 "2025-03-12T20:32:53Z")

</div>

Hi all,

I have been working on the JDBC sink connector to SSMS and its neither been reading the topic nor writing it to SQL database. But the connector is showing running successfully in SwaggerUI. I have been told to include schema information but the schema is set to false by producer. What can i do in this case.  
Here is my config:  
name": “jdbc\_sinkconnector”,  
“config”: {  
“connector.class”: “io.confluent.connect.jdbc.JdbcSinkConnector”,  
“tasks.max”: “3”,  
“topics”: “my\_new\_topic”,  
“connection.url”: “jdbc\_sql”,  
“connection.user”: “SSMS”,  
“connection.password”: “mypassword”,  
“insert.mode”: “UPSERT”,  
“pk.mode”: “kafka”,  
“pk.fields”: “EMPLID”,  
“auto.create”: “true”,  
“auto.evolve”: “true”,  
“transforms”: “RenameField”,  
“transforms.RenameField.type”: “org.apache.kafka.connect.transforms.ReplaceField$Value”,  
“transforms.RenameField.renames”: “EMPLID:empl\_id,NAME:empl\_name,POSITION\_NBR:empl\_position\_nbr”,  
“table.name.format”: “kafka\_CC”,  
“consumer.override.auto.offset.reset”: “latest”  
}  
}