Supported connections

DSS can read and write data from a variety of sources.

Connectors

Here is a list of the available connectors in DSS.

Type	Read	Write
Upload your files	yes (see supported formats)	yes (see supported formats)
Server filesystem	yes (see supported formats)	yes (see supported formats)
HDFS	yes (see supported formats)	yes (see supported formats)
Amazon S3	yes (see supported formats)	yes (see supported formats)
Google Cloud Storage	yes (see supported formats)	yes (see supported formats)
Azure Blob Storage	yes (see supported formats)	yes (see supported formats)
SharePoint Online	yes (see supported formats)	yes (see supported formats)
FTP	yes (see supported formats)	yes (see supported formats)
SSH (SCP and SFTP)	yes (see supported formats)	yes (see supported formats)
HTTP	yes (see supported formats)	no
OData	yes (read-only)	no
Managed folders	yes	yes
Files in folder	yes	yes
Editable datasets	yes	yes (UI only)
Iceberg	yes	yes
Snowflake	yes	yes
Databricks	yes	yes
Microsoft Azure Synapse	yes	yes
Google BigQuery	yes	yes
Amazon Redshift	yes	yes
PostgreSQL	yes	yes
MySQL	yes	yes
Microsoft SQL Server	yes	yes
Oracle	yes	yes
Teradata	yes	yes
Greenplum	yes	yes
Google AlloyDB	yes	yes
Vertica	yes	yes
SAP HANA	yes	yes
IBM Netezza	yes	yes
Exadata	yes	yes
IBM DB2	yes (Tier 2)	yes (Tier 2)
Exasol	yes (Tier 2)	yes (Tier 2)
SingleStore	yes (Tier 2)	yes (Tier 2)
Trino/Starburst	yes (Tier 2)	yes (Tier 2)
Treasure Data	yes (Tier 2)	yes (Tier 2)
Other SQL databases (JDBC driver)	best effort, not guaranteed	no, generally
MongoDB	yes	yes
Cassandra	yes (deprecated)	yes (deprecated)
Elasticsearch and OpenSearch	yes	yes
kdb+	yes (Experimental)	no
Generic APIs	Custom Python or R code, plugins	Custom Python or R code, plugins
ServiceNow	yes	no
Salesforce	yes	yes
Zendesk	yes	no
Stripe	yes	no
Google Drive	yes	yes
Google Sheets	yes	yes
Google Analytics	yes	no
PI System	yes	yes (with write credentials)
Splunk	yes	yes
SAP OData	yes	no
YouTube	yes	no

File formats

Here is a list of the file formats that DSS can read and write for files-based connections (filesystem, HDFS, Amazon S3, SharePoint Online, HTTP, FTP, SSH).

Standard formats

Format	Read	Write
Delimited values (CSV, TSV, …)	yes	yes
Fixed width	yes	no
Excel (XLS, XLSX, …)	yes	only via export
Parquet	yes	yes
Hive ORCFile	yes	yes
Delta Lake	yes	yes
Avro	yes	yes
XML	yes	no
JSON	yes	no
ESRI Shapefiles	yes	no
MySQL Dump	yes	no
Apache Combined log format	yes	no
Custom format using regular expression	yes	no

Note that file-based formats can be read compressed: ZIP, GZIP, BZ2.