Navigate
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.
In addition to the official Composer connectors listed above, Composer allows you to:
| 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. |
- Upload a flat file for viewing in visuals and dashboards.
- Dynamically upload and stream your data in real time using the Composer Upload API.