Dataset DBs (Reference)

Dataset DBs (Reference) define database connections for data storage, retrieval, and manipulation within the FrameworX platform. It provides:

  • SQL database connectivity
  • Pre-configured system databases

Datasets Queries (Reference)

Overview

The Dataset Module offers powerful configuration options for managing queries efficiently. Users can define queries with custom names, select database configurations, and input SQL statements, including Tag embedding. Mapping options enable data population from query results, and users can specify time references (UTC or Local) for Date Time fields.

Query Editor (Reference)

Overview

The Query Editor allow the user to write scripts in SQL.

On this page:

Datasets Tables (Reference)

Overview

The Dataset Tables section in the Dataset Module simplifies data table management. Customize structure, relationships, and data types through an intuitive interface that streamlines data handling and promotes efficient data management.

On this page:

Datasets Files (Reference)

Overview

The DatasetFile configuration and properties in the Dataset module allows you to manage and customize configurations to read and write text files containing values of Tags. Those files can be used as recipes, or configuration settings to the solution, or to exchange data with other applications.  

Datasets Monitor (Reference)

Overview

When the solution is running, and the Designer is connected with the runtime, the Datasets Monitor page show basic status server access to tables and queries.

On this page:

  • No labels