Disrupting the $25bn Business Intelligence market, developers can build data modeling, caching and access control layers on top of streaming SQL just as with cloud data warehouses.

Cube Dev, the open source company behind the Cube headless BI platform, announced its support for streaming data by integrating with ksqlDB and introducing support for implementing the lambda architecture with cloud data warehouses and streaming platforms. The integrations make Cube’s consistent data definitions, security modeling and caching accessible to developers who wish to build applications powered by real-time data.

Marketing Technology News: AI-Power Synchronizes Voice and Images Perfectly, Making Explainer Video Creation Simpler Than Ever

ksqlDB Support

Cube Dev’s headless BI tool now supports data furnished via streaming SQL technologies. This support makes it possible to process streaming data and run analysis via SQL—without the need for developers to build specific language-unique integrations.

“We’re excited to announce that it’s now possible to use Cube’s headless BI to build data modeling, caching, and access control layers on top of streaming SQL,” said Artyom Keydunov, co-founder and Chief Executive Officer of Cube Dev, Inc. “Cube now can connect to streaming SQL engines and expose streaming data via our REST, GraphQL and SQL APIs to your downstream applications.”

With this new integration, Cube brings the ability to create real-time data applications to its growing community of data engineers. Thousands of companies, from startups to Fortune 500 enterprises, have built data applications by using cloud data warehouses for data storage, Cube for data access and data modeling, and open-source front-end tools for data visualization.

“Our data modeling, caching, access control and querying APIs are the same whether you work with streaming or batch data,” Keydunov said.

Lambda Architecture Support

Cube also announced an enhancement to its pre-aggregations feature. In a design that utilizes the lambda architecture, Cube’s system of materialized query results now creates a union of streaming and batch data. Cube pre-aggregates batch data from the cloud data warehouse as well as data from streaming SQL engines, then unites these pre-aggregations during query processing.

With this implementation, Cube has hidden the complexity of data merging within its data modeling layer—so software developers can consume a single dataset regardless of how many streaming and batch data sets it comprises.

Marketing Technology News: MarTech Interview With Jorge Poyatos, Co-founder at Seedtag

Future Plans Announced

The company announced that ksqlDB support and lambda-based pre-aggregations are immediately available to early-access users of the Cube platform and will enter general availability in coming weeks.

In addition, Cube has committed to additional releases with specific support for Materialize streams, Flink SQL and Spark Streaming.

“Naturally, our work isn’t done yet,” Keydunov said. “We’re excited by these announcements because they bring the power and simplicity of our headless BI architecture to new types of data applications.”