Composer 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.

Data Source Microservice Supported Versions Connector Port Requires Other Action
Amazon Redshift zoomdata-edc-redshift 1.0 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 No; Apache Phoenix 4.4 and 4.5 require separate downloads
Apache Phoenix Query Server (QS) zoomdata-edc-phoenix-4.7-queryserver 4.7 8125 No
Apache Solr zoomdata-edc-apache-solr 7.4 - 8.4.1 8115 No
Aurora --- --- --- Deprecated. Use the MySQL connector to connect to your Aurora databases.
BigQuery zoomdata-edc-bigquery   8093  
Cloudera Impala zoomdata-edc-impala 2.7 - 3.2 8098 No
Cloudera Search zoomdata-edc-cloudera-search 4.4 - 7.4 8201 No
Couchbase zoomdata-edc-couchbase 6.0.1 8138  
Couchbase Community Edition 6.0.0 ---  
Elasticsearch 6.0 zoomdata-edc-elasticsearch-6.0 6.0 - 6.7 8118 No (as of 2.6.5)
Elasticsearch 7.0 zoomdata-edc-elasticsearch-7.0 7.0 - 7.6 8139 No
Flat File ---     PostgreSQL must be enabled
HDFS zoomdata-edc-hdfs   8126 Separate download
Hive zoomdata-edc-hive 2.1 - 3.1 8132 No
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 No (as of 2.6.5)
MongoDB zoomdata-edc-mongo 3.4 - 4.2 8123 No
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 No
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 No
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
Upload API ---     PostgreSQL must be enabled
Vertica zoomdata-edc-vertica 7.2 8112 Separate download and install JDBC driver