TSA SQL Server Connector
Last updated
Last updated
The TSA SQL Server Connector allows you to connect to a remote SQL Server database and retrieve data as requested by the application.
You can use this in your application to provide data to the Time Series Analysis block. The advantage of this Connector over the standard SQL Server Connector 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+
| Connector Version | AD v4.2.3 - 4.4.11 | AD v4.4.12+ |
|---|---|---|
Please contact XMPro if you're looking for an older version of this Connector.
| Version | Date | Description |
|---|---|---|
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.
| Version | Date | Description |
|---|---|---|
v2.00+
Pre v2.00
v2.00
10 Sep 2024
Implemented the new ITSAConnector interface to enable improved integration with Time Series Analysis block.
Renamed from "TSC SQL Server" to "TSA SQL Server" to align with the renaming of the block.
v1.60
10 Sep 2024
Updated System.Data.SqlClient from v4.7.0 to v4.8.6 for the CVE-2024-0056 security update, and included the DLL in the package as a dependency.
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.