Introduction

The module provides a variety of features that enable users to define and manage datasets based on different parameters, including process variables, time intervals, and data sources. It allows users to collect data from various sources, including SCADA (Supervisory Control and Data Acquisition) systems, PLCs (Programmable Logic Controllers), and other data acquisition devices.

The datasets module also supports various types of data, such as real-time data, historical data, and aggregate data, providing users with a comprehensive view of the system performance and behavior. It enables users to configure data acquisition intervals, thresholds, and alarms, to ensure data accuracy and consistency.


On this page:

Key Functionalities


Built-in Embedded SQL  

Every FrameworX system includes, at no extra cost, a full-featured embedded SQL Lite, with no required configuration. This provides several advantages including:  

  • A safe and secure location for your entire project configuration.
  • It can be used as the historian database to log tags, alarms and events on small to medium systems (up to 10GB of data).
  • On Large systems, it can be used as a local Store and Forward location, when the remote database is not available.
  • It provides an ideal system to store local runtime settings, retentive information, local recipes, schedules and tables and queries when preparing reports. 

 

Multiple Database Connections  

Our projects allow you to have multiple databases, working in conjunction with SQL or any other database technologies, including ADO.NET, ODBC, OleDB and others.  

 

SQL Statement Editor 

Our editor makes code editing easier and faster with Intellisense and code suggestions. 

 

Secure Data Gateway 

FrameworX provides a built-in firewall friendly data gateway that allows you to route data queries from clients in a secure way. That way, clients don't need to have direct access to the database. 

  

Learn more at Datasets and SQL Queries.


In this section...