Company
Date Published
Author
Sachin Smotra, Director Product Management, Couchbase
Word count
878
Language
English
Hacker News points
None

Summary

The Couchbase Data Platform now supports hybrid transaction/analytical processing (HTAP) workloads and its massively parallel processing (MPP) query engine allows for fast ad-hoc analytical queries without impacting performance. The CData drivers provide a SQL interface for NoSQL data sources like Couchbase Analytics, translating SQL queries into SQL++ to leverage the server-side capabilities of Couchbase Analytics for real-time data in BI and analytics tools. The drivers flatten objects using dot notation and array elements using 0-based indexing, allowing connectivity with tools that generate SQL queries internally. As Couchbase Analytics and its interfaces continue to evolve, so will the CData drivers, implementing new query features while leveraging powerful data processing capabilities to enable easy data visualization and reporting in SQL-enabled tools.