How To Configure The Azure SQL Context Provider - XMPRO Data Stream Designer

Learn how to configure the Azure SQL 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.com if you want to learn more about how you can build real-time applications with our Event Intelligence Platform.

Transcript

but we are going to do here is look at

how to set up and configure there is

equal context provider go to the toolbox

and search for a sequel

you will find it on the 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 election 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 are accessed or

checked for then add the server IP or

DNS name of here's your sequel database

click someone else on the phone add your

user name

add your password

at the data base you want to connecting

choose the table you want to receive

context from if you'd like any certain

columns to be retained click on the

columns to return field and select the

columns from the list if you do not

select any columns all columns will be

returned next if you'd like to limit the

amount of rows returned fill in the

number in the text box if you do not

fall in anything or qualified words will

be returned next if you would like to

apply filters click on the plus button

you will be given the choice 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 then select the field upon

which the filter needs to be applied

choose your expression and enter a value

if you'd like to sort the data returned

click on plus select the column by which

that better will be sorted select how

the data should be sure sorted either

ascending or descending

click outside of the table click apply

click side

Last updated