# New to elasticsearch **URL:** \ **Category:** Elasticsearch\ **Created:** [September 22, 2012, 2:09pm UTC](https://discuss.elastic.co/t/new-to-elasticsearch/9106 "2012-09-22T14:09:24Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![Billy\_Newman](https://avatars.discourse-cdn.com/v4/letter/b/919ad9/32.png) [@Billy\_Newman](https://discuss.elastic.co/u/Billy_Newman)\ **Post date:** [September 22, 2012, 2:09pm UTC](https://discuss.elastic.co/t/new-to-elasticsearch/9106/1 "2012-09-22T14:09:24Z")
I am currently looking into elasticsearch to index a few things. All of my data is stored in either a MySql or Oracle database. This brings up 2 questions to get started: 1. is there a way that I can take certain data from my database and index it? 2. how do I keep the elasticsearch index up to date when new data is added to my db? I know this might seem like a strange question so let me clarify a little. I understand that when I want to add new data to the index I can just post documents which is fine. So I can post data to the index every time something is saved/updated/deleted to my database. However what do I do when I need to patch the data in my database? Do I need to essentially patch the elasticsearch index as well as my database. Thanks so much (in advance) for getting me started. Billy -- ---
**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\ **Post date:** [September 22, 2012, 5:10pm UTC](https://discuss.elastic.co/t/new-to-elasticsearch/9106/2 "2012-09-22T17:10:19Z")
1/ you have the nice JDBC river plugin from Jorg Prante : [https://github.com/jprante/elasticsearch-river-jdbc](https://github.com/jprante/elasticsearch-river-jdbc) 2/ same answer. But, you have to keep in mind that NoSQL search is very different from RDBMS SQL queries. You have to think your search as "global document indexing process" and forget Join queries... HTH -- David 😉 Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs Le 22 sept. 2012 à 16:09, Billy Newman [newmanw10@gmail.com](mailto:newmanw10@gmail.com) a écrit : I am currently looking into elasticsearch to index a few things. All of my data is stored in either a MySql or Oracle database. This brings up 2 questions to get started: 1. is there a way that I can take certain data from my database and index it? 2. how do I keep the elasticsearch index up to date when new data is added to my db? I know this might seem like a strange question so let me clarify a little. I understand that when I want to add new data to the index I can just post documents which is fine. So I can post data to the index every time something is saved/updated/deleted to my database. However what do I do when I need to patch the data in my database? Do I need to essentially patch the elasticsearch index as well as my database. Thanks so much (in advance) for getting me started. ## Billy -- ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [July 6, 2017, 3:11am UTC](https://discuss.elastic.co/t/new-to-elasticsearch/9106/3 "2017-07-06T03:11:46Z")