SQL Server Connector

The 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 to provide or modify data in your application. It is mostly used to handle contextual data (that is not expected to change often), but can also provide live data in real-time if the database it is connected to is configured to do so.
Most importantly, it should have service broker functionality enabled and should allow the creation of queues and table triggers by the user whose credentials are being used.

Supported data types

The following SQL data types are supported:
Date and Time
  • char
  • varchar
  • text
  • nchar
  • nvarchar
  • ntext
  • bit
  • smallint
  • int
  • bigint
  • decimal
  • numeric
  • smallmoney
  • money
  • float
  • real
  • datetime
  • datetime2
  • smalldatetime
  • date
  • uniqueidentifier
  • xml


SQL Server database credentials are required to use this Connector.


SQL Server Connector v1.34
Please contact XMPro if you're looking for an older version of this Connector.
Last modified 1mo ago