Data Connector Reference
Symphony data connectors are used to connect to your data stores. Each data connector has capabilities and limitations when connected to the Symphony 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 Symphony installation, see Obtain Additional Connector Servers.
The connectors below are organized for use in Data Discovery dashboards, Managed Dashboards, and Managed Reports.
Some connectors can only be used in managed dashboards, reports, visualizations, and more.
All connectors that work in data discovery dashboards and visuals can also be used in managed dashboards, reports, visualizations and more using the ODBC connector to data discovery.
Managed Dashboards and Reports Data Connectors
Create and manage these data connectors when working in the Managed Dashboards or Managed Reports modules. Some additional connectors are available from Visual Data Discovery, but management of these connectors is in the Visual Data Discovery module.
Visual Data Discovery Data Connectors
Create and manage these data connectors when working in the Visual Data Discovery module.
Connector | Data Discovery Microservice | Supported Versions | Data Discovery 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 | |
| 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 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 Symphony connectors listed above, Symphony allows you to:
- Upload a flat file for viewing in visuals and dashboards.
- Dynamically upload and stream your data in real time using the Symphony 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 Symphony.