(v24) Data Connector Reference

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.

Important: You can use a Managed Dashboard connection as a data source or in a fusion data source in Visual Data Discovery. This feature is currently in beta and should not be used in production environments at this time. See Add and validate a connection to a data cube.

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.

See Connect to Data and View it on a Dashboard.

Connector	Other Support Notes
Access	ODBC/JDBC only
Amazon Redshift	Drivers included
Azure Table / Azure Cosmos DB	Drivers included
dBase (DBF) database files	Drivers included
BigQuery	Drivers included
Exasol	Drivers included
Excel	Drivers included
Flat files	Drivers included
Generic Web Data Sources	Drivers included
Google Analytics	Drivers included
Google Sheets	Drivers included
IBM DB2	Drivers included
JDBC	64-bit JDBC driver for the specific data source
MemSQL	Drivers included
Microsoft Dataverse	Drivers included
Microsoft SQL Server 2005 or higher Including SQL Server Express, Azure SQL, Azure Synapse	Drivers included
MySQL	Drivers included
OData	Drivers included
ODBC	64-bit ODBC driver for the specific data source
Oracle	Drivers included
Pardot	Drivers included
PostgreSQL	Drivers included
Salesforce	Drivers included
SAP Hana	Drivers included
SAP NetWeaver BW 7.0 or later	Drivers included; uses XMLA web service.
SharePoint Lists and Excel Services	Drivers included (online credentials only)
Snowflake	Drivers included
SSAS
Teradata	Install the driver; version 12.0 or later
Vertica	ODBC/JDBC only
XML File	Drivers included

Visual Data Discovery Data Connectors

Create and manage these data connectors when working in the Visual Data Discovery module.

Important: You can use a Managed Dashboard connection as a data source or in a fusion data source in Visual Data Discovery. This feature is currently in beta and should not be used in production environments at this time. See Add and validate a connection to a data cube.

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 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 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.