Zoomdata Version

Connector Feature Support

Zoomdata queries each connector to better understand its data store's capabilities and behavior. The connector's response describes to Zoomdata the Zoomdata features that the connector and the data store can support and any limitations to that support. It identifies the type of data requests that the connector and its data store can fulfill.

To learn more about a Zoomdata feature and the connectors that support it, select the feature from the list below:

Admin-Defined Functions

The connector supports administrator-defined functions.

Note:BigQuery, Apache Phoenix (+QS), Cassandra (Presto), and Vertica have not been tested for this feature.

Admin-defined functions do not apply to the Real Time Sales data store.

Supported By Not Supported By
Amazon Redshift
Amazon S3
Apache Drill
Apache Phoenix
Aurora
Cloudera Impala
Flat File
HDFS
Hive
MemSQL
Microsoft SQL Server
MySQL
Oracle
PostgreSQL
SAP Hana
SAP IQ
Snowflake
Spark SQL
Teradata
Upload API
Apache Solr
Cloudera Search
Elasticsearch 5.0
Elasticsearch 6.0
MongoDB

Box Plot

The connector supports percentile calculations and box plot visualizations.

Supported By Not Supported By
Amazon Redshift
Amazon S3
Apache Drill
Apache Solr (>=5.3)
BigQuery
Cassandra (Presto)
Cloudera Impala
Elasticsearch 5.0
Elasticsearch 6.0
Flat File
HDFS
Hive
MemSQL
Microsoft SQL Server
Oracle
PostgreSQL
Real Time Sales
SAP Hana
SAP IQ
Snowflake
Spark SQL
Teradata
Upload API
Vertica

Apache Phoenix (+ QS)
Apache Solr (< 5.3)
Aurora
Cloudera Search
MongoDB

Custom SQL Queries

Applicable only to SQL-based connectors. A data source using this connector can use an SQL query to select fields from the table. The custom SQL statement can be specified on the Tables/Indices Tab of the data source configuration wizard after clicking the Custom SQL button.

In SQL-based sources, Zoomdata typically wraps the query with select * from. For example, suppose the original query is this:

select count(*), someField from myCollection GROUP By someField

The resulting query that Zoomdata uses is this:

select * from (select count(*), someField from myCollection GROUP By someField)

Custom queries do not apply to MongoDB or Real Time Sales data stores or to search-based (Apache Solr, Cloudera Search, or Elasticsearch) data stores.

Supported By Not Supported By
Amazon Redshift
Apache Drill
Apache Phoenix (+ QS)
Aurora
Cassandra (Presto)
Cloudera Impala
Hive
MemSQL
Microsoft SQL Server
MySQL
Oracle
PostgreSQL
SAP Hana
SAP IQ
Snowflake
Spark SQL
Teradata
Vertica

Amazon S3
BigQuery
Flat File
HDFS
Real Time Sales
Upload API

Derived Fields (Row-Level Expressions)

The connector supports derived fields. If a connector supports derived fields, it also supports row-level expressions.

Supported By Not Supported By
Amazon Redshift
Amazon S3
Apache Drill
Apache Phoenix (+ QS)
Aurora
Cloudera Impala
Elasticsearch 5.0
Elasticsearch 6.0
Flat File
HDFS
Hive
MemSQL
Microsoft SQL Server
MongoDB (partial)
MySQL
Oracle
PostgreSQL
Real Time Sales
SAP Hana
SAP IQ
Snowflake
Spark SQL
Teradata
Upload API

Apache Solr
BigQuery
Cassandra (Presto)
Cloudera Search
Vertica

Distinct Counts

The connector supports distinct counts. Distinct counts can be used to determine the number of unique values for a field in the data.

For example, given a single collection and string field with the following three values:

  1. Apple
  2. Orange
  3. Apple

The distinct count returns 2, since there are only two distinct values (“Apple” and “Orange”), while an ordinary count returns 3 to reflect the total number of records.

SQL-based connectors might produce a query that looks like this:

select count(distinct myField) from myCollection
Supported By Not Supported By
Amazon Redshift
Amazon S3
Apache Drill
Apache Phoenix (+ QS)
Apache Solr
Aurora
BigQuery
Cassandra (Presto)
Cloudera Impala
Cloudera Search
Elasticsearch 5.0
Elasticsearch 6.0
Flat File
HDFS
Hive
Microsoft SQL Server
MongoDB
MySQL
Oracle
PostgreSQL
Real Time Sales
SAP Hana
SAP IQ
Snowflake
Spark SQL
Teradata
Upload API
Vertica
---

