Data storages

Dataddo supports data delivery to various data storage technologies inluding SQL server, MariaDB, PostgreSQL, AWS S3, AWS Redshift, Google Big Query or even SFTP.

Adding a new external data storage

New data storages can be added by navigating to Destinations and clicking on New destination. Similarly to Data Sources, all data storages connected without any issue are marked with a LIVE badge. Also available is timestamp information about the last usage.

destination-1


Note: for some destinations such as Google Sheets, you will first need to connect your Google Sheets account and then you can add new destination following the steps above. You can connect your account by navigating to Settings --> Connected accounts and clicking on Connect account in the top right corner.

connect_account

Testing and debugging

Each of the connected services and storages can be tested by clicking on Test connection. A detailed connection log is available.

Supported services and storages

Dataddo supports the following storage platforms with off-the-shelf data writers:

Storage Type Description
MariaDB SQL On-prem / self hosted / managed
MySQL SQL On-prem / self hosted / managed
PostgreSQL SQL On-prem / self hosted / managed
Microsoft SQL Server SQL On-prem / self hosted / managed
AWS Aurora SQL Database-as-a-service
AWS RDS SQL Database-as-a-service
AWS Redshift Big data storage  
AWS S3 File storage  
Google Sheets Cloud spreadsheet  
Google Drive File storage  
Google BigQuery Big data storage  
Google Cloud SQL SQL Database-as-a-service
Azure SQL SQL Database-as-a-service
Anaplan Project management software  
SFTP File storage On-prem / self hosted / managed
BrickFTP File storage SFTP-as-a-service
CrushFTP File storage SFTP-as-a-service