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 Manage Data Discovery Data Store Connections. For information on how to download and install a connector that is not provided in the default Composer installation, see Obtain Additional Connector Servers.

Connector	Microservice	Supported Versions	Connector Port	Other Actions Required & Notes
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	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
Business Central	zoomdata-edc-businesscentral-jet	N/A	8156	Separate download.
Cloudera Impala	zoomdata-edc-impala	3.2 - 3.4	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 7.0	zoomdata-edc-elasticsearch-7.0	7.0 - 7.17	8139
Elasticsearch 8.0	zoomdata-edc-elasticsearch-8-0	8.1 - 8.3	8147
HDFS	zoomdata-edc-hdfs		8126	Separate download.
Hive	zoomdata-edc-hive	2.1 - 3.1	8132
Jira Connector	zoomdata-edc-jira	Jira JDBC Driver 1.7.8.1002	8151	Separate download.
MemSQL	zoomdata-edc-memsql	7.1 - 7.6	8099	Install JDBC driver.
Microsoft SQL Server	zoomdata-edc-mssql	12.0 (SQL Server 2014) - 16.0 (SQL Server 2022)	8100
MongoDB	zoomdata-edc-mongo	3.4 - 4.4	8123
MySQL	zoomdata-edc-mysql	5.6 - 8.0	8101	Install JDBC driver.
Oracle	zoomdata-edc-oracle	11.2 - 21c	8102	Install JDBC driver.
PostgreSQL	zoomdata-edc-postgresql	9.6 - 14.0	8105
Python	zoomdata-edc-python		8153	Install Docker image. See Manage the Python Connector.
Real Time Sales	zoomdata-edc-rts		8108	Must be enabled.
Salesforce	zoomdata-edc-salesforce	Simba Salesforce JDBC Driver 2.1.22	8152	Separate download.
SAP Hana	zoomdata-edc-saphana	2.0	8109	Separate download and install JDBC driver.
SAP S/4HANA	zoomdata-edc-saphanacloud	N/A	8205	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 - 3.0	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.
Trino	zoomdata-edc-trino	351-390	8148	Separate download.
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 Composer Upload 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.