Alternative BI Reporting visualization tool for Kibana

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.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/f7dc85eb-70ad-4468-9210-6fa770cb73a5%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Kibana does everything via the Elasticsearch APIs.
You might want to have a poke around the docs -
http://www.elasticsearch.org/guide/en/elasticsearch/reference/current/index.html

Regards,
Mark Walkom

Infrastructure Engineer
Campaign Monitor
email: markw@campaignmonitor.com
web: www.campaignmonitor.com

On 2 October 2014 08:43, Petr Lazecky 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.
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?utm_medium=email&utm_source=footer
.
For more options, visit 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.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/CAEM624Zt7bA6gY35CXHQqyix5KdvkP7rPuBJ5gNqm7MVtf3VbQ%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

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 -
http://www.elasticsearch.org/guide/en/elasticsearch/reference/current/index.html

Regards,
Mark Walkom

Infrastructure Engineer
Campaign Monitor
email: ma...@campaignmonitor.com <javascript:>
web: www.campaignmonitor.com

On 2 October 2014 08:43, Petr Lazecky <petr.l...@gmail.com <javascript:>>
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 <javascript:>.
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?utm_medium=email&utm_source=footer
.
For more options, visit 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.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/5f6a859f-45dd-41da-9a4f-693191344ada%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.