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.
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:
| Table of Contents | ||
|---|---|---|
|
Key Functionalities
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.
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.
| Tip |
|---|
| Info |
Learn more at Datasets and SQL Queries. |
In this section...
| Page Tree | ||||
|---|---|---|---|---|
|