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. 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. You can also use data sources that utilize many of these connectors in Visual Data Discovery. See Connect to Data and View it on a Dashboard.
Connector Other Support Notes
AccessODBC/JDBC only
Amazon RedshiftDrivers included
Azure Table / Azure Cosmos DBDrivers included
dBase (DBF) database filesDrivers included
BigQueryDrivers included
ExasolDrivers included
ExcelDrivers included
Flat filesDrivers included
Generic Web Data SourcesDrivers included
Google AnalyticsDrivers included
Google SheetsDrivers included
IBM DB2Drivers included
JDBC64-bit JDBC driver for the specific data source
MemSQLDrivers included
Microsoft DataverseDrivers included
Microsoft SQL Server 2005 or higher Including SQL Server Express, Azure SQL,Azure Synapse: Drivers included
MySQLDrivers included
ODataDrivers included
ODBC64-bit ODBC driver for the specific data source
OracleDrivers included
Oracle 11g Essbase Drivers included
PardotDrivers included
PostgreSQL Drivers included
SalesforceDrivers included
SAP HanaDrivers included
SAP NetWeaver BW 7.0 or laterDrivers included; uses XMLA web service.
SharePoint Lists and Excel ServicesDrivers included (online credentials only)
SnowflakeDrivers included
SSAS ( Microsoft SQL Server Analysis Services) Drivers included
TeradataInstall the driver; version 12.0 or later
VerticaODBC/JDBC only
XML FileDrivers included

​
Visual Data Discovery Data Connectors

Create and manage these data connectors when working in the Visual Data Discovery module. You can also use data sources that utilize these connectors in Managed Dashboards and Reports in Symphony.
Important: You can use a Managed Dashboard connection as a data source or in a fusion data source in Visual Data Discovery. See Add and validate a connection to a data cube.
Connector Data Discovery MicroserviceSupported VersionsData Discovery Connector PortOther Actions Required & Notes
Amazon Redshiftzoomdata-edc-redshift1.08202Install JDBC driver.
Amazon S3zoomdata-edc-s38129Separate download.
Apache Drillzoomdata-edc-drill1.14 - 1.168095Separate download.
Apache Phoenixzoomdata-edc-phoenix-4.74.78124Apache Phoenix 4.4 and 4.5 require separate downloads.
Apache Phoenix Query Server (QS)zoomdata-edc-phoenix-4.7-queryserver4.78125


Apache Solrzoomdata-edc-apache-solr7.4 - 8.4 8115
BigQueryzoomdata-edc-bigquery8093
Business Centralzoomdata-edc-businesscentral-jetN/A8156Separate download.
Cloudera Impalazoomdata-edc-impala3.2 - 3.48098
Cloudera Searchzoomdata-edc-cloudera-search4.10 - 7.48201
Couchbasezoomdata-edc-couchbase6.0.18138Includes Couchbase Community Edition 6.0.0.
Dremiozoomdata-edc-dremio4.1 through 4.88142
Elasticsearch 7.0zoomdata-edc-elasticsearch-7.07.0 - 7.178139
Elasticsearch 8.0zoomdata-edc-elasticsearch-8-08.1 - 8.38147
HDFSzoomdata-edc-hdfs8126Separate download.
Hivezoomdata-edc-hive2.1 - 3.18132
Jira Connectorzoomdata-edc-jiraJira JDBC Driver 1.7.8.10028151Separate download.
MemSQLzoomdata-edc-memsql7.1 - 7.68099Install JDBC driver.
Microsoft SQL Serverzoomdata-edc-mssql12.0 (SQL Server 2014) - 16.0 (SQL Server 2022)8100
MongoDBzoomdata-edc-mongo3.4 - 4.48123
MySQLzoomdata-edc-mysql5.6 - 8.08101Install JDBC driver.
Oraclezoomdata-edc-oracle11.2 - 21c8102Install JDBC driver.
PostgreSQLzoomdata-edc-postgresql9.6 - 14.08105
Pythonzoomdata-edc-python8153Install Docker image. See Manage the Python Connector.
Real Time Saleszoomdata-edc-rts8108Must be enabled.
Salesforcezoomdata-edc-salesforceSimba Salesforce JDBC Driver 2.1.228152Separate download.
SAP Hanazoomdata-edc-saphana2.08109Separate download and install JDBC driver.
SAP S/4HANAzoomdata-edc-saphanacloudN/A8205Separate download and install JDBC driver.
SAP IQzoomdata-edc-sapiq168121Separate download and install JDBC driver.
Snowflakezoomdata-edc-snowflakewhatever is currently supported in the cloud8131Separate download.
Spark SQLzoomdata-edc-sparksql2.3 - 3.08116
Teradatazoomdata-edc-teradata16.208111Separate download and install JDBC driver.
TIBCO DVzoomdata-edc-tibcodv8.0-8.18140

Separate download and install JDBC driver.

The default TDV server port for JDBC connections is 9401.

Trinozoomdata-edc-trino351-3908148Separate download.
Verticazoomdata-edc-vertica7.28112Separate 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.