Fast Distinct Values

The connector can efficiently return distinct values for a field. It optimizes retrieval of distinct (unique) values in large numbers of records. If a connector supports this feature, the Filter dialog is populated with distinct values for an attribute directly from the data source, without the need to run a Scheduler refresh job and without retrieving or storing the distinct values in Zoomdata's metadata. For example, Elasticsearch keeps lists of distinct values at the ready. Features such as these make fast distinct values possible for your connector.

There is no metric that defines “fast”. This value is based on the judgment by the developer.

For most connectors, this feature can be safely left disabled without impact.

Supported By Not Supported By
Apache Solr
Cloudera Search
Elasticsearch 5.0
Elasticsearch 6.0
This feature applies only to search-based connectors.

Group By Multiple Fields

The connector can group by more than one field in a query. Here is a sample SQL query:

select firstField, secondField, count(distinct otherField) from myCollection group by firstField, secondField

If multi-group querying is not supported, some visualizations will be unavailable for the source.

Supported By Not Supported By
Amazon Redshift
Amazon S3
Apache Drill
Apache Phoenix (+ QS)
Apache Solr (>=5.3)
Aurora
BigQuery
Cassandra (Presto)
Cloudera Impala
Elasticsearch 5.0
Elasticsearch 6.0
Flat File
HDFS
Hive
MemSQL
Microsoft SQL Server
MongoDB
MySQL
Oracle
PostgreSQL
Real Time Sales
SAP Hana
SAP IQ
Snowflake
Spark SQL
Teradata
Upload API
Vertica
Apache Solr (<5.3)
Cloudera Search

Group By Time

The connector supports grouping data by a real time field. This function is a prerequisite for all time-based visualizations.

Most commonly, the data includes a date or timestamp field type that corresponds to Zoomdata’s date field type. Here is a sample SQL query:

select timeField, max(otherField) from myCollection group by timeField

If grouping on time is not supported, some charts will be unavailable for the source.

Supported By Not Supported By
Amazon Redshift
Amazon S3
Apache Drill
Apache Phoenix (+ QS)
Apache Solr
Aurora
BigQuery
Cassandra (Presto)
Cloudera Impala
Elasticsearch 5.0
Elasticsearch 6.0
Flat File
HDFS
Hive
MemSQL
Microsoft SQL Server
MongoDB
MySQL
Oracle
PostgreSQL
Real Time Sales
SAP Hana
SAP IQ
Snowflake
Spark SQL
Teradata
Upload API
Vertica

Cloudera Search

Group By UNIX Time

The connector supports grouping data by an integer field that contains times in Unix (epoch) time.

Supported By Not Supported By
Amazon Redshift
Amazon S3
Apache Drill
Apache Phoenix (+ QS)
Apache Solr
Aurora
BigQuery
Cassandra (Presto)
Cloudera Impala
Flat File
HDFS
Hive
MemSQL
Microsoft SQL Server
MongoDB
MySQL
Oracle
PostgreSQL
SAP Hana
SAP IQ
Snowflake
Spark SQL
Teradata
Upload API
Vertica

Cloudera Search
Elasticsearch 5.0
Elasticsearch 6.0
Real Time Sales

Histogram Floating Point Values

The connector supports the calculations necessary for histogram visualizations with non-integer values, such as floating point (32-bit) and double-precision (64-bit) floating point data types.

Supported By Not Supported By
Amazon Redshift
Amazon S3
Apache Drill
Apache Phoenix (+ QS)
Aurora
BigQuery
Cassandra (Presto)
Cloudera Impala
Elasticsearch 5.0
Elasticsearch 6.0
Flat File
HDFS
Hive
MemSQL
Microsoft SQL Server
MySQL
Oracle
PostgreSQL
Real Time Sales
SAP Hana
SAP IQ
Snowflake
Spark SQL
Teradata
Upload API
Vertica
Apache Solr
Cloudera Search
MongoDB

Histograms

The connector supports the calculations necessary for histogram visualizations with integer values.

Supported By Not Supported By
Amazon Redshift
Amazon S3
Apache Drill
Apache Phoenix (+ QS)
Apache Solr (>=5.3)
Aurora
BigQuery
Cassandra (Presto)
Cloudera Impala
Elasticsearch 5.0
Elasticsearch 6.0
Flat File
HDFS
Hive
MemSQL
Microsoft SQL Server
MySQL
Oracle
PostgreSQL
Real Time Sales
SAP Hana
SAP IQ
Snowflake
Spark SQL
Teradata
Upload API
Vertica
Apache Solr (<5.3)
Cloudera Search
MongoDB


