Rockset Enables Real-Time Analytics for Microsoft SQL Server

Rockset, provider of a real-time analytics platform built for the cloud, has announced a new integration that uses change data capture (CDC) streams from Microsoft SQL Server to enable real-time analytics. According to Rockset, the integration developers enables to run sub-second, high-concurrency analytics on data from Microsoft SQL Server in real time.

With this release, Microsoft SQL Server users can move away from traditional batch ETL toward real-time change data capture to see and respond to changes as they occur, for user-facing analytics and operational analytics use cases.

“Microsoft SQL Server is among the top 5 most popular databases according to StackOverflow and DB-Engines,” said Shruti Bhat, chief product officer at Rockset. While leading cloud providers now provide ways to tap into changes as they occur in the form of database CDC streams, most warehouses are not equipped to consume and analyze these CDC streams in real-time, Bhat noted. “As a real-time analytics platform built for the cloud, Rockset is fully mutable to elegantly handle upserts and stay in sync with SQL Server tables, in real-time.”

As the world moves from batch to real-time analytics, this release enables developers using SQL Server to:

  • Run sub-second analytical queries, including JOINs with other databases, lakes, or event streams.
  • Achieve better database performance by isolating analytical queries on Rockset, which in turn scales horizontally in the cloud.
  • Power fast microservices using developer SDKs or deliver real-time reporting using one of Rockset’s integrations with visualization tools including Tableau, Retool, Redash, and Superset.

Built by the team behind the online infrastructure data that powers Facebook Newsfeed and Search, Rockset is inspired by the same indexing systems that power real-time analytics at cloud scale. Rockset automatically indexes all fields in a Converged Index, delivering fast SQL queries on real-time data, for cloud-native speed, scale, and flexibility in real-time analytics.

Rockset now has an extensive library of data connectors for schemaless ingestion from existing event streams, databases and lakes and stays in sync with the data source, enabling fast analytics within 1-2 seconds of new data being generated. As the data arrives, Rockset supports continuous SQL transformations and rollups without the need for batch ETL jobs.

To learn more about Rockset’s integration, visit https://rockset.com/docs/mssql.

Leave a Comment