# Nested Json Array creation by Joining many Tables from Oracle

**URL:** <https://discuss.elastic.co/t/nested-json-array-creation-by-joining-many-tables-from-oracle/91865>\
**Category:** Logstash\
**Created:** [July 5, 2017, 8:59am UTC](https://discuss.elastic.co/t/nested-json-array-creation-by-joining-many-tables-from-oracle/91865 "2017-07-05T08:59:07Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![karthickmr](https://avatars.discourse-cdn.com/v4/letter/k/a698b9/32.png) [@karthickmr](https://discuss.elastic.co/u/karthickmr)\
**Post date:** [July 5, 2017, 8:59am UTC](https://discuss.elastic.co/t/nested-json-array-creation-by-joining-many-tables-from-oracle/91865/1 "2017-07-05T08:59:07Z")

</div>

Hi All,  
I am new to ELK,As part of our POC I have installed ElasticSearch(5.4.2), Kibana and Logstash. We need to move data from oracle to Elasticsearch for analytics Purpose. Do we need to use any programming language to do this Activity or in Logstash itself we can do this.

We need to read 3 to 4 oracle table which is in normalised format and convert that into nested Json array format and load in Elasticseacrh.

I am unable to find any docuement on creating nested Json Array from oracle.

Please help me on this

---

<div class="post-metadata">

**Author:** ![magnusbaeck](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/magnusbaeck/32/44943_2.png) [@magnusbaeck](https://discuss.elastic.co/u/magnusbaeck)\
**Post date:** [July 8, 2017, 3:39pm UTC](https://discuss.elastic.co/t/nested-json-array-creation-by-joining-many-tables-from-oracle/91865/2 "2017-07-08T15:39:45Z")

</div>

The jdbc input plugin that Logstash provides produces one Logstash event per row in the result set. That probably won't do in your case. It's possible that the aggregate filter can help you create the array you're looking for.

---

<div class="post-metadata">

**Author:** ![karthickmr](https://avatars.discourse-cdn.com/v4/letter/k/a698b9/32.png) [@karthickmr](https://discuss.elastic.co/u/karthickmr)\
**Post date:** [July 10, 2017, 3:50am UTC](https://discuss.elastic.co/t/nested-json-array-creation-by-joining-many-tables-from-oracle/91865/3 "2017-07-10T03:50:34Z")

</div>

Thanks for the answer. I will explore the aggregate filter.

---

<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:** [August 7, 2017, 3:50am UTC](https://discuss.elastic.co/t/nested-json-array-creation-by-joining-many-tables-from-oracle/91865/4 "2017-08-07T03:50:49Z")

</div>

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