> ## Documentation Index
> Fetch the complete documentation index at: https://insightsoftware-preview.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Data Connector Reference

<a id="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.

<Warning>
  **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.
</Warning>

<a id="managed-dashboards-and-reports-data-connectors" />

## 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](#visual-data-discovery-data-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](/logi-symphony/symphony/v25/navigate/connect_to_data_and_view_it_on_a_dashboard).

<table border="1" data-mc-conditions="Logi_Conditions.b-SymphonyOnly"><colgroup><col /><col data-mc-conditions="" /></colgroup><thead><tr><th scope="col">      Connector     </th><th><p>Other Support Notes </p></th></tr></thead><tbody><tr><td><p>Access</p></td><td>ODBC/JDBC only</td></tr><tr><td><p>Amazon Redshift</p></td><td>Drivers included</td></tr><tr><td><p>Azure Table / Azure Cosmos DB</p></td><td>Drivers included</td></tr><tr><td>dBase (DBF) database files</td><td>Drivers included</td></tr><tr><td><p>BigQuery</p></td><td>Drivers included</td></tr><tr><td><p>Exasol</p></td><td>Drivers included</td></tr><tr><td><p>Excel</p></td><td>Drivers included</td></tr><tr><td><p>Flat files</p></td><td>Drivers included</td></tr><tr><td><p>Generic Web Data Sources</p></td><td>Drivers included</td></tr><tr><td><p>Google Analytics</p></td><td>Drivers included</td></tr><tr><td><p>Google Sheets</p></td><td>Drivers included</td></tr><tr><td><p>IBM DB2</p></td><td>Drivers included</td></tr><tr><td><p>JDBC</p></td><td><p>64-bit JDBC driver for the specific data source</p></td></tr><tr data-mc-conditions=""><td><p>MemSQL</p></td><td>Drivers included</td></tr><tr><td><p>Microsoft Dataverse</p></td><td>Drivers included</td></tr><tr><td><p>Microsoft SQL Server 2005 or higher Including SQL Server Express, Azure SQL, <b>Azure Synapse</b></p></td><td>Drivers included</td></tr><tr data-mc-conditions=""><td><p>MySQL</p></td><td>Drivers included</td></tr><tr><td><p>OData</p></td><td>Drivers included</td></tr><tr><td><p>ODBC</p></td><td><p>64-bit ODBC driver for the specific data source</p></td></tr><tr data-mc-conditions=""><td><p>Oracle</p></td><td>Drivers included</td></tr><tr><td>Oracle 11g Essbase</td><td>	Drivers included</td></tr><tr><td><p>Pardot</p></td><td>Drivers included</td></tr><tr data-mc-conditions=""><td><p>PostgreSQL                        </p></td><td>Drivers included</td></tr><tr><td><p>Salesforce</p></td><td>Drivers included</td></tr><tr data-mc-conditions=""><td><p>SAP Hana</p></td><td>Drivers included</td></tr><tr data-mc-conditions=""><td><p>SAP NetWeaver BW 7.0 or later</p></td><td><p>Drivers included; uses [XMLA web service](https://help.sap.com/saphelp_gbt10/helpdata/EN/9f/9b8f3c855f0454e10000000a11405a/content.htm?no_cache=true).</p></td></tr><tr><td><p>SharePoint Lists and Excel Services</p></td><td><p>Drivers included (online credentials only)</p></td></tr><tr><td><p>Snowflake</p></td><td>Drivers included</td></tr><tr data-mc-conditions=""><td><p>SSAS ( Microsoft SQL Server Analysis Services) </p></td><td>Drivers included</td></tr><tr><td><p>Teradata</p></td><td>Install the driver; version 12.0 or later</td></tr><tr><td><p>Vertica</p></td><td>ODBC/JDBC only</td></tr><tr><td><p>XML File</p></td><td>Drivers included</td></tr></tbody></table>

<a id="visual-data-discovery-data-connectors" />

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

<Warning>
  **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.
</Warning>

<table border="1"><colgroup><col /><col /><col /><col /><col /></colgroup><thead><tr><th scope="col"><p>      Connector     </p></th><th><p>Data Discovery Microservice</p></th><th><p>Supported Versions</p></th><th><p>Data Discovery Connector Port</p></th><th><p>Other Actions Required & Notes</p></th></tr></thead><tbody><tr><td><p>Amazon Redshift</p></td><td><p>`zoomdata-edc-redshift`</p></td><td><p>1.0</p></td><td><p>8202</p></td><td><p>Install JDBC driver.</p></td></tr><tr><td><p>Amazon S3</p></td><td><p>`zoomdata-edc-s3`</p></td><td><p /></td><td><p>8129</p></td><td><p>Separate download.</p></td></tr><tr><td><p>Apache Drill</p></td><td><p>`zoomdata-edc-drill`</p></td><td><p>1.14 - 1.16</p></td><td><p>8095</p></td><td><p>Separate download.</p></td></tr><tr><td><p>Apache Phoenix</p></td><td><p>`zoomdata-edc-phoenix-4.7`</p></td><td><p>4.7</p></td><td><p>8124</p></td><td><p>Apache Phoenix 4.4 and 4.5 require separate downloads.<br /></p></td></tr><tr><td><p>Apache Phoenix Query Server (QS)</p></td><td><p>`zoomdata-edc-phoenix-4.7-queryserver`</p></td><td><p>4.7</p></td><td><p>8125</p></td><td><p /><br /></td></tr><tr><td><p>Apache Solr</p></td><td><p>`zoomdata-edc-apache-solr`</p></td><td><p>7.4 - 8.4 </p></td><td><p>8115</p></td><td><p /></td></tr><tr><td><p>BigQuery</p></td><td><p>`zoomdata-edc-bigquery`</p></td><td><p /></td><td><p>8093</p></td><td><p /></td></tr><tr><td><p>Business Central</p></td><td><p>`zoomdata-edc-businesscentral-jet`</p></td><td>N/A</td><td>8156</td><td>Separate download.</td></tr><tr><td><p>Cloudera Impala</p></td><td><p>`zoomdata-edc-impala`</p></td><td><p>3.2 - 3.4</p></td><td><p>8098</p></td><td><p /></td></tr><tr><td><p>Cloudera Search</p></td><td><p>`zoomdata-edc-cloudera-search`</p></td><td><p>4.10 - 7.4</p></td><td><p>8201</p></td><td><p /></td></tr><tr><td><p>Couchbase</p></td><td><p>`zoomdata-edc-couchbase`</p></td><td><p>6.0.1</p></td><td><p>8138</p></td><td><p>Includes Couchbase Community Edition 6.0.0.</p></td></tr><tr><td><p>Dremio</p></td><td><p>`zoomdata-edc-dremio`</p></td><td><p>4.1 through 4.8</p></td><td><p>8142</p></td><td><p /></td></tr><tr><td><p>Elasticsearch 7.0</p></td><td><p>`zoomdata-edc-elasticsearch-7.0`</p></td><td><p>7.0 - 7.17</p></td><td><p>8139</p></td><td><p /></td></tr><tr><td><p>Elasticsearch 8.0</p></td><td><p>`zoomdata-edc-elasticsearch-8-0`</p></td><td><p>8.1 - 8.3</p></td><td><p>8147</p></td><td><p /></td></tr><tr><td><p>HDFS</p></td><td><p>`zoomdata-edc-hdfs`</p></td><td><p /></td><td><p>8126</p></td><td><p>Separate download.</p></td></tr><tr><td><p>Hive</p></td><td><p>`zoomdata-edc-hive`</p></td><td><p>2.1 - 3.1</p></td><td><p>8132</p></td><td><p /></td></tr><tr><td><p>Jira Connector</p></td><td><p>`zoomdata-edc-jira`</p></td><td><p>Jira JDBC Driver 1.7.8.1002</p></td><td><p>8151</p></td><td><p>Separate download.</p></td></tr><tr><td><p>MemSQL</p></td><td><p>`zoomdata-edc-memsql`</p></td><td><p>7.1 - 7.6</p></td><td><p>8099</p></td><td><p>Install JDBC driver.</p></td></tr><tr><td><p>Microsoft SQL Server</p></td><td><p>`zoomdata-edc-mssql`</p></td><td><p>12.0 (SQL Server 2014) - 16.0 (SQL Server 2022)</p></td><td><p>8100</p></td><td><p /></td></tr><tr><td><p>MongoDB</p></td><td><p>`zoomdata-edc-mongo`</p></td><td><p>3.4 - 4.4</p></td><td><p>8123</p></td><td><p /></td></tr><tr><td><p>MySQL</p></td><td><p>`zoomdata-edc-mysql`</p></td><td><p>5.6 - 8.0</p></td><td><p>8101</p></td><td><p>Install JDBC driver.</p></td></tr><tr><td><p>Oracle</p></td><td><p>`zoomdata-edc-oracle`</p></td><td><p>11.2 - 21c</p></td><td><p>8102</p></td><td><p>Install JDBC driver.</p></td></tr><tr><td><p>PostgreSQL</p></td><td><p>`zoomdata-edc-postgresql`</p></td><td><p>9.6 - 14.0</p></td><td><p>8105</p></td><td><p /></td></tr><tr><td><p>Python</p></td><td><p>`zoomdata-edc-python`</p></td><td><p /></td><td><p>8153</p></td><td><p>Install Docker image. See Manage the Python Connector.</p></td></tr><tr><td><p>Real Time Sales</p></td><td><p>`zoomdata-edc-rts`</p></td><td><p /></td><td><p>8108</p></td><td><p>Must be enabled.</p></td></tr><tr><td><p>Salesforce</p></td><td><p>`zoomdata-edc-salesforce`</p></td><td><p>Simba Salesforce JDBC Driver 2.1.22</p></td><td><p>8152</p></td><td><p>Separate download.</p></td></tr><tr><td><p>SAP Hana</p></td><td><p>`zoomdata-edc-saphana`</p></td><td><p>2.0</p></td><td><p>8109</p></td><td><p>Separate download and install JDBC driver.</p></td></tr><tr data-mc-conditions=""><td><p>SAP S/4HANA</p></td><td><p>`zoomdata-edc-saphanacloud`</p></td><td><p>N/A</p></td><td><p>8205</p></td><td><p>Separate download and install JDBC driver.</p></td></tr><tr><td><p>SAP IQ</p></td><td><p>`zoomdata-edc-sapiq`</p></td><td><p>16</p></td><td><p>8121</p></td><td><p>Separate download and install JDBC driver.</p></td></tr><tr><td><p>Snowflake</p></td><td><p>`zoomdata-edc-snowflake`</p></td><td><p>whatever is currently supported in the cloud</p></td><td><p>8131</p></td><td><p>Separate download.</p></td></tr><tr><td><p>Spark SQL</p></td><td><p>`zoomdata-edc-sparksql`</p></td><td><p>2.3 - 3.0</p></td><td><p>8116</p></td><td><p /></td></tr><tr><td><p>Teradata</p></td><td>`zoomdata-edc-teradata`</td><td>16.20</td><td>8111</td><td><p>Separate download and install JDBC driver.</p></td></tr><tr><td><p>TIBCO DV</p></td><td><p>`zoomdata-edc-tibcodv`</p></td><td><p>8.0-8.1</p></td><td><p>8140</p></td><td><p>Separate download and install JDBC driver.</p><p>The default TDV server port for JDBC connections is 9401.</p></td></tr><tr><td><p>Trino</p></td><td><p>`zoomdata-edc-trino`</p></td><td><p>351-390</p></td><td><p>8148</p></td><td><p>Separate download.</p></td></tr><tr><td><p>Vertica</p></td><td><p>`zoomdata-edc-vertica`</p></td><td><p>7.2</p></td><td><p>8112</p></td><td><p>Separate download and install JDBC driver.</p></td></tr></tbody></table>

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.