Rockset Delivers Fast Analytics on SQL Server Data

(Wright-Studio/Shutterstock)

Rockset today announced launched a new integration into SQL Server that will allow customers to continuously index production data as it hits the relational database and deliver sub-second analytics on that data.

Rockset is a relational database designed to enable customers to run real-time analytics on fast moving data. One of the key elements of the offering is its Converged Index, which indexes every field in customers’ data, including structured data but also JSON, geo and time-series data. Once it’s indexed, Rockset employs SQL to query the data, which can include joins, windowing functions, sorts, aggregations, and order-bys, among others.

The new integration with SQL Server will enable customers to move away from batch-oriented ETL workflows and instead use change data capture (CDC) functionality to get at fresh data as soon as it’s entered into the relational database, the company says.

The combination of CDC with the Rockset index gives customers a new cpaabilty to analyze fast-moving data, says Shruti Bhat, the 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 says in a press release. “As a real-time analytics platform built for the cloud, Rockset is fully mutable to elegantly handles upserts and stay in sync with SQL Server tables, in real-time.”

Rockset says the new integration will enable analysts to query data generated in SQL Server using visualization tools like Tableau, Retool, Redash, and Superset. It will also enable customers to build new applications that incorporate real-time analytics in the areas of e-commerce, logistics, delivery tracking, gaming leaderboards, fraud detection systems, health and fitness trackers, and social media newsfeeds, the company says.

The San Mateo, California company boasts a collection of integrations and connectors for a variety of data sources, including data buses like Apache Kafka and Amazon Kinesis; NoSQL databases like MongoDB and DynamoDB; and relational databases like PostgreSQL and, now, SQL Server.

Rockset was founded by former Facebook engineers, including some of the team that developed Newsfeed and Search. Venkat Venkataramani, the company’s co-founder and CEO, is also a Datanami Person to Watch for 2022.

Related Items:

Did Rockset Just Solve Real-Time Analytics?

Investors Continue to Target Real-Time Analytics

Rockset, SQL Cloud Service, Emerges from Stealth