# How to update index in elastic search when orcal table changed

**URL:** <https://discuss.elastic.co/t/how-to-update-index-in-elastic-search-when-orcal-table-changed/57116>\
**Category:** Elasticsearch\
**Created:** [August 3, 2016, 2:40pm UTC](https://discuss.elastic.co/t/how-to-update-index-in-elastic-search-when-orcal-table-changed/57116 "2016-08-03T14:40:58Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![ElsayedAwd](https://avatars.discourse-cdn.com/v4/letter/e/da6949/32.png) [@ElsayedAwd](https://discuss.elastic.co/u/ElsayedAwd)\
**Post date:** [August 3, 2016, 2:40pm UTC](https://discuss.elastic.co/t/how-to-update-index-in-elastic-search-when-orcal-table-changed/57116/1 "2016-08-03T14:40:58Z")

</div>

I'am working with myself , I' am using orcal database ,Iam making indexing from orcal data base into elastic search, the problem is how to get the updated and new rows from orcal data base into elastic search without reindex the whole Table data.  
how to solve this problem ?  
thank you very much .

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [August 5, 2016, 12:19am UTC](https://discuss.elastic.co/t/how-to-update-index-in-elastic-search-when-orcal-table-changed/57116/2 "2016-08-05T00:19:31Z")

</div>

Logstash should be able to do this - [https://www.elastic.co/guide/en/logstash/current/plugins-inputs-jdbc.html](https://www.elastic.co/guide/en/logstash/current/plugins-inputs-jdbc.html)

---

<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:** [July 5, 2017, 10:29pm UTC](https://discuss.elastic.co/t/how-to-update-index-in-elastic-search-when-orcal-table-changed/57116/3 "2017-07-05T22:29:56Z")

</div>