{"id":627,"date":"2015-09-09T07:51:56","date_gmt":"2015-09-09T05:51:56","guid":{"rendered":"http:\/\/www.rocworks.at\/wordpress\/?p=627"},"modified":"2016-03-31T21:09:13","modified_gmt":"2016-03-31T19:09:13","slug":"grafana-dashboards-and-hadoop-opentsdb-timeseries-database-with-wincc-oa","status":"publish","type":"post","link":"https:\/\/www.rocworks.at\/wordpress\/?p=627","title":{"rendered":"Hadoop OpenTSDB timeseries database and Grafana with WinCC OA&#8230;"},"content":{"rendered":"<p>Forwarding events from WinCC OA to OpenTSDB, which is based on HBase. Based on OpenTSDB Grafan can be used to build cool\u00a0dashboards in a very fast way.<\/p>\n<p>Live Example (my photovoltaic data) : <a title=\"Electric Meter Dashboard\" href=\"http:\/\/82.149.127.81\/grafana\" target=\"_blank\">http:\/\/82.149.127.81\/grafana<\/a><\/p>\n<p>On my test\u00a0environment (i7 with 32gb RAM and 8 threads) i was able to push about <strong>20000(!) values per second<\/strong> from my WinCC OA system to my Hadoop\/HBase cluster. WinCC OA and the Hadoop Cluster are running on Hyper-V.<\/p>\n<p><a href=\"http:\/\/www.rocworks.at\/wordpress\/wp-content\/uploads\/2015\/08\/Grafana.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-628\" src=\"http:\/\/www.rocworks.at\/wordpress\/wp-content\/uploads\/2015\/08\/Grafana.png\" alt=\"Grafana\" width=\"1041\" height=\"577\" srcset=\"https:\/\/www.rocworks.at\/wordpress\/wp-content\/uploads\/2015\/08\/Grafana.png 1041w, https:\/\/www.rocworks.at\/wordpress\/wp-content\/uploads\/2015\/08\/Grafana-300x166.png 300w, https:\/\/www.rocworks.at\/wordpress\/wp-content\/uploads\/2015\/08\/Grafana-1024x567.png 1024w\" sizes=\"auto, (max-width: 1041px) 100vw, 1041px\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Forwarding events from WinCC OA to OpenTSDB, which is based on HBase. Based on OpenTSDB Grafan can be used to build cool\u00a0dashboards in a very fast way. Live Example (my photovoltaic data) : http:\/\/82.149.127.81\/grafana On my test\u00a0environment (i7 with 32gb RAM and 8 threads) i was able to push about 20000(!) values per second from &hellip; <a href=\"https:\/\/www.rocworks.at\/wordpress\/?p=627\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">Hadoop OpenTSDB timeseries database and Grafana with WinCC OA&#8230;<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1,29,3],"tags":[],"class_list":["post-627","post","type-post","status-publish","format-standard","hentry","category-allgemein","category-bigdatanosql","category-wincc-oa"],"_links":{"self":[{"href":"https:\/\/www.rocworks.at\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/627","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rocworks.at\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.rocworks.at\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.rocworks.at\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rocworks.at\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=627"}],"version-history":[{"count":6,"href":"https:\/\/www.rocworks.at\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/627\/revisions"}],"predecessor-version":[{"id":645,"href":"https:\/\/www.rocworks.at\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/627\/revisions\/645"}],"wp:attachment":[{"href":"https:\/\/www.rocworks.at\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=627"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rocworks.at\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=627"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rocworks.at\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=627"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}