Rockset, a real-time analytics company, announces today an integration with Microsoft SQL Server, enabling developers to run sub-second, high-concurrency analytics on data from Microsoft SQL Server, in real-time.
Most organizations invest in real-time analytics as the foundation for digital, particularly in areas like e-commerce, logistics and delivery tracking, gaming leaderboards, fraud detection systems, health and fitness trackers and social media newsfeeds.
With this release, Microsoft SQL Server users can move away from traditional batch ETL towards real-time change data capture to see and respond to changes as they occur, for user-facing analytics and operational analytics use cases.
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 data infrastructure 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 trademarked Converged Index, delivering fast SQL queries on fresh data, for cloud-native speed, scale, and flexibility in real-time analytics.
Rockset 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.