March 2019 Summaries

CData Software is a leading provider of data access and connectivity solutions that streamline data access and insulate customers from complex integrations with various databases and platforms.` `The company offers a range of products including data connectors, ETL/ELT solutions, cloud & API connectivity, OEM & custom drivers, and data visualization tools.` `CData Software aims to address the major data management challenges facing organizations by providing standards-based connectors that simplify data integration and access.

The CData Azure Cosmos DB Driver Comparison highlights the benefits of using a third-party driver over Microsoft's free ODBC driver for performance, feature support, and platform compatibility. The drivers provide increased performance compared to the Microsoft ODBC driver, supporting advanced push-down query capabilities and computing aggregations server-side. They also offer full support for built-in functions, user-defined functions, stored procedures, and JOIN ... IN queries, which are not fully supported by the Microsoft ODBC driver. Additionally, the CData drivers are available for Windows, Linux, and Mac platforms, whereas the Microsoft ODBC driver is only available on Windows. The comparison also mentions that CData provides native SSIS components, a Power BI connector with improved performance, and support for connecting to Cosmos DB from various applications such as Java and SQL Server Integration Services.

The CData Software Drivers offer unparalleled functionality for integrating with live Couchbase data in popular BI, reporting, and ETL tools, supporting both the Query (N1QL) service for write access to documents and the Analytics (SQL++) service for optimized ad-hoc queries. The drivers leverage the powerful data processing capabilities of the Couchbase Server, free up local resources, and provide recognizable data types and relational structures even though the underlying data is NoSQL. With built-in dynamic metadata querying, the CData Drivers translate SQL-92 queries into N1QL or SQL++, pushing every supported operation directly to the Couchbase server. The drivers are updated with new features and functionality in step with any updates to the Couchbase services, providing an optimized Couchbase experience from various tools, platforms, languages, or frameworks that support standard SQL.