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 |
Comments
0 comments
Please sign in to leave a comment.