-
Recent Posts
- SCADA Real Time Data and Apache SPARK
- Access to relational databases with WinCC Unified
- Collect Factory data and write it to Kafka, with the Automation Gateway…
- WinCC Unified V18 exposed to the Internet…
- GraphQL for Unity with WinCC Unified
- WinCC Unified GraphQL Server for Data Integration
- AWS AppSync query with Cognito User Pool
- AWS AppSync Real-Time Support for GraphQL for Unity…
- Apollo 3.0 Websocket Protocol for GraphQL for Unity (V1.5.0)
- Unity3D in WinCC Open Architecture
Categories
Meta
Category Archives: APEX
Oracle Apex RESTful Services…
To use RESTful Oracle Apex Services following grant has to be done: alter user grant connect through apex_rest_public_user;
Posted in APEX
Comments Off on Oracle Apex RESTful Services…
Export Oracle APEX Applications of Workspace
How to export all applications of an Oracle APEX Workspace: export CLASSPATH=.:/app/oracle/product/11.2.0/dbhome_1/jdbc/lib/ojdbc5.jar:/app/apex/utilities java oracle.apex.APEXExport -db localhost:1521:ORCL -user system -password -workspaceid 2097002597188478 /app/apex ==> Oracle APEX Installation-Directory
Posted in APEX
Comments Off on Export Oracle APEX Applications of Workspace
Oracle Apex Blob as Download-Link…
First of all you have to select the blob column like this: select project_id, mimetype, filename, dbms_lob.getlength(“OUTPUT”) AS output from TR_PROJECT t order by uploadts desc If not you will get an error message. AS Number/Date Format use a string … Continue reading
Posted in APEX
Comments Off on Oracle Apex Blob as Download-Link…
WinCC OA on Raspberry Pi…
works great! Photovoltaik-Power: http://rocworks.no-ip.org:8080/apex/f?p=102 Meter-Values: http://rocworks.no-ip.org:8080/apex/f?p=102:8
SmartHome Power Monitoring with WinCC OA and Oracle/APEX…
Power Monitoring http://rocworks.no-ip.org:8080/apex/f?p=100 The system also controls my hot water boiler heater
SmartHome Architecture…
SmartHome…. high availability architecture… but just for fun and to play with some technologies. The system is also able to run on a single system like the “Scada Local” system, and this is just an old Lenovo Netbook with 2GB RAM… … Continue reading
Posted in APEX, Oracle, Virtualization, WinCC OA
Comments Off on SmartHome Architecture…
WinCC OA APEX jQuery mobile smartphone demo…
Apex-Mobile-Demo Simple mobile smartphone demo build with Oracle APEX connected to WinCC OA (www.etm.at). It tooks me about 3h… and i had NO experience with APEX! The map does not work on (my) android smartphone… maybe a known bug: http://www.oracle.com/technetwork/developer-tools/apex/application-express/apex-42-known-issues-1863578.html Connectivity … Continue reading
Oracle and APEX meets WinCC OA…
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 … Continue reading