Skip to main content

Data Sources

Data-oriented data sources connect Mango to external databases, files, web services, and email systems. Unlike protocol data sources that communicate directly with hardware, these data sources integrate Mango with software systems and data repositories.

Available Data Sources​

  • SQL -- Connects to any JDBC-compatible SQL database (H2, MySQL, PostgreSQL, Oracle, SQL Server, and more). Executes SELECT queries on a polling schedule to read values, and supports UPDATE/INSERT statements for writing values back. Supports both row-based and column-based query modes.

  • ASCII File -- Reads values from flat text files (CSV, TSV, or custom delimited) line by line using regular expressions. Useful for integrating with legacy systems that export data to files.

  • Data File -- Reads structured data from XML, CSV, Excel, and binary files placed in a watched directory.