Introduction
The module provides a variety of features that enable users to define and manage datasets based on different parameters, including Our platform offers a range of features for defining and handling datasets, tailored to different parameters like process variables, time intervals, and data sources. It allows users to collect Users can gather 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 These functionalities cover various data types - real-time data, historical data, and aggregate data, providing - giving users with a comprehensive holistic view of the system performance and behavior. It enables users to configure . Users can set data acquisition intervals, thresholds, and alarms , to ensure maintain data accuracy and consistency.
On this page:
| Table of Contents | ||
|---|---|---|
|
Key Functionalities
Features Highlights
- SQL Query Support: Effortlessly extract, manipulate, and transform data from diverse sources using efficient SQL queries.
- Integration with External Data Sources: Seamlessly collect and analyze data from various external sources like SQL databases and CSV files.
- Visual Query Editor: Easily create and edit advanced SQL queries without needing extensive SQL knowledge, simplifying the process.
- Distributed Architecture: Supports simultaneous requests and provides flexibility in processing data on either the client or server side.
- Stored Procedures Execution: Allows for advanced data manipulation and analysis directly within the platform.
- Real-Time Execution: Execute SQL queries with real-time data, enabling parameter customization and timely analysis of generated data.
Built-in Embedded SQL
Every FrameworX system includes, at no extra cost, a full-featured system comes with a fully functional embedded SQL Lite database at no additional cost, with requiring no required configurationsetup. This provides offers several advantages includingbenefits:
- Secure Project Configuration: It serves as a secure repository A safe and secure location for your entire project configuration.
- It can be used as the historian database to log Historian Database: Suitable for small to medium systems, it can function as a historian database for logging tags, alarms, and events on small to medium systems (up to 10GB of data).
- On Large Store and Forward: For large systems, it can be used serves as a local Store and Forward location, - stepping in when the remote database is not availableunavailable.
- It provides Storage for Local Data: It's an ideal system to store for storing local runtime settings, retentive information, local recipes, schedules and , tables, and queries when preparing reports.
- needed for report preparation.
Multiple Database Connections Connections
Our projects allow you to have support multiple databases, working in conjunction seamlessly integrating with SQL or any and other database technologies , including such as 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
, and more.
SQL Statement Editor
Our editor enhances code editing by offering Intellisense and helpful code suggestions, making the process faster and more efficient.
Secure Data Gateway
Our platform offers a built-in data gateway that's firewall-friendly, ensuring secure data query routing from clients without requiring 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.
| Info |
|---|
Learn more at Datasets and (SQL Queries). |
In this section...
| Page Tree | ||||
|---|---|---|---|---|
|