Terminology in Daton

Terms used in Daton

• Integration - Connecting a data source or a data destination on Daton using their respective pre-built connectors

• Pending Integration - Initial state when the table structure on the warehouse is created and jobs are yet to be initiated

• Active Integration - When at least one job is executed. Active state does not mean that entire data is extracted from the data source and loaded to the warehouse

• Paused Integration - User managed state where in the integration is stopped temporarily

• Deleted Integration - User managed state where in the integration is deleted permanently. Table cannot be recovered in Daton after deleting it

• Data Source - A platform from which data can be periodically extracted. Data source could be a database, file storage, SaaS application/platform which provide data through APIs, or applications which provide data through web-hooks

• Data Destination - Any cloud based data warehouse or relational database. We presently support Google BigQuery and Amazon Redshift

• Jobs - A data pipeline scheduled as per user configuration which extracts data from a data source and loads to the destination. Jobs are created at table level E.g. there would be 5 jobs for 5 tables in an integration, one for each table

• Logs - Specifies details for each job such as the number of records processed, start and end time, processing errors, etc.

• Records - A record is a row created in the data destination table

• Full Load - Initial data extract corresponding to the amount of historic data configuration

• Incremental Load - Loads subsequent to the full load, which are executed depending on the frequency configured. Data is extracted since the previous successful job until present

• Replication Frequency - The frequency at the data is replicated on Daton

• History - The amount of historic data in years to be replicated

• Replication Field - Pivot field used to identify the incremental data. The default replication field for all SaaS applications is 'Updated Date'. Users can select a replication field for all database sources

• Organization Admin (or simply Admin) - Admin is the primary user from an organization who signs up to Daton first. He manages subscriptions, users/accounts and integrations for the organization

• Organization Users (or simply Users) - Additional users are added to Daton by the Admin. Each user can integrate data sources and data warehouses. Users cannot manage subscriptions and other organizational users