About the Datasets Module
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.
Moreover, the datasets module includes various data analysis and visualization tools, such as charts, graphs, and reports, that enable users to analyze and visualize the data effectively. It provides real-time data analysis and trending features, allowing users to monitor system performance and identify issues proactively.
On this page:
Real-time Queries and Tables
Any data source that supports ODBC, OLE-DB, or ADO.NET can be connected with the application. An easy syntax allows creating or customizing any query or table search with real-time tags.
Client-Server Architecture
It is possible to process real-time queries either from the server or from the client computer, asynchronously or synchronously. In order to achieve an improved performance, multiple requests from distributed clients are cached and synchronized in the server.
Multiple Database Connections
The platform provides seamless integration with any third-party database, including Microsoft SQL Server, Oracle, MySQL, Informix, SQL Lite, PostgreSQL, and others.
Data Gateway
Connecting client queries through Firewall-protected security zones, such as moving data between the Automation Network and the IT network, is no longer an issue. FactoryStudio provides a built-in firewall-friendly data gateway. Data queries from clients are securely routed through any platform's system.
Advanced DataGrid
Our platform provides a fully-featured DataGrid object that presents tables and queries from databases, as well as shows the contents of any tag, asset, or real-time objects. Drop the table, query, or tag in the Grid Data Source to create front-end visualization, edit any real-time object, or edit any database.
| Scheduling and processing recipes and real-time data consolidation is made easy. |
Learn more at Datasets and SQL Queries. |