Zoomdata Version

Data Connector Reference

Zoomdata data connectors are used to connect to your data stores. Each data connector has capabilities and limitations when connected to the Zoomdata server. This topic highlights those details and provides a link to more information about each connector. For information about setting the parameters required by a connector to connect to a data store, see Managing Data Store Connections. For information on how to download and install a connector that is not provided in the default Zoomdata installation, see Obtaining Additional Connector Servers.

Data Source Supported Versions Connector Port Requires Other Action
Amazon Redshift 1.0.1 8202 Install JDBC driver
Amazon S3   8129 Separate download
Apache Drill 1.14 - 1.16 8095 Separate download
Apache Phoenix 4.7 8124 No; Apache Phoenix 4.4 and 4.5 require separate downloads
Apache Phoenix Query Server (QS) 4.7 8125 No
Apache Solr 6.6 - 8 8115 No
Aurora --- --- Deprecated. Use the MySQL connector to connect to your Aurora databases.
BigQuery   8093 Separate download
Cassandra over Presto 0.132 8107 Separate download; uses the Presto 0.132 connector.
Cloudera Impala 2.7 - 3.2 8098 No
Cloudera Search 4.4 - 7.4 8201 No
Couchbase 6.0.1 8138  
Elasticsearch 6.0 6.0 - 6.7 8118 No (as of 2.6.5)
Elasticsearch 7.0 7.0 - 7.1 8139 No
Flat File     PostgreSQL must be enabled
HDFS   8126 Separate download
Hive 2.1 - 3.1 8132 No
MemSQL 6.0 - 6.7 8099 Install JDBC driver
Microsoft SQL Server 2008 and later (specifically, versions 10.5 - 14.0.1000) 8100 No (as of 2.6.5)
MongoDB 3.4 - 4.2 8123 No
MySQL 5.6 8101 Install JDBC driver
Oracle 11.2 - 18.3 8102 Install JDBC driver
PostgreSQL 9.4 - 11.1 8105 No
Real Time Sales   8108 Must be enabled
SAP Hana 2.0 8109 Separate download and install JDBC driver
SAP IQ 16 8121 Separate download and install JDBC driver
Snowflake whatever is currently supported in the cloud 8131 Separate download
Spark SQL 2.3 - 2.4 8116 No
Teradata 16.20 8111 Separate download and install JDBC driver
TIBCO DV 8.0-8.1 8140 Separate download and install JDBC driver
Upload API     PostgreSQL must be enabled
Vertica 7.2 8112 Separate download and install JDBC driver

Was this topic helpful?