The SQL Database TagProvider bridges software environments and SQL databases, enabling data retrieval, visualization, and manipulation directly from applicationsExternal TagProvider connects to solution databases at runtime, enabling data querying without local Tags. Configure this External TagProvider to access SQL database datadisplay queried data on TrendCharts and other application areas, enhancing data-driven decision-making and operational processes real-time access and utilization of database information within the Unified Namespace.
On this page:
| Table of Contents | ||||
|---|---|---|---|---|
|
Configuration
To set up SQL Database as an External Tags source, navigate to Unified Namespaces / External TagProviders and select the SQL Database Connector.
Connection parameters
Field | Description |
|---|---|
Provider | Specifies the system the TagProvider will interface with. In this case, it interfaces with the SQL Database Connector. |
Access Mode | Determines permissions for interacting with tags. Read allows data reading. |
Name | User-defined name for the TagProvider instance. Identifies the specific configuration in the system. |
Description | Explains the TagProvider's purpose or the systems it interfaces with. Provides context for its usage. |
ProtocolOptions | Defines specific communication settings for the connection to the device. True or False. |
Connection | Defines connection string for the SQL database connection settings, including database source, path, and additional parameters. |
Field | Description |
|---|---|
Dataset DBs | Specifies the database to be used for storing and retrieving tag data. |
Is Solution Historian DB | Indicates if the database is used as a solution historian. |
Is Trend XY | Specifies if the data is to be treated as XY trend data. |
Table | Defines the table within the database to retrieve or store data from. |
X-Axis ColumnName | Specifies the column name to be used for the X-axis in trend data. |
Columns To Discard | Lists columns to be excluded from the data retrieval process. |
Filters | Specifies filters to be applied to the data retrieval process. |
Test | Verifies the connection settings to ensure successful communication with the specified database. |
In this section:
| Page Tree | ||||
|---|---|---|---|---|
|