# TSA SQL Server Connector

The TSA SQL Server Connector allows you to connect to a remote [SQL Server](https://docs.microsoft.com/en-us/sql/sql-server/?view=sql-server-ver15) database and retrieve data as requested by the application.

You can use this in your application to provide data to the [Time Series Analysis](https://documentation.xmpro.com/blocks-toolbox/visualizations/time-series-analysis) block. \
\
The advantage of this Connector over the standard [SQL Server Connector](https://xmpro.gitbook.io/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. 

## Pre-requisites

* 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+

<table><thead><tr><th>Connector Version</th><th data-type="checkbox">AD v4.2.3 - 4.4.11</th><th data-type="checkbox">AD v4.4.12+</th></tr></thead><tbody><tr><td>v2.00+</td><td>false</td><td>true</td></tr><tr><td>Pre v2.00</td><td>true</td><td>true</td></tr></tbody></table>

## Current Version

* [Download](https://xmappstore.blob.core.windows.net/tier5/Connector_TSA%20SQL%20Server_v2.20.xmp) the TSA SQL Connector v2.20
* [Download](https://xmappstore.blob.core.windows.net/tier5/Connector_TSC%20SQL%20Server_v1.61.xmp) the *deprecated* TSC SQL Connector v1.61

Please [contact](mailto:support@xmpro.com?subject=tsa-sql-server-connector-older-version) XMPro if you're looking for an older version of this Connector.

## TSA Release Notes

<table><thead><tr><th width="104">Version</th><th width="148">Date</th><th>Description</th></tr></thead><tbody><tr><td>v2.20</td><td>30 Jun 2025</td><td>Repackaged to remove the System.Data.SqlClient library library, to instead be served by App Designer.
<br>Ensured all SqlClient and HttpClient references are disposed.
<br>Refactored for code cleanliness and reuse.</td></tr><tr><td>v2.01</td><td>08 Jan 2025</td><td>Repackaged to translate the Connector's properties.<br><mark style="color:red;"><strong>NOTE</strong>: Performance concerns. <strong>Use v2.20+ instead.</strong></mark></td></tr><tr><td>v2.00</td><td>10 Sep 2024</td><td><p>Implemented the new <a href="https://documentation.xmpro.com/how-tos/connectors/building-connectors#overview">ITSAConnector</a> interface to enable improved integration with <a href="https://documentation.xmpro.com/blocks-toolbox/visualizations/time-series-analysis">Time Series Analysis</a> block.</p><p>Renamed from "TSC SQL Server" to "TSA SQL Server" to align with the renaming of the block.<br><mark style="color:red;"><strong>NOTE</strong>: Performance concerns. <strong>Use v2.20+ instead.</strong></mark></p></td></tr></tbody></table>

## TSC Release Notes (deprecated)

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.&#x20;

<table><thead><tr><th width="104">Version</th><th width="148">Date</th><th>Description</th></tr></thead><tbody><tr><td>v1.61</td><td>08 Jan 2025</td><td>Repackaged to translate the Connector's properties.</td></tr><tr><td>v1.60</td><td>10 Sep 2024</td><td>Updated System.Data.SqlClient from v4.7.0 to v4.8.6 for the <a href="https://msrc.microsoft.com/update-guide/vulnerability/CVE-2024-0056">CVE-2024-0056 </a>security update, and included the DLL in the package as a dependency.</td></tr><tr><td>v1.5</td><td>22 Aug 2024</td><td>Removed query support as this doesn't apply to time series aggregation.</td></tr><tr><td>v1.4</td><td>26 Jul 2023</td><td>Support stored procedures.</td></tr><tr><td>v1.3</td><td>28 Jun 2023</td><td>Initial Release.</td></tr></tbody></table>