With a “few lines” of code Oracle is able to fetch WinCC OA values over XMLRPC webservice – current and history values (WinCC OA RDB-Manager is not needed).
WinCC OA values can be queried with “natural” Oracle SQL Statements
select t.dp, wccoa.dpGet(t.dp||'.int'), wccoa.dpGet(t.dp||'.int:_online.._stime')
from dpnames t where dp like 'Example%'
So, it is also easy to create “WinCC OA” (Web)APEX Applications!
New “C# WinCC Open Architecture Connector” version.
2013.01.01: Added Proxy-Server with client/server TCP/IP connection for dp(Query)Connects and unsolicited data multicasting.
2012.12.23: Added a very simple C# WinForms application which displays two datapoints, waits
for value changes and values can also be set by a button out of the WinForms application.
2012.12.23: Added WaitDataMulti function which performs a dpWaitForValue. Can be used to wait
for a change of value of data points of a taglist.
list top windows threads. useful when using oracle on windows, where oracle is one big process with many threads (and windows task manager doesn’t show threads of a process…). if an odbc connection string is passed then also some useful information about the corresponding oracle process/session is displayed (oracle user, sid, serial#, …)
http://sourceforge.net/projects/topthreads/?source=directory
http://www.youtube.com/watch?v=k_55xCzwWrQ&feature=player_embedded#!
Functions implemented in C# for WinCC OA communication can also be used to build Android Apps with Mono for Android from Xamarin – http://xamarin.com