Page History

HTML

<style>
.text-span-6 {
    background-image: linear-gradient(99deg, rgba(170, 163, 239, .5), rgba(125, 203, 207, .5));
    border-radius: 50px;
    padding-left: 15px;
    padding-right: 15px;
}

#title-text {
display: none;
}

.panelgradient {
    background-image: linear-gradient(180deg, #d5def0, whitesmoke);
    border-radius: 8px;
    flex-direction: column;
    justify-content: center;
    align-items: center;
    padding: 4rem;
    display: flex;
    position: relative;
}

</style>


<div class ="panelgradient">

<h1 style="text-align: center;">Datasets <br> (Databases and SQL Queries)</h1>

</div>

Introduction to the Datasets Module

Image Added

The Datasets Module is designed for data exchange with SQL databases and text files from a diverse set of sources. Essentially, the Datasets Module drives bi-directional real-time communication between all modules and the SQL databases.

This module offers compatibility with various database technologies, including ADO.NET, ODBC, OleDB, and native interfaces, providing straightforward configuration with prominent databases such as SQL Server, Oracle, SQLite, and PostgreSQL. Features include:

Multi-threaded concurrent connections with multiple databases for efficient data handling
SQL Query editor, SQLite admin tool, and a Visual Query Builder, streamlining the configuration experience
Customization of SQL statements in real-time with tags and system events

Image Added

On this page:

Table of Contents

maxLevel	3
minLevel	2
style	none

Key Concepts and Terms

DatasetDB

Connections settings created by the Dataset Module to communicate with an external database.

DatasetQuery

Logical name associated with the configuration for SQL query statements with a Database, and its properties and methods for running que queries.

DatasetTable

Logical name created to hold configuration settings to access specific tables in a connected database, mapping tags to table columns for operations.

DatasetFile

Logical name defining parameters for reading and writing files in ASCII, Unicode, or XML formats.

Understanding the Datasets Module

The Datasets Module enables users to interact with SQL databases seamlessly. The module supports real-time Tags within SQL statements, and manages files and recipes in ASCII, Unicode, or XML formats.

The data retrieved from databases can be utilized in various ways throughout your solution. For example:

In the Displays Module: Visualization tools like DataGrids can present query results on screens and dashboards, creating custom views of the data that are accessible and easy to understand for your users.
In the Scripting Module: Custom scripts can reference query results and trigger specific actions, such as sending notifications, updating tags, or performing calculations, thereby implementing complex logic based on database data.
Devices: Sending data from field equipments to a SQL database, or applying settings from the database to the field equipments.

Pre-defined Database Connections

The Dataset Module also serves as a data storage configuration hub for other modules. The following Database connections are pre-defined by the Dataset Module.

AlarmHistorian: Events and records for long-term retention.
TagHistorian: Time-series storage for process variables,
RuntimeUsers: Dynamics users and credentials created when running the solution.
Retentive: Persistent records for tags and properties that need to be kept across multiple starts of the solution (typically configuration settings and setpoints).

Processing Data Requests

The Datasets Module has its implementation running as a service, which ensures high performance and real-time responses to multiple client requests.

This architecture also enhances protection and security for the database, as client displays and scripts won't access the databases directly, but through the Datasets Service.

Another benefit is the ability for Data Source Virtualization, meaning that when the solution is using Dataset.Query.Query1 in its displays or scripts, the database running that query, along with the query itself, can be maintained or replaced without affecting the overall solution configuration. This feature allows the solution to work with the data, regardless of the underlying data storage technology.

For an advanced deeper understanding of the Datasets Services, see Dataset Advanced Topics.

Configuring the Datasets Module

Configuration Workflow

The typical configuration workflow for the Dataset module has the following sequence:

Datasets Module Configuration Workflow
Action	Where	Comments
Define database connections	Datasets→DBs	Gather connection details for your applications databases and created DB objects as need. Leverage the built-in SQLite admin tool for temporary development purposes
Prepare Queries	Datasets→Queries DataExplorer→SQL VisualQueryBuilder	Queries to craft queries using the built-in SQL Language Editor, the VisualQueryBuilder or using provided SQL statements from other sources. Fine-tune queries adding real-time parameters. Eg.: Transform "WHERE col1 = 5" to "WHERE col1 = {{tag.Test}}".
Map Database Tables	Datasets→Tables	Optionally, you can establish a direct mapping to tables within the Database.
Map Recipes and Text files	Datasets→ Files	Optionally, your solution may need to save or load recipes, or other information, from ASCII, Unicode, or XML files.

Managing DB Connections

There are four database connections pre-defined in any new solution.

Datasets DB - Pre-defined database connections
DB	Database	Path Location	Usage
Retentive	SQLite	<ProjectNameAndPath>.dbRetentive	Stores values for the Tags with the Retentive property set.
RuntimeUsers	SQLite	<ProjectNameAndPath>.dbRuntimeUsers	Stores dynamically created Solution SecurityUsers.
AlarmHistorian	SQLite	<ProjectNameAndPath>.dbAlarmHistorian	Stores Alarm and AuditTrail records.
TagHistorian	SQLite	<ProjectNameAndPath>.dbTagHistorian	Stores Tag Historian and Annotations.

When using SQLite databases, the Dataset Module can automatically create the database locally if it doesn't already exist. For other database types, the database itself must already exist before you set your connection.

→ Read more about Datasets DBs.

DatasetQueries Configuration

Use the DatasetQueries to define SQL Statements, for queries and stored procedures to execute in connection of the created DatasetDB databases.

→ Read more about Datasets Queries

DatasetTables Configuration

Use the DatasetTables to access or exchange data with databases tables, with simplified query syntax. It allows allow insert new rows directly on database tables.

→ Read more about Datasets Tables .

DatasetFiles Configuration

The DatasetFiles are used to customize file interactions in the Dataset Module. With this feature you can read or write realtime tags to ASCII, Unicode and XAML files.

→ Read more about Datasets Files .

Working with the Datasets Module

Runtime Execution

When executing the solution, there is an infrastructure of services that manages access to the database and transports that information to where it is requested. For instance, to display a Dataset Query result on an HTML5 page, that request first goes to the server, which then requests the database (which can be on another computer), and the information flows back to the requester.

As database operations can take some time to execute, it is very important to understand some aspects of the Datasets Module execution, including the concept of synchronous vs. asynchronous requests.

The page Datasets Module Execution details concepts that describe the module's internal operations.

Showing DataGrids Tables on Displays

One typical use of the Dataset Module is to display query results on displays and dashboards.

In order to so, create or DatasetQuery, or DatasetTable, then use the DataGrid Control on your displays.

Using Query Results on Scripts and Tags

It's possible to define the SQL statements with code (either using the Scripts Module or Display CodeBehind) and connect the results with tags early on.

The property Dataset.Query.Query1.SqlStatament holds the query that will be executed; just modify that property within your scripts.

The Tag Type DATATABLE was created to be compatible with results of Select() statements. SImply apply the results to your query and use tags no manage the information.

The TK (Toolkit extension for Scripts) has methods that allow for easy copying between DataTables (query results) and Template Tags, like TK.CopyTagToDataTable().

Monitoring Databases Connection Status

Monitoring Database Connections is an essential aspect of maintaining a reliable operation of the solution.

This can be accomplished using the Dataset Namespace properties, which provide status for DatasetTables and DatasetQueries operations.

During the Development phase, when the Designer tools is connected with a Runtime (the Solution is in execution), the main status conditions can be seen in the monitoring page.

→ Read more about Datasets Monitor

Datasets Advanced Topics

Datasets Module Execution

The Dataset module facilitates efficient database interactions by utilizing TServer services, managing synchronous and asynchronous executions for optimal performance.

Data Management

The Dataset Module offers versatile methods for managing data and concurrency within solutions, including Data Table tags and Async Contents.

→ Read more about Data Management .

Datasets Runtime Attributes

The Datasets Namespace exposes properties and methods from the .NET objects used by the Historian Module execution. You can use these properties and methods on your Displays or to create Scripts and Alarms.

Anchor
BestPractices
BestPractices
Best Practices and Troubleshooting

Common Issues and Solutions

Connection loss between project and database

Database Timeout Configuration: The database may have a timeout setting that automatically disconnects idle connections after a certain period. It's recommended to check the database's timeout setting and adjust it, if necessary, to ensure that the connection remains active overnight.

Power Settings: It's also suggested to check the computer's power settings to ensure that it doesn't enter sleep or hibernation mode during idle moments, which could cause a loss of connection to the database. Adjusting these settings to keep the computer active during these idle moments may resolve the issue.

Database Connection Problem

In the DB configuration, there is always a "Test" button to ensure that the connection is happening correctly. When there is a problem, the return of this button is an error message, usually returned by the database provider itself. The most common errors are: invalid user, invalid password, computer without access to the database, incorrect form of authentication.

Issue: Error accessing the Database Table

Once the connection is established, the Table configuration is specific to a table. In the "Table" combobox, the list of available tables automatically appears. It is possible, via script, to change which table will be accessed. However, care must be taken that the table exists and that the configuration is done using the correct name. The same care must be taken when Queries are used, as it is the user's responsibility to type the correct table name, as well as the syntax of the separators.

Error in the Syntax of the Query

It is the user's responsibility to type the correct SQLStatement of a query using the QueryBuilder. Table name, column, values, all can generate an error if used incorrectly. For example: comparing different types may not return the expected result, strings in general should be in single quotes. The separators and clauses available can vary between databases. For example:

SQLServer

Code Block

language	sql
title	Query syntax

SELECT TOP 10 * FROM table WHERE column = value

SQLite

Code Block

language	sql
title	Query syntax

SELECT * FROM table WHERE column = value LIMIT 10;

Oracle

Code Block

language	sql
title	Query syntax

SELECT * FROM table WHERE column = value AND ROWNUM <= 10;

or new Oracle version

Code Block

language	sql
title	Query syntax

SELECT * FROM table WHERE column = value FETCH FIRST 10 ROWS ONLY;

IBM DB2

Code Block

language	sql
title	Query syntax

SELECT * FROM table WHERE column = value FETCH FIRST 10 ROWS ONLY;

ServerIP without TWebServer Running on the Remote Machine

In some cases, the computer may not have access to the database. In this case, it is possible to create a gateway, routing the commands to be executed on the computer that has access to the database. The ServerIP field should be configured with the IP and port (<IP>:<port>), pointing to this computer that has access permission. This computer must have the software with the TWebServer running installed. It will automatically perform this gateway service and send the commands to the database.

DataTable Returned NULL

When a query is returned null, some error has occurred. Some common errors include: connection failure with the database, table not found, Dataset module is not running, incorrect query syntax. Check the return of the method using WithStatus when using a synchronous method or use the LastStatus and LastStatusMessage property when using asynchronous mode.

DataTable Returned with 0 Rows

When this happens, in general, there is a connection with the database and the table name is correct. In this case, the search condition is usually wrong, or the table is really empty. Check if the column names are correct and if the separators and clauses are valid.

Dataset Module is Down

Although the TServer is responsible for forwarding requests to the database, the management and communication with the TServer is done by the Dataset module, as well as the treatment of responses. Therefore, if you are having basic problems with access and execution of database access, the first thing to check is whether the module is set up to run and is actually running.

Very High Response Time

Sometimes, it may seem that access to the database is not being made, but what might actually be happening is that some accesses can return a very large amount of data, or the database may be overloaded, or with a bad configuration, causing it to have a low performance. Or even, the network itself can be overloaded and slow, and all these factors can impact the response time. In these cases, it is important to execute the Query directly in the database environment to be sure that the problem is not on the side of the database. Do this and check how long the database itself takes to execute the query. It is also worth checking the volume of data exchanged to have an idea of the related side effects.

Update of a table with the wrong schema (select before update)

The Dataset module uses ADO technology, and many things are resolved at the level of this API. When we are going to perform an Update on a table, the schema of the table and controls in the .NET DataTable type are used. Therefore, if you are going to perform an update passing a Tag or .NET DataTable object as a parameter, it is important that this object respects the schema of the destination Table in the database. Normally, a Select command must have been given at some point to obtain the correct schema used by the bank. After this, it is easy to add, remove, and modify values in this DataTable and update it back to the physical table in the database.

Where condition CaseSensitive

Case sensitivity in a WHERE clause depends on the database and the configuration of the database you are using. For example, in MySQL, queries are case-insensitive by default, which means 'abc' and 'ABC' would be considered equal. However, this can be changed with specific database settings. In SQL Server, case sensitivity is also determined by the database configuration. In PostgreSQL, queries are case-sensitive by default, so 'abc' and 'ABC' would be considered different. Therefore, it really depends on the specific database and the settings of that database. If you need to ensure case-insensitivity in a query, you can use functions like UPPER() or LOWER() to convert all values to upper or lower case before comparison. For example:

Code Block

language	sql
title	Query syntax

SELECT * FROM table WHERE LOWER(column) = LOWER(value);

This query will return records where the column matches the value, regardless of capitalization.

Performance

The Dataset module's performance depends on many factors, including database performance, network latency, and the complexity of executing SQL queries. The platform will minimize overhead and execute queries as efficiently as possible. However, ultimately, the performance of the Dataset module is tied to these external factors. It's essential to design your database schema and queries with performance in mind and consider investing in high-quality hardware and network infrastructure to ensure optimal performance.

Best Practices and Recommendations

Error Handling

Error handling in the Dataset module is straightforward. If an error occurs during the execution of a command, the error message will update the module's Error property (Last Status). You can monitor this property to handle errors in your application. Furthermore, if an error occurs during the execution of a synchronous method, the process will return an empty DataTable and update the Error property. Alternatively, you can call methods like SelectCommandWithStatus, where the status will be an output parameter in the method.

In this section:

About the Dataset Module

The Dataset Module is a powerful tool for collecting, analyzing, and visualizing data within the platform. With the Dataset Module, users can easily connect to a variety of data sources, including databases, CSV files, and other external sources, and use SQL queries to extract, manipulate, and transform data. The module also provides a range of features for managing and organizing data, such as Access Types, which allow users to group and categorize data points based on their usage and permissions. In this section, we will explore the key concepts, terminology, and functionality of the Dataset Module, as well as best practices and troubleshooting tips for using this powerful tool to its fullest potential.

The Dataset Module enables connecting to an existing external database. Different providers can be used — such as SQL Server, Oracle, SQLite, PostgreSQL, and others —, and can be simply and quickly configured.

Image Removed Image RemovedImage RemovedImage Removed

This module has many features specifically created for real-time applications.

Allows concurrent connections, using multi-threading, with many data sources.
Supports various database technologies, including ADO.NET, ODBC, OleDB, and native interfaces with key Databases in the market.
Built-in editor for SQLite. Easily create SQLite databases using macros like <ProjectName>-Test.db.
Visual Query Builder to create and edit queries.
Easily adds real-time tags embedded in the query strings.
Manages file and recipes in ASCII, Unicode or XML files.
Built-in Networking Gateway feature, allows to safely cross security zones.
Virtualizes the names for queries and tables, creating application that are agnostic to the storage location.

On this page:

Table of Contents

maxLevel	3

Key Concepts and Terminology

Dataset DBs

To each external database the Module Database will communicate, a connection needs to be created with certain parameters. Each connection, created on Datasets → DBs is called in this Module as Dataset DB.

Dataset Queries

In the context of this module, when we refer to a Dataset Query, we mean not only the SQL query string, but the Project object that has a logical name, the SQL query related to that logical name, and other parameters as defined on Datasets → Queries. There are many ways to automatically map the result of query execution with Tags.

Dataset Tables

Similar to the queries, a Dataset Table refers to a logical name, created in the project, to setup the access to a specific Table in a connected database. The tables in use are listed on Datasets → Tables. The Tags in the real-time database can easily be mapped to columns in the tables to insert, update or read operations.

Dataset Files

A Dataset File is a logical name that defines parameter to read and write from files in ASCII, Unicode or XML formats.

Access Types

Access Types provide a powerful tool for managing and controlling access to data within the Dataset Module, and can be used to enforce security policies and ensure that data is accessed only by authorized users.

Access Types are associated with Dataset Tables, Queries, and Files, and can be used to define access permissions for these data sources. For example, you might create an Access Type for "Administrators" that allows them to view and modify all data points, while restricting access for "Operators" to a specific subset of data points.

When defining Access Types, users can choose from a range of permissions, including "Read", "Write", "Read/Write", and "None". These permissions can be applied at the column level, allowing users to restrict access to specific columns within a Dataset Table.

How the Device Module Works

The Device Module is a core component of the platform, responsible for managing and communicating with external devices and data sources. The Device Module works closely with other modules, such as the Dataset Module, to collect, analyze, and visualize data within the platform.

At a high level, the Device Module works by establishing connections with external devices and data sources, and managing the flow of data between these sources and the platform. This involves setting up communication protocols, such as OPC-UA or Modbus, configuring device parameters, and managing data transmission and synchronization.

Once data is collected by the Device Module, it can be passed on to other modules for processing and visualization. For example, data might be stored in a Dataset Table for further analysis, or displayed on a custom dashboard or visualization tool.

The Device Module also provides a range of features for managing and configuring devices, such as managing device drivers, configuring data acquisition rates, and setting up alarms and notifications based on device events or data thresholds.

Overall, the Device Module is a critical component of the FactoryStudio platform, responsible for integrating and communicating with a wide range of external devices and data sources. By providing a flexible and powerful framework for managing device data, the Device Module enables users to collect, analyze, and visualize data in real-time, and make informed decisions based on actionable insights.

Features Highlights

SQL Query Support: The Dataset Module provides support for SQL queries, allowing users to easily extract, manipulate, and transform data from a variety of sources.
Integration with External Data Sources: The Dataset Module can integrate with a wide range of external data sources, including databases, CSV files, and other external sources, providing a flexible and powerful tool for data collection and analysis.
Access Types: Access Types allow users to group and organize data points based on their usage and permissions, providing a powerful tool for managing and controlling access to data within the Dataset Module.
Visual Query Editor: The Visual Query Editor provides a user-friendly interface for creating and editing SQL queries, making it easy for users to define complex queries without needing extensive SQL knowledge.
Customizable Dashboards: The Dataset Module provides the ability to create custom dashboards and visualizations based on the data collected by the module, allowing users to easily view and analyze data in real-time.
Store Procedures Execution: The Dataset Module can execute Store Procedures and return the results to the platform, allowing users to perform advanced data manipulation and analysis within the context of the platform.
Real-Time Execution: The Dataset Module supports real-time execution of SQL queries, allowing users to monitor and analyze data as it is generated in real-time.

Managing Channels and Nodes

Organizing the Points with Access Types

Handling Read and Write Events

Configuring the Dataset Module

Configuration Workflow

The typical configuration workflow for the Dataset Module has the following sequence:

Dataset Module Configuration Workflow

Action

Where

Comments

Create the required database connections (DBs)

Datasets → DBs

Collect the information to connect with the databases required to your Project. Use the built-in SQLite database as a temporary development tool if one of your connected database is not available yet.

The virtualization model with logical names for queries and tables will make your project work directly with the new connection with the production database, without having to change anything on the Project Configuration other than that database connection,

Prepare the Queries the Project uses

Datasets → Queries

Either using the Visual Query Editor, or getting the query string from IT or plant facilitator, collect and create the logical names Dataset.Query to identify those queries.

Modify the Query to add real-time tags

Datasets → Queries

Easily modify the query with the parameters that need be connected with real-time values. For instance, a query that has the text. WHERE col1 = 5 can be modified to WHERE col1 = {{tag.Test}}. The value of the Tag will be added to proper position when the query is executed.

Prepare the Tables the Project uses

Datasets → Tables

When you need to Insert or Modify data, you need to access the Database Table directly. In some cases, all the information you need is one table, so there is no needing to create a Query. You can easily connect the contents what are inserted in the table with Tags in the Project.

Configure the Stored Procedures

Datasets → Queries

The Module Database can execute Stored Procedures; just define it using the same interface for the queries.

Configure data exchange with Files

Datasets → Files

If necessary to exchange values of Tags with plain text or XML files, set that configuration.

Use your Dataset logical objects

All Project

The logical object names created for Queries, Tables and Files can be used in any part of the project. Examples: Script calculation, Display visualization, and others

Creating DB Connections

When using SQLite databases, the Module Dataset can automatically create the Database if necessary; for other ones, the Database itself must already exist before you set your connection.

Users with any Permission groups can create new connections in the Project, but only the Administrator can configure databases password logins.

Info
See Security, Users and Roles for information on Project permissions.

To create a new Database connection:

Go to Datasets → DBs.
Click Create New. The Create New Database Connection window displays.
Enter or select information, as needed.
Click OK. The database is added as a new row in the table.
Edit the row fields to modify the required settings.

Dataset DB Configuration Properties

Column

Description

Name

Enter a name for the database configuration. The system allows you to know if the name is not valid.

Provider

Identifies the Provider technology used in this connection

Database

Identifies to which type of dataset is this connection

ConnectionString

Enter the information needed to connect with the database. You use macros on the connection string.

Example: for the filename in a SQLite connection string, use <ProjectName> that is replaced by the name of the project.

LogonName

Enter a valid login name for the database.

LogonPassword

Enter the password that corresponds to the database login. (Only accessible by Administrators)

ServerIP

Optionally, an IP or DNS name for a computer to be used as a Secure Gateway.

Description

Enter a description for the database connection.

Customizing Pre-defined Databases

There are four database connection already created in any new Project:

Datasets DB - Pre-defined database connections

DB

Database

Path Location

Usage

Retentive

SQLite

<ProjectNameAndPath>.dbRetentive

Stores values for Retentive Tags.

RuntimeUsers

SQLite

<ProjectNameAndPath>.dbRuntimeUsers

Stores dynamically created Users.

AlarmHistorian

SQLite

<ProjectNameAndPath>.dbAlarmHistorian

Stores Alarm and AuditTrail records.

TagHistorian

SQLite

<ProjectNameAndPath>.dbTagHistorian

Stores Tag Historian and Annotations.

Any of them can be customized to any type of database.

The selection of best storage location depends on all kind of factors, from internal company procedures to the volume of data and how the data shall be used. Therefore, that is decision to each Project according to its requirements.

If needed to use another database for the pre-defined connections, execute the following steps:

Rename or Delete the previous DB. This step is necessary, as the system would not allow to create two objects with the same name.
Crate a new DB with the same name of the previous DB, with the required Database and connection strings.
That is all!

ConnectionString example for SQL Express

Image Removed

Data Source: The server path and instance that will have the databases.
Initial Catalog: The name of the database that will be used.

Additional Settings for Tag Historian and AlarmHistorian

Store and Forward: Enabling this option will cause the system to store the data locally if communication with the database is lost, and forward the data to synchronize once the connection is back again.

Info
For more configuration about Store and Forward, check the section Archiving Process at Historian, Time Series Data.

Datasets Queries Configuration

You can configure queries to perform more advanced functions with SQL statements to work with data from external databases.

To configure Dataset queries:

Go to Datasets → Queries.
Enter the field values as needed.

Dataset Query Configuration Properties

Column

Description

Name

Enter a name for the query. The system allows you to know if the name is not valid.

DB

Select the database configuration.

SqlStatement

Enter the query using SQL syntax.

Mapping

Click "..." to select the tags that you want to populate with data from specific columns returned by the query.

MappingDateTime

Select the time reference (UTC or Local).

Description

Enter a description for the table configuration.

Datasets Tables Configuration

To configure database tables:

Go to Datasets → Tables.
Enter the field values as needed.

Dataset Table Configuration Properties

Field / Column

Description

Name

Enter a name for the table configuration. The system lets you know if the name is not valid.

DB

Select the database connecton.

TableName

Select or type the table name in the Database you want to access

WhereCondition

Specify the parameters that will filter the data using SQL syntax. E.g. "ColumnName = {tag.tagInt}"

Access

Select the access permissions for the table.

Mapping

Click "..." to select the tags that you want to populate with data in the first row of the table with data from specific columns.

MappingDateTime

Select the time reference (UTC or Local).

Description

Enter a description for the table configuration.

Datasets Files Configuration

To configure dataset files:

Go to Datasets → Files.
Enter the field values as needed.

Dataset File Configuration Properties

Column

Description

Name

Enter a name for the file configuration. The system allows you to know if the name is not valid.

FileName

Enter the full path to the file. The file path can have Tag values embedded using curly brackets syntax. E.g.: ExampleFile{{tag.Test}}.txt.

When executing, the area in curly brackets is replaced by the value of the Tag.

FileType

Select the type of file.

Objects

Click "..." to select the tags that you want to populate with data from the file with data from specific columns.

Description

Enter a description for the file configuration.

XMLSchemaType

Represents the schema type of an XML file, which can be: a TagList, XML that contains a tag list with the tag name and tag value; or a TagObject, XML that contains the entire tag tree and its children.

Using the Visual Query Editor

With the Visual Query Editor, users can drag and drop tables, define relationships, and add filters and conditions using a simple graphical interface. Once the query is created, it can be saved and executed like any other query within the Dataset Module. Check the Visual SQL Query Builder page for complete information.

Working with the Dataset Module

Runtime Execution

Integration with Other Modules

DataGrids on Displays

Using Query Results on Scripts and Tags

Starting the Execution of Store Procedures

Advanced Features and Options

Troubleshooting and Best Practices

Common Issues and Solutions

Best Practices and Recommendations

Dataset Module Runtime Attributes

In this section...

Page Tree

root	@self
spaces	V10

...

Space shortcuts

Page tree

Page History

Versions Compared

Old Version 8

New Version Current

Key

Introduction to the Datasets Module

Image Added

Key Concepts and Terms

DatasetDB

DatasetQuery

DatasetTable

DatasetFile

Understanding the Datasets Module

Pre-defined Database Connections

Processing Data Requests

Configuring the Datasets Module

Configuration Workflow

Managing DB Connections

DatasetQueries Configuration

DatasetTables Configuration

DatasetFiles Configuration

Working with the Datasets Module

Runtime Execution

Showing DataGrids Tables on Displays

Using Query Results on Scripts and Tags

Monitoring Databases Connection Status

Datasets Advanced Topics

Datasets Module Execution

Data Management

Datasets Runtime Attributes

Preventing SQL Injections

Network Gateway Access And Time Zone Handling

Backup Of Solutions SQLite Data Bases

AnchorBestPracticesBestPracticesBest Practices and Troubleshooting

Common Issues and Solutions

Connection loss between project and database

Database Connection Problem

Issue: Error accessing the Database Table

Error in the Syntax of the Query

ServerIP without TWebServer Running on the Remote Machine

DataTable Returned NULL

DataTable Returned with 0 Rows

Dataset Module is Down

Very High Response Time

Update of a table with the wrong schema (select before update)

Where condition CaseSensitive

Performance

Best Practices and Recommendations

Error Handling

About the Dataset Module

Key Concepts and Terminology

Dataset DBs

Dataset Queries

Dataset Tables

Dataset Files

Access Types

How the Device Module Works

Features Highlights

Managing Channels and Nodes

Organizing the Points with Access Types

Handling Read and Write Events

Configuring the Dataset Module

Configuration Workflow

Creating DB Connections

Customizing Pre-defined Databases

ConnectionString example for SQL Express

Additional Settings for Tag Historian and AlarmHistorian

Datasets Queries Configuration

Datasets Tables Configuration

Datasets Files Configuration

Using the Visual Query Editor

Working with the Dataset Module

Runtime Execution

Integration with Other Modules

DataGrids on Displays

Using Query Results on Scripts and Tags

Starting the Execution of Store Procedures

Advanced Features and Options

Anchor
BestPractices
BestPractices
Best Practices and Troubleshooting