Ewon flexy 201 reading data using SQL

Hi,

we are using Ewon Flexy 201. we are reading some analog values and we have enabled history logging means recording values .

we want to extract this values to our existing IT reporting system “ERP” where we can directly pull all the data from ewon and show to our existing system

advise if its possible ? using SQL or ODBC ? if yes How ?

in addition can we generate some reports of the historical logged data automatically everyday ?? and send an email ?

Hi Dhaval,

The Flexy doesn’t support publishing through SQL or ODBC, but you can use Modbus, OPC UA, or SNMP to publish the Ewon’s tags. To enable this, edit a tag on the Flexy and scroll down to Tag Visibility. There you’ll be able to enable Modbus TCP or SNMP and specify the register/OID used for the tag. You can enable OPC UA in Setup → System → Main → Net services → OPCUA, then optionally select groups of tags to make available.

More information:

You can send reports of historical data using the Planner, which can be found in Setup → System → Main → General → Planner. You can see an example of a task planner entry here: Example of a Task Planner entry

Finally, here’s the EBD helper, which helps construct the Export Block Descriptor statement that defines the data that’s exported by the Planner: EBD Helper