# Best practice for denormalize Relational database table to Elasticsearch
**URL:** https://discuss.elastic.co/t/best-practice-for-denormalize-relational-database-table-to-elasticsearch/206404
**Category:** Elasticsearch
**Created:** [November 4, 2019, 12:57pm UTC](https://discuss.elastic.co/t/best-practice-for-denormalize-relational-database-table-to-elasticsearch/206404 "2019-11-04T12:57:49Z")
**Posts on this page:** 2
**Page:** 1
### Author:  [@LinJIngYun](https://discuss.elastic.co/u/LinJIngYun)
#### Post date: [November 4, 2019, 12:57pm UTC](https://discuss.elastic.co/t/best-practice-for-denormalize-relational-database-table-to-elasticsearch/206404/1 "2019-11-04T12:57:49Z")
Greeting everybody.
How I can denormalize MongoDB(normalize) collections that have relation between collections (joined) and insert it to Elasticsearch (denormalized data)?
For now I have an simplest ways is Create API that perform aggrwgation lookup in MongoDB and return all data in REST API then Logstash going to retrive data from that API.
This is the simplest ways that I can thonk about it.
Is it have another way? Or perhaps I can perform MongoDB query on Logstash ?
Thank you very muxh for your answer 🙂
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [December 2, 2019, 12:58pm UTC](https://discuss.elastic.co/t/best-practice-for-denormalize-relational-database-table-to-elasticsearch/206404/2 "2019-12-02T12:58:01Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.