Kerberos Authentication

The connector supports Kerberos authentication.

This feature does not apply to BigQuery or Real Time Sales data stores.

Supported By Not Supported By

Apache Drill
Apache Phoenix
Apache Solr
Cloudera Impala
Cloudera Search
HDFS
Hive
SAP IQ
Amazon Redshift
Amazon S3
Apache Phoenix QS
Aurora
Cassandra (Presto)
Elasticsearch 5.0
Elasticsearch 6.0
Flat File
MemSQL
Microsoft SQL Server
MongoDB
MySQL
Oracle
PostgreSQL
SAP Hana
Snowflake
Spark SQL
Teradata
Upload API
Vertica

Last Value

The connector supports the last value metric in data sources that use it. The last value metric determines and uses the last value of a selected field in the data.

Although many data stores implement a last value function, the Zoomdata last value indicates that the last value in a given field collection can be loaded and used in a visualization immediately.

Supported By Not Supported By
Amazon Redshift
Amazon S3
Apache Drill
Aurora
BigQuery
Cassandra (Presto)
Cloudera Impala
Elasticsearch 5.0
Elasticsearch 6.0
Flat File
HDFS
Hive
MemSQL
Microsoft SQL Server
MySQL
Oracle
PostgreSQL
Real Time Sales
SAP Hana
SAP IQ
Snowflake
Spark SQL
Teradata
Upload API
Vertica

Apache Phoenix (+ QS)
Apache Solr

Cloudera Search
MongoDB

Live Mode/Playback

The connector supports live mode and playback features. The data store can play dates in live mode.

The data store should be capable of receiving new or updated data, that is, data that is not static like flat files. If live sourcing is not supported, the Live Mode checkbox is disabled on the Charts tab of the data source configuration.

Supported By Not Supported By
Amazon Redshift
Apache Drill
Apache Phoenix (+ QS)
Apache Solr
Aurora
BigQuery
Cassandra (Presto)
Cloudera Impala
Cloudera Search
Elasticsearch 5.0
Elasticsearch 6.0
Hive
MemSQL
Microsoft SQL Server
MongoDB
MySQL
Oracle
PostgreSQL
Real Time Sales
SAP Hana
SAP IQ
Snowflake
Spark SQL
Teradata
Upload API
Vertica
Amazon S3
Flat File
HDFS

Multivalued Fields

The connector supports aggregation by multivalued fields, such as maps and objects.

Feature Description Supported By Not Supported By

Multivalued fields

The connector supports aggregation by multivalued fields, such as maps and objects. Apache Solr
Cloudera Search
Elasticsearch 5.0
Elasticsearch 6.0
MongoDB
This feature applies only to search-based connectors.

Nested Fields

The connector supports nested field structures, such as JSON structures.

Supported By Not Supported By

Elasticsearch 5.0
Elasticsearch 6.0
MongoDB
This feature applies only to search-based connectors.

Partitions

FEATURE.PARTITION

The connector supports partitions and pruning. This feature enables the Partition column on the Fields tab of the data source configuration, when the data source uses a supporting connector. Partitioning allows you to link a partitioned field to another field to help improve the performance of filtering operations for a data source.

Although many data stores support partitions in some form, this feature specifically tells Zoomdata that the partitions may be used for manual pruning of result sets to increase speed.

