Learn how to configure the SQL Server Context Provider in the XMPRO Data Stream Designer.
Need help with creating your XMPRO data streams? Send an email to support@xmpro.com
Go to https://xmpro... what we are going to do here is look at
how to set up and configure the sequel
server context provider go to the
toolbox and search for sequel server you
will find it under context providers
click on the agent and drag it to the
canvas click on save double click on
your agent
this is where you will be configuring
your agent first make sure you're using
the correct collection
if not select another collection from
the drop-down next add a value for your
polling interval which is the right at
which new records or accessed or checked
for I'm going to leave it at 10 records
per second next add the name of your
sequel server instance click somewhere
else on the form add your user name if
you'd like to use siegel server
authentication click on the check box
and add your password
if you do not select the checkbox
windows authentication will be used
select the database you'd like to
connect to select the table you'd like
context off
if you'd like only certain columns to be
returned click on the columns to return
field and selected columns from the
drop-down if you do not select any
columns all columns will be returned if
you'd like to limit the amount of rows
returned add their amount of rows you'd
like to have returned if you leave this
field blank all qualifying rows will be
returned next if you like to add a
filter click on the plus button you're
given you will be given the option to
add either condition or group the
default group has already been added for
you if you'd like to add a condition
click on add condition select the field
upon which the condition needs to be
based then select your equation finally
add a value
if you'd like to sort the data returned
click on the plus button select the
field you'd like the data to be sorted
by then select the order which can be
either a Sydney or descending click
somewhere else on the form click apply
click Save
you
