# Elasticsearch taking input from cassandra and visualizing through kibana **URL:** \ **Category:** Elasticsearch\ **Created:** [January 7, 2017, 12:22pm UTC](https://discuss.elastic.co/t/elasticsearch-taking-input-from-cassandra-and-visualizing-through-kibana/70851 "2017-01-07T12:22:07Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![jafferwilson](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jafferwilson/32/14379_2.png) [@jafferwilson](https://discuss.elastic.co/u/jafferwilson)\ **Post date:** [January 7, 2017, 12:22pm UTC](https://discuss.elastic.co/t/elasticsearch-taking-input-from-cassandra-and-visualizing-through-kibana/70851/1 "2017-01-07T12:22:07Z")
Hello everyone, Please let me know whether it is possible to connect the cassandra data with elasticsearch. Can I fetch the data from cassandra into elasticsearch and use kibana to visualize it. if yes then how? if no then why not? Kindly, help me. I do not know whether to use elasticsearch or not for this purpose. ---
**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\ **Post date:** [January 7, 2017, 1:24pm UTC](https://discuss.elastic.co/t/elasticsearch-taking-input-from-cassandra-and-visualizing-through-kibana/70851/2 "2017-01-07T13:24:27Z")
Best option IMHO is to send data from your application to both systems at the same time. ---
**Author:** ![jafferwilson](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jafferwilson/32/14379_2.png) [@jafferwilson](https://discuss.elastic.co/u/jafferwilson)\ **Post date:** [January 7, 2017, 2:01pm UTC](https://discuss.elastic.co/t/elasticsearch-taking-input-from-cassandra-and-visualizing-through-kibana/70851/3 "2017-01-07T14:01:32Z")
Please can you explain to me what exactly you want to say. I am new to elasticsearch. Hence do not know how I can make elasticsearch interact with cassandra. Currently I am just experimenting whether elasticsearch is the best solution for my search or not. So I am using the cassandra and elasticsearch on localhost or standalone system. If you can explain with an example, it will be awesome and very helpful. ---
**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\ **Post date:** [January 7, 2017, 4:34pm UTC](https://discuss.elastic.co/t/elasticsearch-taking-input-from-cassandra-and-visualizing-through-kibana/70851/4 "2017-01-07T16:34:22Z")
I meant that you probably have an application which is writing data to Cassandra. In this application, while you send data to Cassandra, send also data to elasticsearch. I explained something similar but for RDBMS at [https://david.pilato.fr/blog/2015-05-09-advanced-search-for-your-legacy-application/](http://david.pilato.fr/blog/2015/05/09/advanced-search-for-your-legacy-application/). To me you can apply the same concept to any other datastore and Elasticsearch. I'm not sure if there are projects to synchronize from Cassandra to elasticsearch. You can look at using Logstash JDBC input with a Cassandra JDBC driver as someone explained at: > [@How to continuously pull from Cassandra into Logstash](https://discuss.elastic.co/t/how-to-continuously-pull-from-cassandra-into-logstash/44674): > > Hi all, I'm trying to setup Logstash to continuously pull information from Cassandra, in the same fashion it works with file inputs. I'm using the [Cassandra JDBC Driver](http://www.dbschema.com/cassandra-jdbc-driver.html) and I can successfully pull the contents, but once I get the result of my SELECT statement, Logstash closes down. The next time I start it, it reads the entire table again. Is there a way to configure it to run as a daemon and pull any new entries matching my statement? Here is my current config: input { jdbc { jdbc\_connect… But it's more a batch which run every X minutes so not really real time. Might fit your needs though. ---
**Author:** ![eperry](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/eperry/32/551_2.png) [@eperry](https://discuss.elastic.co/u/eperry)\ **Post date:** [January 7, 2017, 7:23pm UTC](https://discuss.elastic.co/t/elasticsearch-taking-input-from-cassandra-and-visualizing-through-kibana/70851/5 "2017-01-07T19:23:58Z")
If you want to just visualize data in Casandra you can look at this project [https://zeppelin.apache.org/](https://zeppelin.apache.org/) If you want historical and other data of your database Logstash JDBC Connector would work. I agree with DaDoonNet, that it is good to have the application send the data to PostGres and ELK for more real-time data but that is an architectural and requirements needs [https://www.confluent.io/blog/bottled-water-real-time-integration-of-postgresql-and-kafka/](https://www.confluent.io/blog/bottled-water-real-time-integration-of-postgresql-and-kafka/) once in kafka you can use logstash to consume and insert to Elastic ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [February 4, 2017, 7:24pm UTC](https://discuss.elastic.co/t/elasticsearch-taking-input-from-cassandra-and-visualizing-through-kibana/70851/6 "2017-02-04T19:24:00Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.