While traditional BI and analytics tools offer a broad set of connectors for primarily SQL data sources, Zoomdata offers the widest set of connectors for modern data stores such as cloud data warehouses, Hadoop, NoSQL document store databases, streaming, search engines, as well as for traditional SQL relational database and modern data warehouses.
Smart Data Connectors are ready to connect to a wide variety of traditional and modern data sources
Zoomdata Smart Data Connectors let you directly query all your data, regardless of where it's stored or how it's managed. All data requests start with the same simple Zoomdata query API for Elasticsearch, Impala, MongoDB, Snowflake, SQL Server, and almost anything else you use. Our library of Smart Data Connectors and scalable data access framework convert those dynamic user requests into native pushdown queries.
No SQL jockeying or XML coding necessary, and your data stays securely in place. No need to move or prep the data in a middle tier BI server or cube.
A Smart Data Connector is a Zoomdata microservice that retrieves data. Each Smart Data Connector is dedicated to translating abstract query requests from the Zoomdata Query Engine into native pushdown queries.
Smart Data Connectors are different from traditional connectors because they:
The data access framework is extensible to anticipate even more changes as data platforms continue to evolve. The framework is also adaptable. For traditional RDBMS data sources, for example, the Smart Data Connector will use SQL when available and native API calls when necessary. For example, a data platform may support query cancellation, but its JDBC driver may not. Zoomdata data connectors are smart enough to adapt its query protocol to fulfill user requests.
This episode of The Briefing Room with Eric Kavanagh covers a lot of ground, including a technical discussion of Smart Data Connectors starting at 47:55
Since all data sources are not the same, Zoomdata doesn’t treat them with lowest common denominator connectors. Instead, Zoomdata Smart Data Connectors leverage the unique capabilities of each data source in order to optimize performance and take advantage of the their query expressiveness.
For example, the Zoomdata data access framework accommodates many modern data source innovations, including:
Smart Data Connectors also perform the important job of reporting data types and other supported functionality. The Query Engine uses this information to plan, optimize, and execute data requests.
Zoomdata pushes query processing to the source as much as possible. For sources like Impala that speak SQL, Zoomdata generates SQL queries and sends them to the source. For sources like Elasticsearch, Cloudera Search, and Solr that speak search, Zoomdata generates search queries and, again, sends them to the source. The “heavy lifting” involved with resolving a query, such as aggregation, filtering and calculations, is performed by the system where the data resides. Only the final result set is transferred from the source to the Zoomdata server. Avoiding unnecessary data movement is essential for big data scalability.
Zoomdata supports the industry’s broadest range of modern data sources designed for big, streaming and unstructured data, as well as traditional SQL relational databases. We keep up to date with new sources as they gain adoption within organizations for their BI and visual analytics requirements.
However, on occasion organizations may find they need to connect to a source not currently supported by Zoomdata, for example a homegrown application, or a new or emerging data platform.
Zoomdata has you covered. The Zoomdata data access framework is extensible to allow the creation of custom Smart Data Connectors. This is an advanced data preparation capability that incorporates Zoomdata "smarts" for functionality and optimizations, such as streaming, partition awareness, and more. Please contact us to discuss your needs and pricing.
If you’re using any of the modern and big data sources — Hadoop, search engines, streaming, NoSQL, cloud data warehouses — you need Zoomdata. Our library of Smart Data Connectors and scalable data access framework convert dynamic user requests into native pushdown queries.