A real-time analytics platform designed for the cloud, Rockset enables its developers to run sub-second data in real-time with high-concurrency data analytics on Microsoft SQL Server data through a collaboration with Microsoft SQL Server.
“Microsoft SQL Server is among the top 5 most popular databases according to Stack Overflow and DB-Engines. While leading cloud providers now provide ways to tap into changes as they occur in the form of Database Change Data Capture (CDC) streams, most warehouses are not equipped to consume and analyze these CDC streams in real-time. 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,” stated Shruti Bhat, Chief Product Officer at Rockset.
The number of organizations depending upon real-time analytics is increasing day by day. The users of Microsoft SQL Server can choose real-time data capture instead of traditional ETL batches through this collaboration which enables the users to view and respond to the changes happening instantly.
The new capability of SQL Server enables the developers to run sub-second analytical queries. The database performance gets enhanced by segregating analytical queries on Rockset, which grows horizontally in the cloud. Use developer SDKs to power quick microservices, or use Rockset’s integrations with visualization tools like Tableau, Retool, Redash, and Superset to offer real-time reporting.
Rockset is inspired by the same indexing techniques that support real-time analytics at a cloud scale and was built by the team behind the online data infrastructure that powers Facebook Newsfeed and Search. For cloud-native speed, scale, and flexibility in real-time analytics, Rockset automatically indexes all fields in a Converged IndexTM, offering rapid SQL queries on real-time data.
Quicker analytics within 1-2 seconds can be generated using the extensive source of data connectors that enable schemaless ingestion from existing event streams, databases, and lakes by staying in sync with data sources. Rockset provides constant support to the SQL transformations and rollups as the data reaches eliminating the need of ETL batch jobs.