# Synchronizing oracle database and elastic search

**URL:** <https://discuss.elastic.co/t/synchronizing-oracle-database-and-elastic-search/131244>\
**Category:** Elasticsearch\
**Created:** [May 10, 2018, 4:22am UTC](https://discuss.elastic.co/t/synchronizing-oracle-database-and-elastic-search/131244 "2018-05-10T04:22:24Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![MaralErdene\_Tumursuh](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/maralerdene_tumursuh/32/73137_2.png) [@MaralErdene\_Tumursuh](https://discuss.elastic.co/u/MaralErdene_Tumursuh)\
**Post date:** [May 10, 2018, 4:22am UTC](https://discuss.elastic.co/t/synchronizing-oracle-database-and-elastic-search/131244/1 "2018-05-10T04:22:25Z")

</div>

Hey folks,

I've some problem about how to real time synchronize oracle database /tables and views/ and elastic source .

I have to synchronize to elastic search just after commit on oracle database. My RDBMS tables is complex, it has too many relation, too many join.

How to do it? any idea?

---

<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:** [May 10, 2018, 6:07am UTC](https://discuss.elastic.co/t/synchronizing-oracle-database-and-elastic-search/131244/2 "2018-05-10T06:07:52Z")

</div>

The best way would be to write the data to the database and to Elasticsearch at the same time.

---

<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:** [June 7, 2018, 6:07am UTC](https://discuss.elastic.co/t/synchronizing-oracle-database-and-elastic-search/131244/3 "2018-06-07T06:07:59Z")

</div>

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