Azure SQL
Last updated
Last updated
The Azure SQL Agents allow you to include data from an Azure SQL database table into your stream.
The Listener allows you to return new rows added to a table. It operates on a timed interval and returns all new rows added to the table since the last interval.
The Context Provider allows you to read and output the entire contents of a table to the Data Stream for contextual data.
The Action Agent allows you to insert or update rows in a table, execute a stored procedure, or run a dynamic SELECT query. You can configure whether the destination table should be created before writing to it.
The minimum XMPro Stream Host (SH) version required for these Agents v5.00 or later is 4.3.7, i.e. download the SH installer from XMPro Data Stream Designer v4.3.7 or later.
Pre v5.00 of the Agents can only run on a Stream Host running on Windows.
| Agent | Win. SH Pre 4.3.7 | Linux SH Pre 4.3.7 | Win. SH 4.3.7+ | Linux SH 4.3.7+ |
|---|---|---|---|---|
Download the Azure SQL Listener v5.50
Download the Azure SQL Context Provider v5.50
Download the Azure SQL Action Agent v5.50
Please contact XMPro if you're looking for an older Agent version.
Updated Microsoft.Data.SqlClient from v5.1.1 to v5.2.1 for the CVE-2024-0056 security update
Updated XMPro.IOT.Framework to v4.1.0
Updated System.Data.SqlClient to Microsoft.Data.SqlClient, which allows the Agent to run on a Windows or Linux Stream Host
This is a breaking change - note the updated pre-requisites
Repackaged to include the Agent's Category
Not retaining the connection settings when switching from system variables to free text fields
XMP Error for Password Variable box fixed
Added option to specify connection settings using system Variables
Using Connection Variables is the default setting from this version
If upgrading the Agent in an existing Data Stream, you need to add the system variables first and then perform the variable mapping in the Data Stream
Catching errors from receive/poll and publishing to Error Endpoint
Added option to specify columns to return
Updated help url
Added Error Endpoint
Removed validation on Database to cater for sql logins that don't have access to query master database
Changed Database dropdown to allow custom values so that user can specify database name manually which is needed when login doesn't have permission to query master database
Modified the error handling accordingly
Validation bug fixed
Initial Release
Updated Microsoft.Data.SqlClient from v5.1.1 to v5.2.1 for the CVE-2024-0056 security update
Updated XMPro.IOT.Framework to v4.1.0
Updated System.Data.SqlClient to Microsoft.Data.SqlClient, which allows the Agent to run on a Windows or Linux Stream Host
This is a breaking change - note the updated pre-requisites
Repackaged to include the Agent's Category
Fixed validation error when using SQL query option
Added option to specify SQL Query
Added option to limit the number of rows returned either by count or duration
Not retaining the connection settings when switching from system variables to free text fields
XMP Error for Password Variable box fixed
Added option to specify connection settings using system Variables
Using Connection Variables is the default setting from this version
If upgrading the Agent in an existing Data Stream, you need to add the system variables first and then perform the variable mapping in the Data Stream
Catching errors from receive/poll and publishing to Error Endpoint
Catching errors from receive/poll and publishing to Error Endpoint
Incorporate changes to Filter the Agent
Added filter option
Added option to specify columns to return and sort order
Updated help url
Added Error Endpoint
Removed validation on Database to cater for SQL logins that don't have access to query master database
Changed Database dropdown to allow custom values so that user can specify database name manually which is needed when login doesn't have permission to query master database
Modified the error handling accordingly
Validation bug fixed
Initial Release
Initial Release
Updated Microsoft.Data.SqlClient from v5.1.1 to v5.2.1 for the CVE-2024-0056 security update
Updated XMPro.IOT.Framework to v4.1.0
Fixed issue with the Update action where new records were being created rather than updating
Added Dynamic SQL query support
Updated System.Data.SqlClient to Microsoft.Data.SqlClient, which allows the Agent to run on a Windows or Linux Stream Host
This is a breaking change - note the updated pre-requisites
Repackaged to include the Agent's Category
Added config option to specify Command Timeout
Added SQL update support
Fixed issue with output parameters where the size was restricted by the input value
Fix for handling null values in the payload
Outputting original payload and added return type option when using stored proc
Not retaining the connection settings when switching from system variables to free text fields
XMP Error for Password Variable box fixed.
Added stored proc functionality
Added option to specify connection settings using system Variables
Using Connection Variables is the default setting from this version
If upgrading the Agent in an existing Data Stream, you need to add the system variables first and then perform the variable mapping in the Data Stream
Added stored proc functionality (this version doesn't have system variables)
Catching errors from receive/poll and publishing to Error Endpoint
Updated help url
Added Checkbox in config settings to allow firing database triggers on insert (if defined)
Added OnError Endpoint
Removed validation on Database to cater for sql logins that don't have access to query master database
Changed Database dropdown to allow custom values so that user can specify database name manually which is needed when login doesn't have permission to query master database
Modified the error handling accordingly
Validation bug fixed
Batch Writing added
Initial Release
v5.00+
Pre v5.00