Search code examples
reporting-servicesssisssasstreaminsight

Streaminsight vs CDC

Am I missing something, or is streaminsight an easier way to incorporate the traditional BI solution with SSAS/SSRS/SSIS.

Traditional:

Sources->SSIS->Staging area->SSIS->warehouse->SSAS/SSRS/PowerPivot/..

StreamInsight:

Sources->StreamInsight->SSAS/SSRS/PowerPivot

In the traditional way we do not have capabilities for real-time analytics, you always need to define a time period to run the SSIS package again. We can however, use CDC (Change Data Capture), which makes it somewhat realtime. CDC checks for changes in databases and fires the SSIS package.

StreamInsight offers a real-time ETL solution.

Is this right?

Solution

  • That is certainly one use case for StreamInsight. This is especially true if you have cases where you can take advantage of the stream processing to glean intelligence from the data while it's in flight to the warehouse.