用于 sql 数据库的 kibana

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/27023210/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me): StackOverFlow

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-09-01 02:57:40  来源:igfitidea点击:

kibana for sql database

sqlvisualizationdashboardkibana

提问by Oussama L.

I need to build a kibana like dashboard over a sql database. Is this possible? or is there an alternative as easy as kibana (in term of integration) for sql?

我需要在 sql 数据库上构建一个类似 kibana 的仪表板。这可能吗?或者有没有像 kibana(在集成方面)一样简单的 sql 替代方案?

回答by user3165256

Siren ( http://siren.io) is an extended Kibana which has support for connecting directly to SQL (or other APIs) and create filters and analytics.

Siren ( http://siren.io) 是一个扩展的 Kibana,它支持直接连接到 SQL(或其他 API)并创建过滤器和分析。

Check it out

一探究竟

回答by Ensar Hatipoglu

There is a blog about how to index SQL databases in Elasticsearch here: http://blog.comperiosearch.com/blog/2014/01/30/elasticsearch-indexing-sql-databases-the-easy-way/

这里有一篇关于如何在 Elasticsearch 中索引 SQL 数据库的博客:http: //blog.comperiosearch.com/blog/2014/01/30/elasticsearch-indexing-sql-databases-the-easy-way/

Once you get it indexed, you can set up your Kibana to view your data.

将其编入索引后,您可以设置 Kibana 以查看您的数据。

You can also find more options suggested here: http://community.spiceworks.com/topic/377151-generate-a-dashboard-from-sql-database

您还可以在此处找到更多建议的选项:http: //community.spiceworks.com/topic/377151-generate-a-dashboard-from-sql-database

回答by Brano

this could be an alternative for you- https://github.com/KPIWatchdog/DBconnectorcreates an API to the tool where you can create queries, visualise data, prepare dashboards and share to others. Depending on the number of metrics, you can opt for free plan or small monthly fee.

这可能是您的替代方案 - https://github.com/KPIWatchdog/DBconnector为该工具创建了一个 API,您可以在其中创建查询、可视化数据、准备仪表板并与他人共享。根据指标的数量,您可以选择免费计划或小额月费。