Composer v6 Data Connector Reference

Composer data connectors are used to connect to your data stores. Each data connector has capabilities and limitations when connected to the Composer 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 Composer installation, see Obtaining Additional Connector Servers.

Connector Microservice Supported Versions Connector Port Other Actions Required & Notes
Amazon Redshift zoomdata-edc-redshift 1.0.1 8202 Install JDBC driver
Amazon S3 zoomdata-edc-s3   8129 Separate download
Apache Drill zoomdata-edc-drill 1.14 - 1.16 8095 Separate download
Apache Phoenix zoomdata-edc-phoenix-4.7 4.7 8124 Apache Phoenix 4.4 and 4.5 require separate downloads
Apache Phoenix Query Server (QS) zoomdata-edc-phoenix-4.7-queryserver 4.7 8125
Apache Solr zoomdata-edc-apache-solr 7.4 - 8.4 8115  
BigQuery zoomdata-edc-bigquery   8093 Separate download
Cloudera Impala zoomdata-edc-impala 2.7 - 3.2 8098  
Cloudera Search zoomdata-edc-cloudera-search 4.10 - 7.4 8201  
Couchbase zoomdata-edc-couchbase 6.0.1 8138

Includes Couchbase Community Edition 6.0.0

Dremio zoomdata-edc-dremio 4.1 through 4.8 8142  
Elasticsearch 6.0 zoomdata-edc-elasticsearch-6.0 6.0 - 6.7 8118  
Elasticsearch 7.0 zoomdata-edc-elasticsearch-7.0 7.0 - 7.6 8139  
HDFS zoomdata-edc-hdfs   8126 Separate download
Hive zoomdata-edc-hive 2.1 - 3.1 8132  
MemSQL zoomdata-edc-memsql 6.0 - 6.7 8099 Install JDBC driver
Microsoft SQL Server zoomdata-edc-mssql 2008 R2 and 2019 (specifically, versions 10.5 - 15.0.2000) 8100  
MongoDB zoomdata-edc-mongo 3.4 - 4.2 8123  
MySQL zoomdata-edc-mysql 5.6 8101 Install JDBC driver
Oracle zoomdata-edc-oracle 11.2 - 18.3 8102 Install JDBC driver
PostgreSQL zoomdata-edc-postgresql 9.4 - 12.1 8105  
Presto zoomdata-edc-presto 319 8107 Separate download; used to connect to Cassandra databases.
Real Time Sales zoomdata-edc-rts   8108 Must be enabled
SAP Hana zoomdata-edc-saphana 2.0 8109 Separate download and install JDBC driver
SAP IQ zoomdata-edc-sapiq 16 8121 Separate download and install JDBC driver
Snowflake zoomdata-edc-snowflake whatever is currently supported in the cloud 8131 Separate download
Spark SQL zoomdata-edc-sparksql 2.3 - 2.4 8116  
Teradata zoomdata-edc-teradata 16.20 8111 Separate download and install JDBC driver
TIBCO DV zoomdata-edc-tibcodv 8.0-8.1 8140

Separate download and install JDBC driver

The default TDV server port for JDBC connections is 9401.

Vertica zoomdata-edc-vertica 7.2 8112 Separate download and install JDBC driver

In addition to the official Composer connectors listed above, Composer allows you to :

  • Upload a flat file for viewing in visuals and dashboards.
  • Dynamically upload and stream your data in real time using the ComposerUpload API .

Both the flat file uploads and the Upload API use port 8105 and require that PostgreSQL be enabled. While these processes are not strictly data connectors, they are additional methods of providing data for Composer.