The SQL Database TagProvider bridges software environments and SQL databases, enabling data retrieval, visualization, and manipulation directly from applications. Configure this TagProvider to access SQL database data, enhancing data-driven decision-making and operational processes 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 |
Initiate the configuration process by navigating to Unified Namespace → ExternalTags Source and selecting SQLDatabase Connector.
Syntax :
DatasetDB: This drop-down allows you to select the desired database from your project, ensuring that the connector targets the correct data source.
InSolution HistorianDB: Checking this option will prioritize the database designed for historian functionalities within the solution. This is useful for time-series data and historical data analysis.
IsTrendXY: Enabling this checkbox indicates that the data you're accessing will be used for trend visualizations with X and Y axis representations. This aids in correctly formatting the retrieved data for graphical displays.
Table: Specify the exact table from your database you wish to connect to. This ensures data retrieval is accurate and relevant.
X-Axis ColumnName: For trend visualizations, define the column in your database table that will represent the X-axis. This is typically time or date in most applications but can be any linearly incremental data.
Columns to Discard: If there are columns in your table that you wish to exclude during data retrieval, specify them here. This can declutter your data views and streamline data processing.
. |
In this section:
| Page Tree | ||||
|---|---|---|---|---|
|