Skip to main content
Self-Service Analytics data connectors are used to connect to your data stores. Each data connector has capabilities and limitations when connected to the Self-Service Analytics 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 Create and Manage Data Store Connections. For information on how to download and install a connector that is not provided in the default Self-Service Analytics installation, see Obtain Additional Connector Servers.
You can use a Dundas BI connection as a data source or in a fusion data source in Self-Service Analytics. See Add Data Store Connections.
ConnectorMicroserviceSupported VersionsConnector 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.48115
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
Dundas BI (formerly Managed) Connectorzoomdata-edc-managedDundas BI 26.2 and later8013**The default port is 8013, or depending on your configuration, set to 8080. Verify the exact port in use in the environment hosting the data source.
The user interface to interact with this connector must be enabled. See Server-Level Variables.
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.
OpenSearchzoomdata-edc-opensearch2.x to 2.178134
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.18140Separate 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 connectors listed above, you can:
  • Upload a flat file for viewing in visuals and dashboards.
  • Dynamically upload and stream your data in real time using the 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 Self-Service Analytics.