# Alternative BI Reporting visualization tool for Kibana **URL:** \ **Category:** Elasticsearch\ **Created:** [October 1, 2014, 10:43pm UTC](https://discuss.elastic.co/t/alternative-bi-reporting-visualization-tool-for-kibana/20033 "2014-10-01T22:43:53Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![Petr\_Lazecky](https://avatars.discourse-cdn.com/v4/letter/p/e9c0ed/32.png) [@Petr\_Lazecky](https://discuss.elastic.co/u/Petr_Lazecky)\ **Post date:** [October 1, 2014, 10:43pm UTC](https://discuss.elastic.co/t/alternative-bi-reporting-visualization-tool-for-kibana/20033/1 "2014-10-01T22:43:53Z")
Hi guys, I have following question for you. Let's say that I would like to use alternative reporting tool to display aggregated data and documents from Elasticsearch instead of Kibana. There is nothing wrong with Kibana as such but alternative tool may have additional features that I may found useful; KPI and treshold management, notifications when particular KPI values are reached, ability to provide rich visualizations (Tableau) etc. To be concreate, I would like to consume Elasticsearch results from Kibana and Pentaho also. I have found that there may be some Pentaho Kettle job to extract data from Elasticseach but due to very limited information use case for this is really not clear. I have found that Elasticsearch supports snapshots and repositories which may be what I am looking for but I am not sure if these data structures are consumable by other tools even using ETL engine. One particular use case I have in mind is to take Elasticsearch snapshot and tranform it using ETL to star schema into traditional OLAP database from which I can make regular OLAP drilldown/ data slicing queries. Scenario I have in mind is to use Elasticsearch platform for live, most-up-to-date analytical queries while I can use durable storage as back-up or archive of Elasticsearch documents. Such archive can be used for offline reporting. Technically it boils down to the question what data formats are passed between Elasticsearch and Kibana and hwether there are APIs exposed to consume this format from other reporting tools (or ETL engines that can consume it and store it on traditional relational DB). I would appreciate any help, direction or comments to this idea. -- 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/f7dc85eb-70ad-4468-9210-6fa770cb73a5%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/f7dc85eb-70ad-4468-9210-6fa770cb73a5%40googlegroups.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\ **Post date:** [October 1, 2014, 10:48pm UTC](https://discuss.elastic.co/t/alternative-bi-reporting-visualization-tool-for-kibana/20033/2 "2014-10-01T22:48:38Z")
Kibana does everything via the Elasticsearch APIs. You might want to have a poke around the docs - > **[Elasticsearch Platform — Find real-time answers at scale](https://www.elastic.co)** > > Power insights and outcomes with the Elasticsearch Platform and AI. See into your data and find answers that matter with enterprise solutions designed to help you build, observe, and protect. Try Elasticsearch free today. Regards, Mark Walkom Infrastructure Engineer Campaign Monitor email: [markw@campaignmonitor.com](mailto:markw@campaignmonitor.com) web: [www.campaignmonitor.com](http://www.campaignmonitor.com) On 2 October 2014 08:43, Petr Lazecky [petr.lazecky@gmail.com](mailto:petr.lazecky@gmail.com) wrote: > Hi guys, > > I have following question for you. > > Let's say that I would like to use alternative reporting tool to display > aggregated data and documents from Elasticsearch instead of Kibana. There > is nothing wrong with Kibana as such but alternative tool may have > additional features that I may found useful; KPI and treshold management, > notifications when particular KPI values are reached, ability to provide > rich visualizations (Tableau) etc. To be concreate, I would like to consume > Elasticsearch results from Kibana and Pentaho also. I have found that there > may be some Pentaho Kettle job to extract data from Elasticseach but due to > very limited information use case for this is really not clear. > > I have found that Elasticsearch supports snapshots and repositories which > may be what I am looking for but I am not sure if these data structures are > consumable by other tools even using ETL engine. > > One particular use case I have in mind is to take Elasticsearch snapshot > and tranform it using ETL to star schema into traditional OLAP database > from which I can make regular OLAP drilldown/ data slicing queries. > Scenario I have in mind is to use Elasticsearch platform for live, > most-up-to-date analytical queries while I can use durable storage as > back-up or archive of Elasticsearch documents. Such archive can be used for > offline reporting. > > Technically it boils down to the question what data formats are passed > between Elasticsearch and Kibana and hwether there are APIs exposed to > consume this format from other reporting tools (or ETL engines that can > consume it and store it on traditional relational DB). > > I would appreciate any help, direction or comments to this idea. > > -- > 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/f7dc85eb-70ad-4468-9210-6fa770cb73a5%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/f7dc85eb-70ad-4468-9210-6fa770cb73a5%40googlegroups.com) > [https://groups.google.com/d/msgid/elasticsearch/f7dc85eb-70ad-4468-9210-6fa770cb73a5%40googlegroups.com?utm\_medium=email&utm\_source=footer](https://groups.google.com/d/msgid/elasticsearch/f7dc85eb-70ad-4468-9210-6fa770cb73a5%40googlegroups.com?utm_medium=email&utm_source=footer) > . > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). -- 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/CAEM624Zt7bA6gY35CXHQqyix5KdvkP7rPuBJ5gNqm7MVtf3VbQ%40mail.gmail.com](https://groups.google.com/d/msgid/elasticsearch/CAEM624Zt7bA6gY35CXHQqyix5KdvkP7rPuBJ5gNqm7MVtf3VbQ%40mail.gmail.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![Petr\_Lazecky](https://avatars.discourse-cdn.com/v4/letter/p/e9c0ed/32.png) [@Petr\_Lazecky](https://discuss.elastic.co/u/Petr_Lazecky)\ **Post date:** [October 1, 2014, 10:52pm UTC](https://discuss.elastic.co/t/alternative-bi-reporting-visualization-tool-for-kibana/20033/3 "2014-10-01T22:52:05Z")
Thank you Mark, this may be way to go Dne středa, 1. října 2014 18:49:05 UTC-4 Mark Walkom napsal(a): > Kibana does everything via the Elasticsearch APIs. > You might want to have a poke around the docs - > [Elasticsearch Platform — Find real-time answers at scale | Elastic](http://www.elasticsearch.org/guide/en/elasticsearch/reference/current/index.html) > > Regards, > Mark Walkom > > Infrastructure Engineer > Campaign Monitor > email: [ma...@campaignmonitor.com](mailto:ma...@campaignmonitor.com) \ > web: [www.campaignmonitor.com](http://www.campaignmonitor.com) > > On 2 October 2014 08:43, Petr Lazecky \<[petr.l...@gmail.com](mailto:petr.l...@gmail.com) \\> > wrote: > > > Hi guys, > > > > I have following question for you. > > > > Let's say that I would like to use alternative reporting tool to display > > aggregated data and documents from Elasticsearch instead of Kibana. There > > is nothing wrong with Kibana as such but alternative tool may have > > additional features that I may found useful; KPI and treshold management, > > notifications when particular KPI values are reached, ability to provide > > rich visualizations (Tableau) etc. To be concreate, I would like to consume > > Elasticsearch results from Kibana and Pentaho also. I have found that there > > may be some Pentaho Kettle job to extract data from Elasticseach but due to > > very limited information use case for this is really not clear. > > > > I have found that Elasticsearch supports snapshots and repositories which > > may be what I am looking for but I am not sure if these data structures are > > consumable by other tools even using ETL engine. > > > > One particular use case I have in mind is to take Elasticsearch snapshot > > and tranform it using ETL to star schema into traditional OLAP database > > from which I can make regular OLAP drilldown/ data slicing queries. > > Scenario I have in mind is to use Elasticsearch platform for live, > > most-up-to-date analytical queries while I can use durable storage as > > back-up or archive of Elasticsearch documents. Such archive can be used for > > offline reporting. > > > > Technically it boils down to the question what data formats are passed > > between Elasticsearch and Kibana and hwether there are APIs exposed to > > consume this format from other reporting tools (or ETL engines that can > > consume it and store it on traditional relational DB). > > > > I would appreciate any help, direction or comments to this idea. > > > > -- > > 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 [elasticsearc...@googlegroups.com](mailto:elasticsearc...@googlegroups.com) \. > > To view this discussion on the web visit > > [https://groups.google.com/d/msgid/elasticsearch/f7dc85eb-70ad-4468-9210-6fa770cb73a5%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/f7dc85eb-70ad-4468-9210-6fa770cb73a5%40googlegroups.com) > > [https://groups.google.com/d/msgid/elasticsearch/f7dc85eb-70ad-4468-9210-6fa770cb73a5%40googlegroups.com?utm\_medium=email&utm\_source=footer](https://groups.google.com/d/msgid/elasticsearch/f7dc85eb-70ad-4468-9210-6fa770cb73a5%40googlegroups.com?utm_medium=email&utm_source=footer) > > . > > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). -- 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/5f6a859f-45dd-41da-9a4f-693191344ada%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/5f6a859f-45dd-41da-9a4f-693191344ada%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, 12:58am UTC](https://discuss.elastic.co/t/alternative-bi-reporting-visualization-tool-for-kibana/20033/4 "2017-07-06T00:58:49Z")