# Can Elastic Search help existing systems? Any tools that can get rid of stored procedures in existing system?

**URL:** <https://discuss.elastic.co/t/can-elastic-search-help-existing-systems-any-tools-that-can-get-rid-of-stored-procedures-in-existing-system/37862>\
**Category:** Elasticsearch\
**Created:** [December 23, 2015, 2:09pm UTC](https://discuss.elastic.co/t/can-elastic-search-help-existing-systems-any-tools-that-can-get-rid-of-stored-procedures-in-existing-system/37862 "2015-12-23T14:09:04Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Architha](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/architha/32/92477_2.png) [@Architha](https://discuss.elastic.co/u/Architha)\
**Post date:** [December 23, 2015, 2:09pm UTC](https://discuss.elastic.co/t/can-elastic-search-help-existing-systems-any-tools-that-can-get-rid-of-stored-procedures-in-existing-system/37862/1 "2015-12-23T14:09:04Z")

</div>

Hi Team,

I have an existing project which has huge number of database tables and many stored procedures . If I have to enhance the project using elastic search , what steps should I have to follow ?  
And , if the structure of the JSON documents is defined , Is there any tool that can help me get my JSON object from the database ?

---

<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:** [December 23, 2015, 11:31pm UTC](https://discuss.elastic.co/t/can-elastic-search-help-existing-systems-any-tools-that-can-get-rid-of-stored-procedures-in-existing-system/37862/2 "2015-12-23T23:31:43Z")

</div>

> [@Architha](#):
>
> If I have to enhance the project using Elasticsearch , what steps should I have to follow ?

Dunno, that's a bit of a broad question for us to answer.  
What problems do you want to solve?

> [@Architha](#):
>
> And , if the structure of the JSON documents is defined , Is there any tool that can help me get my JSON object from the database ?

Logstash can do it with the JDBC input.

---

<div class="post-metadata">

**Author:** ![Architha](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/architha/32/92477_2.png) [@Architha](https://discuss.elastic.co/u/Architha)\
**Post date:** [December 24, 2015, 4:37am UTC](https://discuss.elastic.co/t/can-elastic-search-help-existing-systems-any-tools-that-can-get-rid-of-stored-procedures-in-existing-system/37862/3 "2015-12-24T04:37:20Z")

</div>

Thanks for the response. The problems that i have to solve are

1. The existing project is slow , i want to enhance it
2. The stored procedures that are used in the existing system are too many, want to replace them using Elastic search.

---

<div class="post-metadata">

**Author:** ![softwaredoug](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/softwaredoug/32/22681_2.png) [@softwaredoug](https://discuss.elastic.co/u/softwaredoug)\
**Post date:** [December 24, 2015, 5:14pm UTC](https://discuss.elastic.co/t/can-elastic-search-help-existing-systems-any-tools-that-can-get-rid-of-stored-procedures-in-existing-system/37862/4 "2015-12-24T17:14:46Z")

</div>

> 1. The existing project is slow , i want to enhance it

Which parts of it are slow? Can you give examples of specific use cases?

> 1. The stored procedures that are used in the existing system are too many, want to replace them using Elastic search.

Too many stored procedures? To recreate that in Elasticsearch, that would just be more client code that builds ES queries. I suppose this is totally up to your taste in what you'd prefer to manage, but the complexity is probably high in either case.

---

<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, 11:28pm UTC](https://discuss.elastic.co/t/can-elastic-search-help-existing-systems-any-tools-that-can-get-rid-of-stored-procedures-in-existing-system/37862/5 "2017-07-05T23:28:44Z")

</div>


