Data sources
  • Updated on 17 Oct 2019
  • 2 minutes to read
  • Print
  • Share
  • Dark
    Light

Data sources

  • Print
  • Share
  • Dark
    Light

What is data source in Dataddo?

When 3rd party service like Google Analytics or Instagram is connected to Dataddo platform and dataset definition is set, a local copy of dataset is created as Data source. Conceptually, a data source is equivalent to data storage components you can find in other systems, such as table in SQL databases or to sheet in Google Sheets.

Built-in data synchronization

Data in the data sources is not static, since Dataddo provides built-in data synchronization capability. With this feature, you can easily set the data synchronization to hourly, daily, weekly or monthly increments. You can find more details on our dedicated data synchronization section.

Connecting to your data

Dataddo has great flexibility when it comes to connecting to various online data sources. Thanks to unique and robust data transformation middleware, Dataddo can connect to almost any online service providing it has JSON/CSV/XML based API (this covers most services). Even in the case of proprietary APIs, our team is available to build out new connectors within 1-2 business days.

Although Dataddo was from its inception designed with a clear focus to provide unprecedented data integration flexibility, there is a finite number of of-the-shelf connectors with dedicated no-code interfaces that we offer. Therefore, we mostly cover popular services such as Google Analytics, Facebook Insights, LinkedIn Ads or Instagram. In case your service is not in our of-the-shelf connectors list, you can always use one of our Universal connectors to access your data.

Relations to other Dataddo components

Data sources are a crucial part of Integration flows. There is a 1:N relationships to integration flow, therefore you can include multiple data source into single integration flow.

component_relations

Editing data source

Data types and column names

Data types and column names can be edited by clicking on "Edit" incon for the particular data source.
data_source_edit.png

In the modal widow, it is possible to edit the data types and column names of the data source.
data_source_edit_data_types.png

Data source definition

It is NOT possible to edit the chosen attributes (columns) in the data source definition. In order to maintain data consistency, the data source structure, including column ordering, is fixed. If case you need to include the different attributes in the source, the best option is to recreate the source using “duplicate” button, which will initiate the data connector with the parameters used in the original source.

recreate_data_source.png

Was this article helpful?