Database as a Data Source

Some databases can serve a purpose as Data Sources, and via Flows you can connect them to other destinations.

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

   
Number 1

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

Number 2

Click on Create Destination in the top right corner.

Number 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 PoweBI or Google Data Studio do not require authorization, therefore you connect them directly when creating a flow.

Number 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 the Dataddo.

Number 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.

For a more in detail guide on how to connect a data destination, follow this page.

STEP 2 - Connect a data source

   
Number 1

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

Number 2

Click on Create Source in the top right corner.

Number 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.
Number 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.

 

a) 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.

 

b) 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.

Number 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.

Number 6

On the Storage selection page, you can set up the destination configuration. To help you with the snapshot mapping, we make it easier for you to create a connection to the destination based on your preference.

  • A) Click on the option Dashboarding App if you want your data to connect to applications such as Google Data Studio, Power BI, or Tableau.
  • B) Click on the option Data Warehouse, if you want your data to be sent to warehouse storage, e.g., MySQL, Big Query, or PostgreSQL.
Number 7

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.

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

For a more in detail guide on how to connect a data source, follow this page.

 

Step 3 - Create a Data Flow

   
Number 1

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

Number 2

Click on Create Flow in the top right corner.

Number 3 Click on Add Source to connect it to the destination. Select from the list of all your sources or you can type the connector's name into the search bar to find it faster.

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

Number 5

 

Choose from the list of destinations, under the tab Data Storages you will find databases, or go to the Dashboarding app tab to find your dashboarding tool. You can also type the name of the source into the search bar.
Number 6 Configure the destination by filling out necessary fields. You can view what data will be sent by clicking on Data Preview Tab. Click on Save flow.

NOTE: Remember to set the time for the flow with a little delay after the synchronization of your source to let the data load.

For a more in detail guide on how to connect a data flow, follow this page.

 


Need assistance?

Feel free to contact us or create a ticket and we will help you set up the Data Source.