Zoomdata Version

Data Connector Reference

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.

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.11 - 1.13 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 4.10.0 - 7.4.0 8115 No
Aurora ---   Deprecated. Use the MySQL connector.
BigQuery   8093 Separate download
Cassandra over Presto 0.132 8107 Separate download; uses the Presto 0.132 connector.
Cloudera Impala 2.5.0 - 2.12.0 8098 No
Cloudera Search 4.4.0 - 4.10.3 8201 No
Elasticsearch 5.0 5.0 - 5.6 8117 No
Elasticsearch 6.0 6.0 - 6.1 8118 No (as of 2.6.5)
Flat File     PostgreSQL must be enabled
HDFS   8126 Separate download
Hive 2.1 - 3.1 8132 No
MemSQL 5.0 - 6.0 8099 Install JDBC driver
Microsoft SQL Server 11.0.21 - 14.0.1000 8100 No (as of 2.6.5)
MongoDB 3.4.0 - 4.0.2 8123 No
MySQL 5.6 8101 Install JDBC driver
Oracle 11.2 8102 Install JDBC driver
PostgreSQL 9.3.1 - 9.6.0 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.0.0 - 2.2.0 8116 No
Teradata 16.20 8111 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?