Rockset, provider of a real-time analytics platform built for the cloud, announced a new integration that uses Microsoft SQL Server Change Data Capture (CDC) streams to enable real-time analytics. According to Rockset, the integration allows developers to run real-time, high-concurrency analytics in less than a second on Microsoft SQL Server data.
With this release, Microsoft SQL Server users can move away from traditional batch ETL to real-time change data capture to see and respond to changes as they happen, for user analytics and operational analytics use cases.
“Microsoft SQL Server is in the top 5 most popular databases according to StackOverflow and DB-Engines,” said Shruti Bhat, product manager at Rockset. While major cloud providers now offer ways to leverage changes as they happen in the form of database CDC feeds, most warehouses aren’t equipped to consume and analyze these. real-time CDC feeds, Bhat noted. “As a real-time analytics platform built for the cloud, Rockset is fully tweakable to gracefully handle upserts and stay in sync with SQL Server tables, in real time.”
As the world moves from batch to real-time scanning, this release enables developers using SQL Server to:
- Run analytical queries in less than a second, 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 provide real-time reporting using any of Rockset’s integrations with visualization tools like Tableau, Retool, Redash, and Superset.
Built by the team behind the online data infrastructure that powers Facebook Newsfeed and Search, Rockset is inspired by the same indexing systems that power cloud-scale real-time analytics. Rockset automatically indexes all fields in a converged index, providing fast SQL queries against real-time data, for cloud-native speed, scalability, and flexibility in real-time analytics.
Rockset now has an extensive library of data connectors for schema-free ingestion from existing event streams, databases, and lakes and stays in sync with the data source, enabling rapid 1-to-1 analysis. 2 seconds after generating new data. As data comes in, Rockset supports continuous SQL transformations and rollups without the need for batch ETL jobs.
To learn more about Rockset integration, visit https://rockset.com/docs/mssql.