Data in blob fields are Java object serializations. The only practical way of viewing them is using Java code to deserialize. The only objects that are serialized in this way are data source and data point definitions, which are very application specific anyway.

For background... Originally, tables were defined for each type of data source and point such that the information was stored in a more traditional way, i.e. each distinct piece of data in a distinct field. However, as more data source types were added to Mango it quickly became a significant maintenance issue. The current storage technique of using blob has a number of strong advantages, with really the only downside being the fact that - as you've noticed - the content is inaccessible via SQL.

That is likely related to something else. Please try again and see if they appear now. If not, please make note of the icon URL.

Hi Roberto,

Mango can read from an external database using the SQL data source. Out of the box it can connect to a MySQL database, but others can be implemented by finding the appropriate driver (usually just a jar file that you can add to WEB-INF/lib).

If you are on a Windows platform, it is possible to use an ODBC/JDBC driver to connect Mango to and ODBC data source. In Windows you can then set up various things - like flat files, Excel spreadsheets, Access databases - as your ODBC sources. Might be worth a try. By finding the appropriate drivers (which are typically easy to find), you can also connect Mango directly to Oracle, MS SQL Server, Postgres, etc.

Your alternative to having a database intermediary is to connect directly to your A/D converter processing board, assuming it supports some communications protocol like Modbus, BACNet, 1-wire, etc. Do you know?

Once you've decided on a connectivity strategy, i can help you with the details.