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

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