SQL Server Context Provider

Description

Allows the user to add context to a stream by bringing in reference/static data from a configured SQL data source.  It is used in conjunction with the Join transformation which allows two data sources to be joined together to form a new data source for the stream.

Configuration

To add the SQL Server Context Provider to a stream, follow the steps below:

1. Ensure you have a use case open in the stream designer, this can be a new use case or an existing use case
2. From the toolbox on the left expand the Context Provider option and scroll down until you can see “SQL Server Context Provider”
   • You can also use the search in the header to find the agent quickly
3. Click and drag the SQL Server Context Provider from the toolbox onto the canvas
4. Rename the Context Provider by clicking into the text button on the action bar
5. Save the Stream by clicking the save button in the action bar
6. Hover over the icon for the agent until it turns orange and then double click to open the configuration page
   • You can optionally use the configure option on the action bar once you have selected the specific agent and then clicking this option
7. Configuration options
   • The drop-down allows you to associate this agent with a specific collection. The default option is derived from the default specified against the specific use case and is generated left as the same option. If you do need to change it to another collection make the change by selecting the new collection in the drop-down.
   • Enter a value for the Polling Interval. Context Providers get the data they need and store it in memory. The Polling Interval is the rate at which the cache will be refreshed, for example, if I specify it as “30 seconds”, the cache will be refreshed every 30 seconds.
8. Enter Server details
   • Enter the Server Instance
   • Enter the User name
   • Tick “Use SQL Server Authentication” if required to enter Password
9. Enter Database details
   • Select Database from drop-down list
   • Select Table from drop-down list
   • Select Columns to Return from drop-down list. If no columns specified, all columns will be returned
10. Enter Filtering & Sorting details
    • Enter Limit Rows Returned. If not specifies, all qualified rows will be returned.
    • Add/Delete Filters by adding conditions/groups.
    • Enter Sort By details. Column and Order need to be specified.
11. Click Apply on the action bar, and then save the stream using the save button.

Limitations

• None at this time

Release Notes

Version:	3.12
Released:	22-Oct-2019
Release Notes:	Incorporate changes to Filter agent