How to Connect a Data Destination

Dataddo can deliver your data to any location and easily connect various data warehouses such as Google Big Query, SQL databases, AWS Redshift or configure the integration between your data sources and your favorite dashboarding apps.

The main difference between the data warehouses and the dashboarding app is that the data warehouses have been designed to store large volumes of data and generally, they allow for more flexibility when storing this data.

Prerequisites

• You already have a Dataddo account. If you do not have an account already, sign up for 14-day trial.
• You have already created a source.
• You have your account, creadentials etc. for your destination ready.
  • Using Dashboarding Apps as a destination (e.g. Tableau, PowerBI, Google Data Studio). Make sure you have an account for the given service. In case of desktop apps make sure you have the latest version correctly installed.
  • Using Database / Datawarehouse as a destination (e.g. Google Big Query, Snowflake, MySQL, Amazon S3, Azure SQL). Make sure to have a an account with appropriate permissions setup and the destination accepts incoming connection from Dataddo.
  • Using Application as a destination (e.g. Hubspot, Netsuite, Saleforce). Make sure you have the account available with appropriate permissions.

Choosing the destination

Dashboarding app as a destination

Dashboarding app destination is created implicitly during the configuration of the flow, so there is no need for any extra configuration steps besides making sure that you have an active account with a given service or / and the latest version correctly installed. You can directly proceed to create a flow.

Database / data warehouse as a destination

1. Sign in to your Dataddo account and click on Destinations at the top of the page.
2. Click on Create Destination in the top right corner.
3. Choose the destination you would like to send data to.
4. Fill out all the fields to give Dataddo all the necessary information to connect your data, and click on Save. For destinations that require OAuth (Google BigQuery, Google Sheets) you need to authorize an account first by clicking on Add new account and following the authorization procedure.
5. You can proceed to create a flow.

Application as a destination

When connecting an application as a destination (e.g. Hubspot, Netsuite, Salesforce, Zoho CRM), please make sure you have an account with appropriate permissions ready. Typically, you will need an account that has write (and analogs such as insert, update or delete) permissions. This is mandatory, since Dataddo will be inserting and modifing the records in the target system.

1. Sign in to your Dataddo account and click on Destinations at the top of the page.
2. Click on Create Destination in the top right corner.
3. Choose the destination you would like to send data to.
4. In case you did not authorize the account yet, please click on Add new account and following the authorization procedure.
5. You can proceed to create a flow.