Overview
The SQLDatabase Connector TagProvider implements a bridge between your software environment and SQL databases. It allows for streamlined data retrieval, visualization, and manipulation right from your application.
On this page:
| Table of Contents | ||||
|---|---|---|---|---|
|
Configuration
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.
Filters: Set specific conditions to refine the data that's fetched from the database. Filters can be instrumental in accessing subsets of data, leading to more focused and efficient analyses.
In this section:
| Page Tree | ||||
|---|---|---|---|---|
|