Zoomdata Version

Data Sources Quick Reference Sheet: Capabilities and Limitations

Zoomdata connects to a variety of data sources from Cloudera to Search to SQL-based databases and flat files.

Each data connector has capabilities and limitations when connected to the Zoomdata Server. These details include the following:

  • The data source version that is supported (and tested) by Zoomdata, if applicable; the default status of the connector: enabled or disabled.
  • Whether the following functionalities are supported:
    • Distinct count
    • Live Mode/Playback capability
    • SparkIt
    • Group-by time
    • Multi-group by visuals
    • Histogram Charts
    • Plot Charts
    • Custom SQL
    • Last Value
    • Partition

The capabilities and limitations are broken out into the following tables below:

Table 1: List of Tables

Table Description
2
  • The data source version supported by Zoomdata
  • ​Default status of the connector
3
  • Distinct count support
  • Live mode/playback capable
4
  • SparkIt capable
  • Group-by time
  • Multi-group by visuals
  • Supports histogram charts
  • Supports plot charts
  • Custom SQL capable
  • Supports last value
  • Supports partitions

Table 2: Data Sources Supported Version

(Only data sources with a known supported version number are listed.)
Data Source Supported Version Enabled by Default
Amazon Redshift 1.0.1+ Yes
Apache Phoenix* 4.4 - 4.5 Yes
Apache Solr 4.4 - 5.3 Yes
Cloudera Impala 2.0.0 - 2.7.0 Yes
Cloudera Search 4.4 - 5.3 Yes
Elastic Search 1.7 1.4.1 - 1.7.5 Yes
Elastic Search 2.x 2.0.0 - 2.4.3 Yes
Google Analytics Core Reporting API Version 3.0 Yes
HDFS CDH4+ Yes
Hive on Tez 1.1.0 - 1.2.1 Yes
Marketo REST API Version 1 No
MemSQL 3.2.0 - 5.0.3 Yes
MongoDB 2.6. - 3.4 Yes
MySQL 5.6 + Yes
Oracle 11.1 + Yes
PostgreSQL 9.3.1 + Yes
Salesforce Metadata API Version 34 No
SendGrid REST API v3 No
Spark SQL 1.5.2-1.6.1 Yes
SQL Server 11.0.21 + Yes
Zendesk REST API v2 No
Teradata* 13.1 - 15.1 Yes
Apache Drill* 1.4.0 - 1.7.0 Yes
Presto for Cassandra* 0.105, 0.132 Yes
*Additional supported connectors you can install; contact Zoomdata Technical Support to request.

Table 3: Distinct Count, Live Mode/Playback

Data Source Supports Distinct Count? Supports Live Mode/Playback?
Amazon Aurora Yes Yes
Amazon Redshift Yes Yes
Apache Phoenix Yes Yes
Apache Solr No Yes
Cloudera Impala Yes* Yes
Cloudera Search No Yes
Elasticsearch No Yes
Flat Files
(CSV, JSON, TSV, XML)
Yes No
HDFS Yes* No
Hive on Tez Yes Yes
Marketo Yes No
MemSQL Yes Yes
MongoDB Yes Yes
MySQL Yes** Yes
Oracle Yes** Yes
PostgreSQL Yes** Yes
S3 Yes* No
Salesforce Yes No
SendGrid Yes No
Spark SQL Yes** Yes
SQL Server Yes** Yes
Zendesk Yes No
Upload API Yes Yes
Apache Drill*** Yes Yes
Presto for Cassandra*** Yes Yes
Vertica*** Yes Yes
Teradata*** Yes Yes
BigQuery*** Yes Yes
  • *For Impala , S3 , and HDFS , only one Distinct Count metric is supported per chart.
  • **When SparkIt is enabled for SQL connectors, only one Distinct Count metric is supported per chart.
  • ***Additional supported connectors you can install; contact Zoomdata Technical Support to request.

Table 4: SparkIt Capable, Group-by Time, Multi-Group-By Visual, Box Plot, Histogram, and Partition  Support

Data Source

SparkIt Capable?

Supports Group-by Time?

Supports Multi-Group By Charts?

Supports Histogram Charts

Supports Box Plot Charts

Custom SQL

Last Value

Partition

Amazon Aurora Yes Yes Yes Yes No Yes No No
Amazon Redshift No Yes Yes Yes Yes Yes No No
Apache Phoenix Yes Yes Yes Yes No Yes No No
Apache Solr No Yes Partially** Yes Partially*** No No No
Cloudera Impala Yes Yes Yes Yes Yes Yes Yes Yes
Cloudera Search No No No No No No No No
Elasticsearch No Yes Yes Yes Yes No No No
Flat Files
(CSV, JSON, TSV, XML)
No Yes Yes No No No No No
Google Analytics Yes, required Yes Yes Yes No No No No
HDFS Yes, required Yes Yes Yes No No No No
Hive on Tez Yes Yes Yes Yes Yes Yes Yes Yes
Marketo Yes, required Yes Yes Yes No No No No
MemSQL Yes Yes Yes Yes Yes Yes No No
MongoDB No Yes Yes No No No No No
MySQL Ye Yes Yes Yes No Yes No No
Oracle Yes Yes Yes Yes Yes Yes No No
PostgresSQL Yes Yes Yes Yes Yes Yes No No
S3 Yes Yes Yes Yes No No No No
Salesforce Yes, required Yes Yes Yes No No No No
SendGrid Yes, required Yes Yes Yes No No No No
Spark SQL No Yes Yes Yes Yes Yes No Yes
SQL Server Yes Yes Yes Yes Yes Yes No No
Zendesk Yes, required Yes Yes Yes No No No No
Upload API* No Yes Yes No No No No No
Apache Drill**** Yes Yes Yes Yes Yes Yes No Yes
Presto for Cassandra***** Yes Yes Yes Yes Yes Yes No No
Vertica**** Yes Yes Yes Yes Yes Yes Yes No
Teradata**** Yes Yes Yes Yes Yes Yes Yes No
BigQuery**** Yes Yes Yes Yes No No No Yes
  • *Group-by Time is not supported for live/streaming sources.
  • **Solr v5.2 and later versions support Group-by Time; older versions do not.
  • ***Limitations apply.
  • ****Additional supported connectors you can install; contact Zoomdata Technical Support to request.