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.
Visual Query Builder
Our Visual SQL Query Builder enables you to preview, connect, build, and test your SQL queries with a visual interface before incorporating them into your project. That includes selecting databases, tables, and columns for easy navigation and understanding and create relationships (joins) between entities using a visual approach.
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...