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:
String
Numeric
Date and Time
Other
char
varchar
text
nchar
nvarchar
ntext





bit
smallint
int
bigint
decimal
numeric
smallmoney
money
float
real
datetime
datetime2
smalldatetime
date








uniqueidentifier
xml











Pre-requisites
SQL Server database credentials are required to use this Connector.
Downloads
Name
Link
SQL Server Connector v1.34
​Download​
Please contact XMPro if you're looking for an older version of this Connector. 

String	Numeric	Date and Time	Other
char varchar text nchar nvarchar ntext	bit smallint int bigint decimal numeric smallmoney money float real	datetime datetime2 smalldatetime date	uniqueidentifier xml

Name	Link
SQL Server Connector v1.34	Download

Next - How to use?

Example

Last modified 1mo ago