Introduction
FrameworX 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 functionalities also support 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. This enables users to configure data acquisition intervals, thresholds, and alarms, to ensure data accuracy and consistency.
On this page:
Key Functionalities
Features Highlights
- SQL Query Support: Enables efficient data extraction, manipulation, and transformation from a diverse set of sources.
- Integration with External Data Sources: Provides seamless data collection and analysis from a wide range of external sources, including SQL databases and CSV files.
- Visual Query Editor: Facilitates the creation and editing of advanced SQL queries, eliminating the need for extensive SQL knowledge.
- Distributed Architecture: Supports concurrent requests and offers flexibility in processing data either on the client or server side.
- Stored Procedures Execution: Encourages advanced data manipulation and analysis within the platform.
- Real-Time Execution: Enables execution of SQL queries with real-time data, offering customization of parameters and timely analysis of generated data.
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...