Overview
The SQLDatabase Connector provides 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:
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.