Introduction
FrameworX 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 These functionalities also support cover various data types of data, such as - real-time data, historical data, and aggregate data, providing - giving users with a comprehensive holistic view of the system performance and behavior. This 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
- for your entire project configuration.
- Historian Database: Suitable for small to medium systems, it can function as a historian database for logging tags, alarms, and events
- (up to 10GB of data).
- Store and Forward: For large systems, it
- serves as a local Store and Forward location, - stepping in when the remote database is
- unavailable.
- Storage for Local Data: It's an ideal system
- for storing local runtime settings, retentive information, local recipes, schedules
- , tables, and queries
- needed for report preparation.
Multiple Database Connections
Multiple Database 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 othersmore.
SQL Statement Editor
Our editor makes enhances code editing easier and faster with by offering Intellisense and helpful code suggestions.
, making the process faster and more efficient.
Secure Data Gateway
FrameworX provides Our platform offers 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 's firewall-friendly, ensuring secure data query routing from clients without requiring direct access to the database.
| Info |
|---|
Learn more at Datasets and (SQL Queries). |
In this section...
| Page Tree | ||||
|---|---|---|---|---|
|