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.
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.
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:
|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 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|
|Anaplan||Project management software|
|SFTP||File storage||On-prem / self hosted / managed|