Introduction

Our platform offers a range of features for defining and handling datasets, tailored to different parameters like process variables, time intervals, and data sources. Users can gather data from SCADA systems, PLCs, and other devices.

These functionalities cover various data types - real-time, historical, and aggregate - giving users a holistic view of system performance. Users can set data acquisition intervals, thresholds, and alarms to maintain data accuracy and consistency.

On this page:

Key Functionalities

Features Highlights

  • SQL Query Support: Effortlessly extract, manipulate, and transform data from diverse sources using efficient SQL queries.
  • Integration with External Data Sources: Seamlessly collect and analyze data from various external sources like SQL databases and CSV files.
  • Visual Query Editor: Easily create and edit advanced SQL queries without needing extensive SQL knowledge, simplifying the process.
  • Distributed Architecture: Supports simultaneous requests and provides flexibility in processing data on either the client or server side.
  • Stored Procedures Execution: Allows for advanced data manipulation and analysis directly within the platform.
  • Real-Time Execution: Execute SQL queries with real-time data, enabling parameter customization and timely analysis of generated data.


Built-in Embedded SQL

Every system comes with a fully functional embedded SQL Lite database at no additional cost, requiring no setup. This offers several benefits:

  • Secure Project Configuration: It serves as a secure repository for your entire project configuration.
  • Historian Database: Suitable for small to medium systems, it can function as a historian database for logging tags, alarms, and events (up to 10GB of data).
  • Store and Forward: For large systems, it serves as a local Store and Forward location, - stepping in when the remote database is unavailable.
  • Storage for Local Data: It's an ideal system for storing local runtime settings, retentive information, local recipes, schedules, tables, and queries needed for report preparation.


Multiple Database Connections

Our projects support multiple databases, seamlessly integrating with SQL and other database technologies such as ADO.NET, ODBC, OleDB, and more.


SQL Statement Editor

Our editor enhances code editing by offering Intellisense and helpful code suggestions, making the process faster and more efficient.

Secure Data Gateway

Our platform offers a built-in data gateway that's firewall-friendly, ensuring secure data query routing from clients without requiring direct access to the database.


Learn more at Datasets (SQL Queries).


In this section...