# Options for accessing ES repository from traditional BI tools that do not aupport REST API **URL:** \ **Category:** Elasticsearch\ **Created:** [June 8, 2014, 5:39pm UTC](https://discuss.elastic.co/t/options-for-accessing-es-repository-from-traditional-bi-tools-that-do-not-aupport-rest-api/17982 "2014-06-08T17:39:31Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![elitem\_way](https://avatars.discourse-cdn.com/v4/letter/e/df705f/32.png) [@elitem\_way](https://discuss.elastic.co/u/elitem_way)\ **Post date:** [June 8, 2014, 5:39pm UTC](https://discuss.elastic.co/t/options-for-accessing-es-repository-from-traditional-bi-tools-that-do-not-aupport-rest-api/17982/1 "2014-06-08T17:39:31Z")
Since ES support aggregation query now, I am thinking using ES as a data warehouse staging area. The challenge is pulling the summary data from ES using traditional BI tool like Tableau. I know Hive ODBC driver - ES-Hadoop Hive is an option, but it is very slow compared with native REST API. Are there other options? Does ES have plan to support SQL query interface natively? Thanks. -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/02a67508-5f3d-4e40-9f98-6df6eddd4a8c%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/02a67508-5f3d-4e40-9f98-6df6eddd4a8c%40googlegroups.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [July 6, 2017, 1:23am UTC](https://discuss.elastic.co/t/options-for-accessing-es-repository-from-traditional-bi-tools-that-do-not-aupport-rest-api/17982/2 "2017-07-06T01:23:53Z")