Partitioning does not apply to Apache Phoenix, Flat File, HDFS, MongoDB, Real Time Sales data stores or to any search-based data stores (Apache Solr, Cloudera Search, or Elasticsearch 5.0 or 6.0.

Supported By Not Supported By

Apache Drill
BigQuery
Cloudera Impala
Hive
Spark SQL
Amazon Redshift
Amazon S3
Aurora
Cassandra (Presto)
MemSQL
Microsoft SQL Server
MySQL
Oracle
PostgreSQL
SAP Hana
SAP IQ
Snowflake
Teradata
Upload API
Vertica

Schemas

Indicates whether a connector supports namespace, schema, or catalog notation for organizing collections. If it does, then the Tables/Indices Tab of the data source configuration displays with the Schema drop-down and the Tables list and you can select a schema for the data source configuration. If it does not, then the list of collections displays on the Tables/Indices Tab. Elasticsearch has a custom UI for displaying multiple indices.

This feature does not apply to search-based connectors (Apache Solr, Cloudera Search
, Elasticsearch 5.0, and Elasticsearch 6.0).

Supported By Not Supported By
Amazon Redshift
Amazon S3
Apache Drill
Apache Phoenix (+ QS)
Aurora
BigQuery
Cassandra (Presto)
Cloudera Impala
Flat File
HDFS
Hive
MemSQL
Microsoft SQL Server
MongoDB
MySQL
Oracle
PostgreSQL
Real Time Sales
SAP Hana
SAP IQ
Snowflake
Spark SQL
Teradata
Upload API
Vertica

This feature does not apply to search-based connectors.

Text Search

The connector can perform an efficient search on text fields. If a connector supports this feature, search control is enabled on dashboards using data sources that use the connector and the Lookup Values toggle on the Tables/Indices tab of the data source configuration is available.

Supported By Not Supported By
Apache Solr
Cloudera Search
Elasticsearch 5.0
Elasticsearch 6.0
This feature applies only to search-based connectors.

TLS

The connector supports SSL/TLS.

Note: The following connectors have not been tested for this feature:Amazon Redshift, Apache Drill, Apache Phoenix (+QS), Aurora, Cassandra (Presto), MemSQL, Microsoft SQL Server, MySQL, Oracle,PostgreSQL, SAP Hana, SAP IQ, Snowflake, Teradata, and Vertica

Supported By Not Supported By
Amazon Redshift
Apache Drill
Apache Phoenix (+ QS)
Aurora
Cassandra (Presto)
Cloudera Impala
Cloudera Search
Elasticsearch 5.0
Elasticsearch 6.0
Flat File
Hive
MemSQL
Microsoft SQL Server
MongoDB
MySQL
Oracle
PostgreSQL
SAP Hana
SAP IQ
Snowflake
Teradata
Upload API
Vertica

Amazon S3
Apache Solr
BigQuery
HDFS
Real Time Sales
Spark SQL

User Delegation

The connector supports user delegation (user proxy).

Supported By Not Supported By

Cloudera Impala
Cloudera Search
Hive
Oracle
Amazon Redshift
Amazon S3
Apache Drill
Apache Phoenix (+ QS)
Apache Solr
Aurora
BigQuery
Cassandra (Presto)
Elasticsearch 5.0
Elasticsearch 6.0
Flat File
HDFS
MemSQL
Microsoft SQL Server
MongoDB
MySQL
Oracle
PostgreSQL
SAP Hana
SAP IQ
Snowflake
Spark SQL
Teradata
Upload API
Vertica

Wild Card Filters

The connector supports wild card filters. Case-sensitivity varies depending on the connector's data store. See Wild Card Filters, Case-Insensitive Mode and Wild Card Filters, Case-Sensitive Mode.

Supported By Not Supported By
Amazon Redshift
Amazon S3
Apache Drill
Apache Phoenix (+ QS)
Apache Solr
Aurora
BigQuery
Cassandra (Presto)
Cloudera Impala
Cloudera Search
Elasticsearch 5.0
Elasticsearch 6.0
Flat File
HDFS
Hive
MemSQL
Microsoft SQL Server
MongoDB
MySQL
Oracle
PostgreSQL
Real Time Sales
SAP Hana
SAP IQ
Snowflake
Spark SQL
Teradata
Upload API
Vertica
---

Wild Card Filters, Case-Insensitive Mode

The connector supports wild card filters in case-insensitive mode.

Supported By Not Supported By
Amazon Redshift
Amazon S3
Apache Drill
Apache Phoenix (+ QS)
Aurora
BigQuery
Cassandra (Presto)
Cloudera Impala
Flat File
HDFS
Hive
MemSQL
Microsoft SQL Server
MongoDB
MySQL
Oracle
PostgreSQL
Real Time Sales
SAP Hana
SAP IQ
Snowflake
Spark SQL
Teradata
Upload API
Vertica
Apache Solr
Cloudera Search
Elasticsearch 5.0
Elasticsearch 6.0
Vertica

Wild Card Filters, Case-Sensitive Mode

The connector supports wild card filters in case-sensitive mode.

Supported By Not Supported By
Amazon Redshift
Amazon S3
Apache Drill
Apache Phoenix (+ QS)
BigQuery
Cassandra (Presto)
Cloudera Impala
Flat File
HDFS
Hive
MongoDB
Oracle
PostgreSQL
Real Time Sales
SAP Hana
SAP IQ
Snowflake
Spark SQL
Teradata
Upload API
Vertica
Apache Solr
Aurora
Cloudera Search
Elasticsearch 5.0
Elasticsearch 6.0
MemSQL
Microsoft SQL Server
MySQL

Was this topic helpful?