About the Simba Druid ODBC Connector

Druid is a column-oriented, open-source, and has a distributed architecture that is designed to be cloud-friendly and easy to operate. Druid is designed to quickly ingest massive quantities of event data, and provide low-latency queries on top of the data.

Druid is commonly used in business intelligence-OLAP applications to analyze high volumes of real-time and historical data. You can configure and scale services independently so you have maximum flexibility over cluster operations.

Druid relies on an external dependency for metadata storage. Druid uses the metadata store to house various metadata about the system, but not to store the actual data. The metadata store retains all metadata essential for a Druid cluster to work.

Druid stores data partitioned by time chunk in immutable files called segments.

Druid allows you to provide a new schema for new data without the need to update the schema of any existing data. This is made possible by the fact that each segment, at the time it is created, stores a copy of its own schema. Druid reconciles all of these individual segment schemas automatically at query time.

About the Connector

The Simba Druid ODBC Connector lets organizations connect their BI tools to Druid. Druid provides a Druid SQL query layer and also exposes the metadata information through a Druid SQL standard metadata database called INFORMATION_SCHEMA. The Simba Druid ODBC Connector leverages INFORMATION_SCHEMA to expose Druid’s metadata to BI tools as needed.

The connector complies with the ODBC 3.80 data standard, including important functionality such as Unicode and 32- and 64-bit support for high-performance computing environments on all platforms.

ODBC is one of the most established and widely supported APIs for connecting to and working with databases. At the heart of the technology is the ODBC connector, which connects an application to the database. For more information about ODBC, see Data Access Standards on the Simba Technologies website: https://www.simba.com/resources/data-access-standards-glossary. For complete information about the ODBC specification, see the ODBC API Reference from the Microsoft documentation: https://docs.microsoft.com/en-us/sql/odbc/reference/syntax/odbc-api-reference.

The Simba Druid ODBC Data Connector Installation and Configuration Guide is suitable for users who are looking to access data residing within Druid from their desktop environment. Application developers may also find the information helpful. Refer to your application for details on connecting via ODBC.

About Druid SQL

The Connector only accepts the SQL Queries written in Druid SQL Query language. Connector uses the Druid SQL API https://docs.imply.io/latest/druid/api-reference/sql-api/ to Parse the Druid SQL queries.