4.1.3. Supported data sources

File systems

The technologies below are available for reading and, where applicable, writing. Once connected to the desired system, it is possible to read and write files in the formats listed in the following section (CSV, Parquet, Excel, JSON, XML, etc.).

  • Import files from the user’s local drive

  • SFTP / plain FTP

  • HTTP / HTTPS (retrieval from a list of URLs)

  • Network drives (on premise deployments only)

  • Amazon Simple Storage Service (Amazon S3)

  • Azure Blob Storage

  • Azure Data Lake Gen2

  • Google Cloud Storage

  • Microsoft Sharepoint / OneDrive storage

  • Grist

  • Microsoft Lists

Supported File Formats

  • CSV, TSV

  • Log files

  • Microsoft Excel

  • Microsoft Access: ACCDB and MDB

  • XML

  • JSON and JSON line files

  • Parquet

  • LOG

  • PRN

  • TXT

Relational databases

  • MySQL

  • MariaDB

  • PostgreSQL

  • Microsoft SQL Server

  • Oracle

  • Databricks via JDBC

  • Db2 and Db2 iSeries AS/400

  • Denodo via JDBC versions 7 and 8

  • Snowflake

  • Google BigQuery

  • Amazon Redshift

  • Teradata

  • Denodo (through JDBC)

API and Applications

  • OData v4

  • Salesforce CRM

  • Microsoft Dynamics CRM

  • Hubspot CRM

  • Google sheets

  • Zendesk

  • Jira