# Syncing SQL data with Elastic

**URL:** <https://discuss.elastic.co/t/syncing-sql-data-with-elastic/294372>\
**Category:** Logstash\
**Created:** [January 14, 2022, 7:27am UTC](https://discuss.elastic.co/t/syncing-sql-data-with-elastic/294372 "2022-01-14T07:27:02Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Satyan\_Gupta](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/satyan_gupta/32/100322_2.png) [@Satyan\_Gupta](https://discuss.elastic.co/u/Satyan_Gupta)\
**Post date:** [January 14, 2022, 7:27am UTC](https://discuss.elastic.co/t/syncing-sql-data-with-elastic/294372/1 "2022-01-14T07:27:02Z")

</div>

Hello Everyone,  
I am new to elastic and facing issue to keep my sql database in sync with elastic. Here is my logstash config file.

```auto
input {
  jdbc {
    jdbc_driver_library => "C:\Users\satyang.sw\Desktop\ELK_Stack\logstash-7.16.2\mysql-connector-java.jar"
    jdbc_driver_class => "com.mysql.jdbc.Driver"
    jdbc_connection_string => "jdbc:mysql://xxx.xxx.xxx.xxx:3306/cpv1_mamcdb_cloud1_15062021?zeroDateTimeBehavior=convertToNull"
    jdbc_user => "xxx"
    jdbc_password => "xxx"
	jdbc_paging_enabled => true
	tracking_column => "last_update_value"
	use_column_value => true
	tracking_column_type => "timestamp"
	schedule => "*/5 * * * * *"
    statement => "SELECT *, UNIX_TIMESTAMP(LastUpdated) AS last_update_value FROM channels WHERE (UNIX_TIMESTAMP(LastUpdated) > :sql_last_value AND LastUpdated < NOW()) ORDER BY LastUpdated ASC"
  }
}

filter {
  mutate {
    copy => { "UID" => "[@metadata][_id]"}
    remove_field => ["UID", "last_update_value"]
  }
}

output {
  stdout { codec => "rubydebug"}
  elasticsearch {
    hosts => "http://localhost:9200"
    index => "auto-sync-sql-channels"
	document_id => "%{[@metadata][_id]}"
  }
}

```

It executes without any error but fails to create docs with desired "\_id" and creates like this instead -  
 ![image](https://us1.discourse-cdn.com/elastic/original/3X/5/8/58d51aa925122c883bfc3d11bae2235e817c05e1.png)

---

<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:** [February 11, 2022, 7:27am UTC](https://discuss.elastic.co/t/syncing-sql-data-with-elastic/294372/2 "2022-02-11T07:27:37Z")

</div>

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