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:

Fused data sources inherit the limitations of the underlying connectors used by the fused sources. In addition, fused sources have other feature limitations. See Data Fusion Limitations.

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
Couchbase
Flat File
HDFS
Hive
MemSQL
Microsoft SQL Server
MySQL
Oracle
PostgreSQL
SAP Hana
SAP IQ
Snowflake
Spark SQL
Teradata
TIBCO DV
Upload API
Apache Solr
Cloudera Search
Elasticsearch
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
BigQuery
Cassandra (Presto)
Cloudera Impala
Elasticsearch
Flat File
HDFS
Hive
MemSQL
Microsoft SQL Server
Oracle
PostgreSQL
Real Time Sales
SAP Hana
SAP IQ
Snowflake
Spark SQL
Teradata
TIBCO DV
Upload API
Vertica

Apache Phoenix (+ QS)
Aurora
Cloudera Search
Couchbase
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, Couchbase, 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
TIBCO DV
Vertica

Amazon S3
BigQuery
Couchbase
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
BigQuery
Cloudera Impala
Couchbase
Elasticsearch
Flat File
HDFS
Hive
MemSQL
Microsoft SQL Server
MongoDB (partial)
MySQL
Oracle
PostgreSQL
Real Time Sales
SAP Hana
SAP IQ
Snowflake
Spark SQL
Teradata
TIBCO DV
Upload API

Apache Solr
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
Couchbase
Elasticsearch
Flat File
HDFS
Hive
Microsoft SQL Server
MongoDB
MySQL
Oracle
PostgreSQL
Real Time Sales
SAP Hana
SAP IQ
Snowflake
Spark SQL
Teradata
TIBCO DV
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 refresh the data 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
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
Aurora
BigQuery
Cassandra (Presto)
Cloudera Impala
Couchbase
Elasticsearch
Flat File
HDFS
Hive
MemSQL
Microsoft SQL Server
MongoDB
MySQL
Oracle
PostgreSQL
Real Time Sales
SAP Hana
SAP IQ
Snowflake
Spark SQL
Teradata
TIBCO DV
Upload API
Vertica
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
Couchbase
Elasticsearch
Flat File
HDFS
Hive
MemSQL
Microsoft SQL Server
MongoDB
MySQL
Oracle
PostgreSQL
Real Time Sales
SAP Hana
SAP IQ
Snowflake
Spark SQL
Teradata
TIBCO DV
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
Couchbase
Flat File
HDFS
Hive
MemSQL
Microsoft SQL Server
MongoDB
MySQL
Oracle
PostgreSQL
SAP Hana
SAP IQ
Snowflake
Spark SQL
Teradata
TIBCO DV
Upload API
Vertica

Cloudera Search
Elasticsearch
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
Couchbase
Elasticsearch
Flat File
HDFS
Hive
MemSQL
Microsoft SQL Server
MySQL
Oracle
PostgreSQL
Real Time Sales
SAP Hana
SAP IQ
Snowflake
Spark SQL
Teradata
TIBCO DV
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
Aurora
BigQuery
Cassandra (Presto)
Cloudera Impala
Couchbase
Elasticsearch
Flat File
HDFS
Hive
MemSQL
Microsoft SQL Server
MySQL
Oracle
PostgreSQL
Real Time Sales
SAP Hana
SAP IQ
Snowflake
Spark SQL
Teradata
TIBCO DV
Upload API
Vertica
Cloudera Search
MongoDB

Kerberos Authentication

The connector supports Kerberos authentication.

This feature does not apply to BigQuery, Couchbase, or Real Time Sales data stores and connectors.

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
Flat File
MemSQL
Microsoft SQL Server
MongoDB
MySQL
Oracle
PostgreSQL
SAP Hana
Snowflake
Spark SQL
Teradata
TIBCO DV
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
Flat File
HDFS
Hive
MemSQL
Microsoft SQL Server
MySQL
Oracle
PostgreSQL
Real Time Sales
SAP Hana
SAP IQ
Snowflake
Spark SQL
Teradata
TIBCO DV
Upload API
Vertica

Apache Phoenix (+ QS)
Apache Solr
Cloudera Search
Couchbase
MongoDB

Live Mode/Playback

The connector supports live mode and playback features. The data store can show data in live mode or historical playback.

Live mode and historical playback (also know as Data DVR) allow you to get the most from data sources using connectors that support them. The only difference between live mode and historical playback is the time range that is selected:

  • Live mode refreshes field data on your charts for fields that are indexed as playable. In live mode, your data plays forever without an end date.
  • Historical playback (Data DVR) shows the historical record of field data for fields that are indexed as playable. Playback can show up to the last moment before the current period in your data.

Live mode and historical playback require an index or partition field. The data store should be capable of receiving new or updated data, that is, data that is not static like flat files. If the data store does not support indexing or partitioning, then live mode and historical playback are not available. For most data stores, indexing is the default.

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

Multivalued Fields

The connector supports aggregation by multivalued fields, such as arrays.

The Couchbase connector supports multivalued fields with some limitations. See Managing the Couchbase Connector.

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

Nested Fields

The connector supports nested field structures, such as maps and objects.

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

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, TIBCO DV data stores or to any search-based data stores (Apache Solr, Cloudera Search, or Elasticsearch).

Supported By Not Supported By

Apache Drill
BigQuery
Cloudera Impala
Hive
Spark SQL
Amazon Redshift
Amazon S3
Aurora
Cassandra (Presto)
Couchbase
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, and Elasticsearch).

Supported By Not Supported By
Amazon Redshift
Amazon S3
Apache Drill
Apache Phoenix (+ QS)
Aurora
BigQuery
Cassandra (Presto)
Cloudera Impala
Couchbase
Flat File
HDFS
Hive
MemSQL
Microsoft SQL Server
MongoDB
MySQL
Oracle
PostgreSQL
Real Time Sales
SAP Hana
SAP IQ
Snowflake
Spark SQL
Teradata
TIBCO DV
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
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, 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
Couchbase
Elasticsearch
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
TIBCO DV

User Delegation

The connector supports user delegation (user proxy).

Supported By Not Supported By

Apache Drill
Cloudera Impala
Cloudera Search
Hive
Oracle
Amazon Redshift
Amazon S3
Apache Phoenix (+ QS)
Apache Solr
Aurora
BigQuery
Cassandra (Presto)
Couchbase
Elasticsearch
Flat File
HDFS
MemSQL
Microsoft SQL Server
MongoDB
MySQL
PostgreSQL
SAP Hana
SAP IQ
Snowflake
Spark SQL
Teradata
TIBCO DV
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
Couchbase
Elasticsearch
Flat File
HDFS
Hive
MemSQL
Microsoft SQL Server
MongoDB
MySQL
Oracle
PostgreSQL
Real Time Sales
SAP Hana
SAP IQ
Snowflake
Spark SQL
Teradata
TIBCO DV
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
Couchbase
Flat File
HDFS
Hive
MemSQL
Microsoft SQL Server
MongoDB
MySQL
Oracle
PostgreSQL
Real Time Sales
SAP Hana
SAP IQ
Snowflake
Spark SQL
Teradata
TIBCO DV
Upload API
Vertica
Apache Solr
Cloudera Search
Elasticsearch
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
Couchbase
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
MemSQL
Microsoft SQL Server
MySQL
TIBCO DV

Was this topic helpful?