Pull Aggregated Data from DB and use in StreamInsight Cache

Question

For a majority of our events comparing the events in the stream will work, but for some scenarios we will want to utilize aggregations we are calculating from a datastore (Nightly or something) and use that as our comparison.  How can you do that with StreamInsight? Or is there a better process / flow to accomplish this. 

Answer 1

Have you tried looking at Mark's post on using Reference data? It sounds almost exactly like that.

You could also just use StreamInsight and calculate the daily aggregates on the fly. The built-in aggregates are incremental in nature; they don't keep all of the "source" events around in memory, just the calculated results so they are pretty efficient.

---

DevBiker (aka J Sawyer)
My Blog
My Bike - Concours 14

---

If I answered your question, please mark as answer.
If my post was helpful, please mark as helpful.

Answer 2

Thanks I will take a look at the blog