# Help for elk stack **URL:** \ **Category:** Elasticsearch\ **Created:** [August 23, 2023, 8:26am UTC](https://discuss.elastic.co/t/help-for-elk-stack/341447 "2023-08-23T08:26:00Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Farah\_Bannour](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/farah_bannour/32/118699_2.png) [@Farah\_Bannour](https://discuss.elastic.co/u/Farah_Bannour)\ **Post date:** [August 23, 2023, 8:26am UTC](https://discuss.elastic.co/t/help-for-elk-stack/341447/1 "2023-08-23T08:26:00Z")
Can I make the datamart from elk stack . and How do I combine 2 index data in elasticsearch do-i-combine-2-index-data-in-elasticsearch/199044 . ---
**Author:** ![carly.richmond](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/carly.richmond/32/104935_2.png) [@carly.richmond](https://discuss.elastic.co/u/carly.richmond)\ **Post date:** [August 23, 2023, 9:53am UTC](https://discuss.elastic.co/t/help-for-elk-stack/341447/2 "2023-08-23T09:53:56Z")
Hi @Farah_Bannour, I've changed the topic to Elastic Stack rather than announcement as it better fits your question. Can you give a bit more detail on what you are trying to do? What do you mean by: > [@Farah\_Bannour](#): > > make the datamart from elk stack It sounds like you're trying to combine data from two indices? What does your data look like? Does it need to be in separate indices? ---
**Author:** ![Farah\_Bannour](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/farah_bannour/32/118699_2.png) [@Farah\_Bannour](https://discuss.elastic.co/u/Farah_Bannour)\ **Post date:** [August 23, 2023, 2:18pm UTC](https://discuss.elastic.co/t/help-for-elk-stack/341447/3 "2023-08-23T14:18:39Z")
I’m doing data extraction from odoo sh using the api to create index and I wanted to make a join between 3 or more index how I can do ca by elk stack ---
**Author:** ![carly.richmond](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/carly.richmond/32/104935_2.png) [@carly.richmond](https://discuss.elastic.co/u/carly.richmond)\ **Post date:** [August 23, 2023, 3:41pm UTC](https://discuss.elastic.co/t/help-for-elk-stack/341447/4 "2023-08-23T15:41:26Z")
So an Elasticsearch index is different to SQL tables, so you wouldn't be joining the indices together as part of a query. You would need to enrich the documents coming in from odoo. One way you could do that is using an [enrich processor in an ingest pipeline](https://www.elastic.co/guide/en/elasticsearch/reference/current/ingest-enriching-data.html) to ensure the values and fields you need are included in the document. ---
**Author:** ![Farah\_Bannour](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/farah_bannour/32/118699_2.png) [@Farah\_Bannour](https://discuss.elastic.co/u/Farah_Bannour)\ **Post date:** [August 23, 2023, 4:08pm UTC](https://discuss.elastic.co/t/help-for-elk-stack/341447/5 "2023-08-23T16:08:24Z")
i can use alias or reindex or not?also have you an idea of how i can establish a datamart when i have a relationnel data (in my case is data from odoo ---
**Author:** ![carly.richmond](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/carly.richmond/32/104935_2.png) [@carly.richmond](https://discuss.elastic.co/u/carly.richmond)\ **Post date:** [August 24, 2023, 8:27am UTC](https://discuss.elastic.co/t/help-for-elk-stack/341447/6 "2023-08-24T08:27:13Z")
It's difficult to say without knowing the structure of your data and how you want to join things together. If you don't want to join documents together, similar like you would with records across two DB tables, and it's just a search across multiple indices to find relevant records then using an alias would work. As would reindexing everything to a single index. Can you give a bit more information on the structure of the indices and what you mean by `join`? ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [September 21, 2023, 8:27am UTC](https://discuss.elastic.co/t/help-for-elk-stack/341447/7 "2023-09-21T08:27:57Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.