Azure SQL

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, or execute a stored procedure. You can configure whether the destination table should be created before writing to it.

Pre-requisites

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.

Earlier versions of the Agents can run on the newer Stream Host, but only if the Stream Host is running on Windows.

AgentSH Pre 4.3.7SH Windows 4.3.7+SH Linux 4.3.7+

v5.00+

Pre v5.00

Download

NameLink

Azure SQL Listener v5.00

Azure SQL Context Provider v5.00

Azure SQL Action Agent v5.00

Please contact XMPro if you're looking for an older Agent version.

Last updated