Need advice about which tool to choose?Ask the StackShare community!
Grafana vs Superset: What are the differences?
In the world of data visualization and analytics, Grafana and Superset are two popular tools that offer powerful features and functionalities. While both tools serve the same purpose of helping users visualize and explore data, there are key differences between them.
Architecture: Grafana is a standalone application written in Go language, while Superset is a web-based application built with Python and Flask framework. This architectural difference affects their deployment and integration capabilities with other systems.
Data Sources: Grafana supports a wide range of data sources including popular databases like MySQL and PostgreSQL, as well as cloud-based services like AWS CloudWatch and Google Analytics. On the other hand, Superset has built-in connectors for various databases but lacks support for cloud-based services.
Visualizations: Grafana provides a rich set of visualizations and dashboards out of the box, making it easy for users to create and customize visualizations. Superset also offers a wide range of visualizations but requires more configuration and customization to achieve desired results.
User Interface: Grafana has a more intuitive and user-friendly interface, with drag-and-drop capabilities and real-time dashboard updates. Superset, while also having a user-friendly interface, lacks some of the advanced features and ease of use that Grafana offers.
Community and Ecosystem: Grafana has a larger and more active community, with a vast ecosystem of plugins and extensions. This means more support and resources for users, as well as the ability to extend the functionality of Grafana with additional plugins. Superset, although growing in popularity, has a smaller community and ecosystem in comparison.
Use Cases: Grafana is well-suited for monitoring and observability use cases, especially in the realm of IT infrastructure and DevOps. It excels at real-time data visualization and alerting. Superset, on the other hand, is more focused on business intelligence and ad-hoc data exploration use cases, providing powerful data exploration and analysis capabilities.
In summary, Grafana and Superset differ in terms of architecture, data source support, visualizations, user interface, community & ecosystem, and use cases. Understanding these differences can help users choose the right tool based on their specific requirements and goals.
Looking for a tool which can be used for mainly dashboard purposes, but here are the main requirements:
- Must be able to get custom data from AS400,
- Able to display automation test results,
- System monitoring / Nginx API,
- Able to get data from 3rd parties DB.
Grafana is almost solving all the problems, except AS400 and no database to get automation test results.
You can look out for Prometheus Instrumentation (https://prometheus.io/docs/practices/instrumentation/) Client Library available in various languages https://prometheus.io/docs/instrumenting/clientlibs/ to create the custom metric you need for AS4000 and then Grafana can query the newly instrumented metric to show on the dashboard.
We're looking for a Monitoring and Logging tool. It has to support AWS (mostly 100% serverless, Lambdas, SNS, SQS, API GW, CloudFront, Autora, etc.), as well as Azure and GCP (for now mostly used as pure IaaS, with a lot of cognitive services, and mostly managed DB). Hopefully, something not as expensive as Datadog or New relic, as our SRE team could support the tool inhouse. At the moment, we primarily use CloudWatch for AWS and Pandora for most on-prem.
this is quite affordable and provides what you seem to be looking for. you can see a whole thing about the APM space here https://www.apmexperts.com/observability/ranking-the-observability-offerings/
I worked with Datadog at least one year and my position is that commercial tools like Datadog are the best option to consolidate and analyze your metrics. Obviously, if you can't pay the tool, the best free options are the mix of Prometheus with their Alert Manager and Grafana to visualize (that are complementary not substitutable). But I think that no use a good tool it's finally more expensive that use a not really good implementation of free tools and you will pay also to maintain its.
From a StackShare Community member: “We need better analytics & insights into our Elasticsearch cluster. Grafana, which ships with advanced support for Elasticsearch, looks great but isn’t officially supported/endorsed by Elastic. Kibana, on the other hand, is made and supported by Elastic. I’m wondering what people suggest in this situation."
For our Predictive Analytics platform, we have used both Grafana and Kibana
- Grafana based demo video: https://www.youtube.com/watch?v=tdTB2AcU4Sg
- Kibana based reporting screenshot: https://imgur.com/vuVvZKN
Kibana has predictions
and ML algorithms support, so if you need them, you may be better off with Kibana . The multi-variate analysis features it provide are very unique (not available in Grafana).
For everything else, definitely Grafana . Especially the number of supported data sources, and plugins clearly makes Grafana a winner (in just visualization and reporting sense). Creating your own plugin is also very easy. The top pros of Grafana (which it does better than Kibana ) are:
- Creating and organizing visualization panels
- Templating the panels on dashboards for repetetive tasks
- Realtime monitoring, filtering of charts based on conditions and variables
- Export / Import in JSON format (that allows you to version and save your dashboard as part of git)
I use both Kibana and Grafana on my workplace: Kibana for logging and Grafana for monitoring. Since you already work with Elasticsearch, I think Kibana is the safest choice in terms of ease of use and variety of messages it can manage, while Grafana has still (in my opinion) a strong link to metrics
After looking for a way to monitor or at least get a better overview of our infrastructure, we found out that Grafana (which I previously only used in ELK stacks) has a plugin available to fully integrate with Amazon CloudWatch . Which makes it way better for our use-case than the offer of the different competitors (most of them are even paid). There is also a CloudFlare plugin available, the platform we use to serve our DNS requests. Although we are a big fan of https://smashing.github.io/ (previously dashing), for now we are starting with Grafana .
I use Kibana because it ships with the ELK stack. I don't find it as powerful as Splunk however it is light years above grepping through log files. We previously used Grafana but found it to be annoying to maintain a separate tool outside of the ELK stack. We were able to get everything we needed from Kibana.
Kibana should be sufficient in this architecture for decent analytics, if stronger metrics is needed then combine with Grafana. Datadog also offers nice overview but there's no need for it in this case unless you need more monitoring and alerting (and more technicalities).
@Kibana, of course, because @Grafana looks like amateur sort of solution, crammed with query builder grouping aggregates, but in essence, as recommended by CERN - KIbana is the corporate (startup vectored) decision.
Furthermore, @Kibana comes with complexity adhering ELK stack, whereas @InfluxDB + @Grafana & co. recently have become sophisticated development conglomerate instead of advancing towards a understandable installation step by step inheritance.
Pros of Grafana
- Beautiful89
- Graphs are interactive68
- Free57
- Easy56
- Nicer than the Graphite web interface34
- Many integrations26
- Can build dashboards18
- Easy to specify time window10
- Can collaborate on dashboards10
- Dashboards contain number tiles9
- Open Source5
- Integration with InfluxDB5
- Click and drag to zoom in5
- Authentification and users management4
- Threshold limits in graphs4
- Alerts3
- It is open to cloud watch and many database3
- Simple and native support to Prometheus3
- Great community support2
- You can use this for development to check memcache2
- You can visualize real time data to put alerts2
- Grapsh as code0
- Plugin visualizationa0
Pros of Superset
- Awesome interactive filtering13
- Free9
- Wide SQL database support6
- Shareable & editable dashboards6
- Great for data collaborating on data exploration5
- User & Role Management3
- Easy to share charts & dasboards3
Sign up to add or upvote prosMake informed product decisions
Cons of Grafana
- No interactive query builder1
Cons of Superset
- Link diff db together "Data Modeling "4
- It is difficult to install on the server3
- Ugly GUI3