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:
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: