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 Manage 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 | ||
| 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 | |
| MemSQL | zoomdata-edc-memsql | 7.1 - 7.6 | 8099 | Install JDBC driver |
| Microsoft SQL Server | zoomdata-edc-mssql | 12.0 (SQL Server 2014) - 15.0 (SQL Server 2019) | 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 | |
| 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 - 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.
Comments
0 comments
Please sign in to leave a comment.