by Jerod Johnson | January 31, 2019

SQL Access to Elasticsearch

Elasticsearch is a distributed, RESTful search and analytics engine capable of solving a growing number of use cases. It centrally stores your data so you can discover the expected and uncover the unexpected.

As Elasticsearch offers some limited driver interfaces we are often asked how our Elasticsearch Drivers compare. In addition to supporting Elasticsearch across all of our supported Driver and Adapter Technologies, our Drivers also provide true SQL-92 interfaces.

Key Differentiators

CData Drivers offer all of the functionality of the native drivers and more, including the following:

  • Enables SQL access to Elasticsearch v2.2 and above (compared to v6.3 and above)
  • Compatible with all Elasticsearch subscriptions, from Basic/Open Source to Platinum
  • Connects to the SQL endpoint and REST endpoint (as opposed to only the SQL endpoint)
  • Supports INSERT, UPDATE, and DELETE - not just SELECT
  • Returns the _score column without explicitly requiring the SCORE() function
  • Allows filtering on text fields using = and LIKE (as opposed to only LIKE)
  • Built-in logic to choose a search type (Query String, Match Phrase, Wildcard) based on whether a text field is analyzed or non-analyzed
  • Supports working with arrays
  • Supports working with nested types
  • Enables JOIN queries across indexes as well as JOIN Types on the server

Additional Features and Code Samples

For a detailed walk-through of the technical advantages of CData Drivers for Elasticsearch, read our Knowledge Base article.

Continue to the Full Article ยป

Our drivers offer unmatched flexibility and integration when working with Elasticsearch data. With our drivers, you gain access to a professionally developed, maintained, and supported solution from an industry leader with more than 20 years of experience in data connectivity and integration.

If you are interested in connecting to your Elasticsearch data using standards-based drivers, you can download a free, 30-day trial of any of our drivers for Elasticsearch today! As always, our world-class support team is here to help you integrate your Elasticsearch data into the BI, reporting, ETL, and custom tools of your choice.