January 2018 Summaries

The Best Way to Embed Elasticsearch Elasticsearch is a powerful search and analytics engine that can be used to solve various use cases by centrally storing data, allowing users to discover expected results and uncover unexpected insights. CData Software provides standards-based drivers for Elasticsearch, enabling access to Elasticsearch data from popular Business Intelligence (BI) tools, reporting tools, ETL tools, and custom applications, facilitating deep insights into the data using familiar tools. The drivers offer SQL-92 access to Elasticsearch data, API abstraction, intelligent data interpretation, a client-side SQL engine for complex query processing, and other features that make it easier to work with Elasticsearch data in various contexts.

The CData ODBC Driver for JSON allows users to gain ODBC connectivity to their Airtable data, enabling easy working with the data in BI, reporting, and ETL tools of choice. To use the driver, a DSN must be configured, which involves creating a schema file for each table being worked with. The schema files are created based on information from the Airtable REST API and sample responses. Once the DSN is configured and the schema file(s) are created, users can connect to their Airtable data over ODBC in their preferred BI, reporting, or ETL tool. A free 30-day trial of the driver is available for download, along with support from a world-class team.