Key Concepts and Terms

DataExplorer Tools

MQTT: Run the built-in broker or the publisher simulator. Browse data from any broker.

OPC-UA: Run the built-in server or simulator. Browse data from local or remote servers.

ControlLogix PLCs: Discover ControlLogix PLCs in your network and connect to browse their data structures.

SQL Queries: Explore SQL databases and build new queries visually.

Connection Target

The connection target configuration sets up the location of the data source to be used. Typically, you can select from three types of locations:

1. Local Project: This option connects automatically to some data connections defined in the Project configuration.
2. ExternalTags: This option connects with ExternalTags, which are dynamic data sources created in the Project configuration.
3. Remote: This option allows you to connect with a remote source, not necessarily used by the Project.

Connection Status

To browse data, the first step is to connect with the data source. After the connection is established, the DataBrowser tree will regularly update with data from the sources.

Note: For SQL queries, the DataGrid results view will only update after you execute a query, but the connection is established automatically.

Data Browser Window

For field devices (MQTT, OPC-UA, PLCs), after the connection is established, a hierarchical tree with the data structure and values is displayed. For SQL queries, the results are shown in a DataGrid.

Export Settings to the Project

When connecting with a remote data source not used by the Project, there are options to incorporate that data source into your application with one click. For SQL queries, you can export your customization of DataGrid columns to be used in operator displays.

Understanding the Data Explorer Tools

Overview

The Data Explorer tools are typically used in the following phases of project development:

1. Data Discovery: Whether using MQTT, OPC-UA, ControlLogix PLCs, or SQL Databases, the Data Explorer tools provide a user-friendly and easy way to verify the consistency of the data you intend to work with.
2. Templates and Tags Definition: Data templates, local tags, and tag providers can be easily created in the project configuration using the data displayed in the Data Browser window.
3. Testing and Validation: When used in conjunction with connections already defined in the project configuration, these tools can be used to validate and monitor the results of data acquisition.

Typical Workflow

1. Start Servers or Simulators: When using MQTT or OPC, you have the option to use the built-in OPC-UA server, the local MQTT broker, or run data simulators.
2. Select the Option for Connection Target: Select the connection, either from the project or remote sources. For ControlLogix PLCs, you can also search for devices in the network automatically.
3. Browse the Data Structure and Values: View the values in the TreeView explorer (for OPC, MQTT, and PLCs) or in the DataGrid (for SQL queries).
4. Add Connections, Data Templates, or Points to the Unified Namespace: Export server connections, data structures, or specific topics to be used by the application.

Configuring Data Explorer Tools

Configuring the MQTT Explorer

Content

Configuring the OPC-UA Explorer

Content

Configuring the SQL Query Builder

Content

Add reference to a Child Page about the Visual Query Editor

Working with the Data Explorer Tools

Data Acquisition Execution

Each data source has its own procedure to execute data acquisition.

Getting Data from the MQTT Broker

With MQTT, the Data Browser will act as a client application to the broker, subscribing to the data visible on the user interface.

Getting Data from the OPC-UA Server

With OPC-UA, the Data Browser will act as a client application to the OPC server, reading the data visible on the user interface by polling every second.

Getting Data from SQL Databases

With SQL, the DataGrid is only updated when the Execute Query command is executed.

Performance Considerations

As this is only a data explorer interface, the default update cycle is one second. However, this does not reflect the performance you will have at runtime, which can be much higher depending on your configuration.

For all field protocols (MQTT, OPC-UA, PLC native protocols), you can define parallel requests, subscribe instead of poll (if the protocol allows), and use the AccessType concept to group your data according to its priority, usage in the application, or process requirements. The volume of data and performance the project can manage at runtime is significantly higher than those of the Data Explorer tools.

Troubleshooting and Best Practices

Troubleshooting and Common #Issues

The Historian module may encounter some issues in its operation. Here are some common issues and their troubleshooting:

#Issue

Solution

Best Practices and #Recommendations

To ensure the smooth operation of the Historian module, follow these best practices:

#Best practice

Recommendations

In this section: