# Data warehouse

**URL:** <https://discuss.elastic.co/t/data-warehouse/134050>\
**Category:** Elasticsearch\
**Tags:** es-hadoop\
**Created:** [May 31, 2018, 12:49pm UTC](https://discuss.elastic.co/t/data-warehouse/134050 "2018-05-31T12:49:25Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mohammadhossein\_Bark](https://avatars.discourse-cdn.com/v4/letter/m/3ec8ea/32.png) [@Mohammadhossein\_Bark](https://discuss.elastic.co/u/Mohammadhossein_Bark)\
**Post date:** [May 31, 2018, 12:49pm UTC](https://discuss.elastic.co/t/data-warehouse/134050/1 "2018-05-31T12:49:25Z")

</div>

Hi  
I have a data warehouse with about 14 million transactions per day( 10 years, about 51 billion records) this data has been archived on oracle and because of performance issues no analytic report can be executed on the servers. I decided to transfer the data to distributed platforms like Spark .  
Is it possible to transfer the data to elastic search and build my data warehouse on elastic search? Does ES support SQL to make my analytic reports? Does ES require more servers than Spark?  
Thank you

---

<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:** [June 28, 2018, 12:49pm UTC](https://discuss.elastic.co/t/data-warehouse/134050/2 "2018-06-28T12:49:26Z")

</div>

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