Database as a Data Source

The difference is to create a destination first and then continue with creating a data source, followed by creating a flow.

Step 1 - Connect a Data 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. From the list of sources, choose the destination. You can type the connector's name into the search bar to find it faster.
   NOTE: Most of the dashboarding apps such as PowerBI or Google Data Studio do not require authorization, therefore you connect them directly when creating a flow.

4. Choose your account and click on Next. 
   NOTE: If you have not authorized your account, click on Authorize. You will be redirected to the sign-in page. Once signed in, continue with the steps in Dataddo.

5. Fill out all the fields on the sign-in page to give Dataddo all the necessary information to connect your data, and click on Save.

Step 2 - Connect a Data Source

1. Sign in to your Dataddo account and click on Sources at the top of the page.

2. Click on Create Source in the top right corner.

3. From the list of sources, choose the connector. You can type the name of the connector into the search bar to find it faster.

4. From the drop-down menu, choose your Account connected to Dataddo, and then select other fields, such as campaign, ads account, or other. Click on Next to continue with the setup.
   For dataset-based sources, first, select the Dataset and click on Next to select the account.
   NOTE: If you are not sure which Dataset you need, but you know which Metrics and Attributes you are looking for, you can use the Search by name or attribute function or you can browse through all the possible Attributes and Metrics for each Dataset by clicking on the specific Dataset.

   1. Add new account
      If you want to connect a new account that is not on the list, click on Add Account. You will be redirected to the sign-in or authorization page to confirm the account. Once you confirm, you will be redirected back to the Dataddo app.
      NOTE: In case the authorize requires API key/token, data label, domain/subdomain, or other additional information, search the connector page in the top search bar of Dataddo Documentation Site for more information.

   2. Authorize your account
      If you have not authorized your Account with Dataddo, click on Authorize and you will be redirected to your account to log in or authorization page.
      After you log in and give Dataddo the necessary permissions to access your data, you will be redirected back to the connector.

5. Choose a Name for your Data Source and select the Attributes. To continue to the next page, click Next.
   NOTE: The Metrics and Attributes depend on the Dataset you selected in the previous step. If you need different Metrics and Attributes, go back two steps and change the Dataset.

6. Configure your snapshotting preferences by choosing your Data range*, Sync type, Sync frequency, Time, and Timezone. Confirm your setup by clicking on Next.
   NOTE: *If the Data range is available to select, you can load historical data. Read more about it in our guide.

7. In the last step, you can preview your data. Click on Save and your new Data Source is ready.

Step 3 - Create a Data Flow

1. Click on Flows at the top of the page.

2. Click on Create Flow in the top right corner.

3. Click on Add Source to connect it to the destination. You can type the connector's name into the search bar to find it faster.

4. Once you select your data source, click on Add Destination.

5. From the list of destinations, select the destination. You can also type the name into the search bar.

6. Configure the destination by filling out necessary fields.

7. You can Name your flow by typing the name into the top.

8. You can see a preview of your data to make sure of your configuration by clicking on Data Preview tab on top.

9. Click on Save flow.