# Delete Sync Operation using Logstash JDBC

**URL:** <https://discuss.elastic.co/t/delete-sync-operation-using-logstash-jdbc/252636>\
**Category:** Logstash\
**Created:** [October 20, 2020, 6:28am UTC](https://discuss.elastic.co/t/delete-sync-operation-using-logstash-jdbc/252636 "2020-10-20T06:28:26Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![sharath\_sai](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/sharath_sai/32/59876_2.png) [@sharath\_sai](https://discuss.elastic.co/u/sharath_sai)\
**Post date:** [October 20, 2020, 6:28am UTC](https://discuss.elastic.co/t/delete-sync-operation-using-logstash-jdbc/252636/1 "2020-10-20T06:28:26Z")

</div>

Hi all,

We have configured JDBC logstash, to migrate data from Cassandra to logstash.  
we have able to move data from Cassandra to logstash, we are also updating the data in elastic search based on document\_id, but we not able to delete the records that deleted in Cassandra.

Can u tell us the config to delete the records in elastic search based on deleting in Cassandra?  
Ultimately we need to sync two DB's using logstash JDBC.

```
Our Configuration:

# emp_id -- Primary Key in Cassandra

input {
    jdbc {
        jdbc_connection_string => "jdbc:cassandra://X.X.X.X:9042/cloud"
        jdbc_user => "cassandra"
        jdbc_password => "cassandra"
        jdbc_driver_library => "/usr/share/logstash/logstash-core/lib/jars/CassandraJDBC42.jar"
        jdbc_validate_connection => true
        jdbc_driver_class => "com.simba.cassandra.jdbc42.Driver"
        statement => "SELECT * FROM cloud.employee_list"
        schedule => "* * * * *"
        use_column_value => true
        tracking_column => "emp_id"
    }

}

output {
  elasticsearch { 
   hosts => ["localhost:9200"]
   document_id=> "%{emp_id}"
   index => "employeelist_table2"
  } 
  stdout { codec => rubydebug }
}

```

Thanks!!

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [November 17, 2020, 6:28am UTC](https://discuss.elastic.co/t/delete-sync-operation-using-logstash-jdbc/252636/2 "2020-11-17T06:28:29Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.