TSA SQL Server Connector
Last updated
Last updated
The TSA SQL Server Connector allows you to connect to a remote database and retrieve data as requested by the application.
You can use this in your application to provide data to the block. The advantage of this Connector over the standard is that it is optimized for server-side processing of the required grouping into buckets needed for the Time Series Analysis data points. This reduces the response time and size, enabling quicker retrieval of data for longer periods.
SQL Server database credentials are required to use this Connector.
The minimum XMPro App Designer version required is as follows:
v2.00+ requires XMPro App Designer v4.4.12+
Pre v2.00 requires XMPro App Designer v4.2.3+
v2.00+
Pre v2.00
the TSA SQL Connector v2.01
the deprecated TSC SQL Connector v1.61
Please XMPro if you're looking for an older version of this Connector.
v2.01
08 Jan 2025
Repackaged to translate the Connector's properties.
v2.00
10 Sep 2024
Renamed from "TSC SQL Server" to "TSA SQL Server" to align with the renaming of the block.
The TSC SQL Server Connector was replaced by the TSA SQL Server Connector in September 2024 because it uses a deprecated Microsoft library and the deprecated ITSCConnector interface.
v1.61
08 Jan 2025
Repackaged to translate the Connector's properties.
v1.60
10 Sep 2024
v1.5
22 Aug 2024
Removed query support as this doesn't apply to time series aggregation.
v1.4
26 Jul 2023
Support stored procedures.
v1.3
28 Jun 2023
Initial Release.
Implemented the new interface to enable improved integration with block.
Updated System.Data.SqlClient from v4.7.0 to v4.8.6 for the security update, and included the DLL in the package as a dependency.