January 2019 Summaries

Elasticsearch is a distributed search and analytics engine that centrally stores data for discovery and analysis purposes.` Its native drivers offer limited functionality compared to CData Drivers, which provide true SQL-92 interfaces and support various Elasticsearch versions, subscriptions, and endpoints, including the SQL endpoint, REST endpoint, and JOIN queries. CData Drivers also offer advanced features such as filtering on text fields using `=` and LIKE, working with arrays and nested types, and enabling JOIN queries across indexes. With unmatched flexibility and integration, CData Drivers provide a professionally developed solution for connecting to Elasticsearch data in various BI, reporting, ETL, and custom tools.

Amazon DocumentDB is a fully managed NoSQL database service by AWS, designed to be compatible with MongoDB workloads, offering flexible and scalable data storage and management capabilities, including schema-less or schema-flexible document formats, scalability through horizontal scaling, collections for grouping documents, and indexing for efficient querying. It's a document database that stores data in JSON-like documents, providing seamless integration with CData connectivity solutions, allowing developers to quickly build applications using BI, reporting, and ETL tools, with minimal changes required from MongoDB applications.

Microsoft offers a suite of low-code solutions for building business applications and working with data through its Power BI service, PowerApps, and Flow platforms. The CData Cloud Hub is a cloud-based data pipeline that provides live access to data from various SaaS applications and databases, enabling users to build next-generation business applications and workflows. Users can connect the Cloud Hub to these platforms in several ways, including using the Power BI service, PowerApps, or Microsoft Flow, allowing for seamless integration of enterprise data across multiple applications and services.