{"id":593,"date":"2014-12-16T00:45:24","date_gmt":"2014-12-15T22:45:24","guid":{"rendered":"http:\/\/www.rocworks.at\/wordpress\/?p=593"},"modified":"2014-12-26T01:00:00","modified_gmt":"2014-12-25T23:00:00","slug":"how-to-replicate-values-to-data-centers-big-data-soa-with-wincc-oa","status":"publish","type":"post","link":"https:\/\/www.rocworks.at\/wordpress\/?p=593","title":{"rendered":"How to replicate values to data centers, big-data, SOA, … with WinCC OA…"},"content":{"rendered":"

With a little adaptor in the RDB-Manager it is easy to forward values to an Java EE Server like Glassfish (free).<\/p>\n

And from a Java-Bean values can be forwarded to any kind of data sink.<\/p>\n

 <\/p>\n

As an example i forwared values to Oracle Event Processing<\/p>\n

http:\/\/www.oracle.com\/us\/products\/middleware\/soa\/overview\/complex-event-processing-ds-066411.pdf<\/p>\n

Enabling Fast Data and the Internet of Things.<\/p>\n

 <\/p>\n

Calculate a moving average in WinCC OA? Quite simple with CQL\u00a0(Continous Query Language, this is not SQL):<\/p>\n

select el, avg(val) as val from channel1 [RANGE 1 MINUTE SLIDE 5 SECONDS] group by el<\/p>\n

 <\/p>\n

Or use the power of Microsoft Machine Learing:\u00a0http:\/\/azure.microsoft.com\/en-gb\/services\/machine-learning\/<\/a><\/p>\n

Machine learning \u2013 mining historical data with computer systems to predict future trends or behaviour \u2013 touches more and more lives every day. Search engines, online recommendations, ad targeting, virtual assistants, demand forecasting, fraud detection, spam filters \u2013 machine learning powers all these modern services. But these uses barely scratch the surface of what’s possible.<\/p>\n

\"Rest-Forward\"<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

With a little adaptor in the RDB-Manager it is easy to forward values to an Java EE Server like Glassfish (free). And from a Java-Bean values can be forwarded to any kind of data sink.   As an example i forwared values to Oracle Event Processing http:\/\/www.oracle.com\/us\/products\/middleware\/soa\/overview\/complex-event-processing-ds-066411.pdf Enabling Fast Data and the Internet of Things. … Continue reading How to replicate values to data centers, big-data, SOA, … with WinCC OA…<\/span> →<\/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":[4,3],"tags":[],"class_list":["post-593","post","type-post","status-publish","format-standard","hentry","category-oracle","category-wincc-oa"],"_links":{"self":[{"href":"https:\/\/www.rocworks.at\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/593","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=593"}],"version-history":[{"count":3,"href":"https:\/\/www.rocworks.at\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/593\/revisions"}],"predecessor-version":[{"id":608,"href":"https:\/\/www.rocworks.at\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/593\/revisions\/608"}],"wp:attachment":[{"href":"https:\/\/www.rocworks.at\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=593"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rocworks.at\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=593"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rocworks.at\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=593"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}