How to get started with Daton setup
Step by step procedure to configure integrations on Daton
Step 1:
Go to https://daton.sarasanalytics.com/login and sign-up with valid email address. All fields are mandatory, and Company Name must be unique
Login Page
Step 2: One will receive a verification link to the registered email address. One will have to get verified successfully before logging in to Daton
Step 3: One would be redirected to ‘Subscriptions’ page after sign-in for the first time. Click on the ‘Free Trial’ button to try Daton for free. Free trial would be enabled for the registered email address for 14 days and users can subscribe to monthly plans anytime
Subscription Plans
Step 4: Go to Connectors menu tab to find all available sources. Users can filter the sources based on the selected category
Connectors
Step 5:
Click on any of the data sources to initiate integration setup. You will have to provide the following details -
- Integration Name: Tables in the warehouse would be created using this name
- Frequency: Parameter to specify how often the data must be replicated from source to destination. You can select a frequency from 1 hr to 24 hrs
- History: Parameter to specify how much historical data to be replicated in the first load. All subsequent loads would be incremented from the previous load. You can select history from 0 years to 10 years
Integration Setup
Step 6: Provide details for authentication and authorization. This screen will change depending on the authentication parameters and mechanism for each data source. Authentication mechanisms include OAuth (username & password for the SaaS application), and Basic (with static API keys and Secrets or Database details)
Integration Setup
Step 7: Select accounts or schema for the integration. Database sources might have several DB schemas to select from. Users can select one or multiple schemas for an integration. Similarly for some of the SaaS applications like Facebook Ads, businesses can have multiple Ad accounts with in the same Facebook business account, and users can select multiple Ad account ids
Account Selection
Step 8: Select required tables. APIs from all third party applications are represented as tables in Daton. Users can select multiple tables for the selected integration
Table Selection
Step 9: Next step is to select the fields for each table.
Select replication fields (only for database sources) to increment data based on this field. For example, If we select a primary key as a replication field, then data extracts will be processed incrementally based on the last extracted primary key.
Field Selection
Step 10: The configured integrations will be in pending state until data is extracted, then it will be moved to active state. Users can view the status in the My Integration page
My Integrations Page
Step 11: Users
would be able to pause, re-activate or delete the integrations from the My Integrations page
Step 12: Additionally, users can view their usage in the Dashboards page and see process logs for all the integrations in the logs page
Additional Monitoring Pages
Step 13: Integrate data warehouse by selecting your choice from the Daton supported list. Refer warehouse setup tutorials for Google Big Query, Amazon Redshift, Oracle Autonomous data Warehouse respectively
E.g. Google Big Query
- Go to the Connectors page and click on the Data Warehouses tab
Select a Data Warehouse
Step 14: Provide a name for the warehouse integrations. Data sets will be created with this name on the warehouse
Data Warehouse Name
Step 15: Sign-in with Google account who owns the Big Query warehouse account. You can select the project within this account in the subsequent screens
Warehouse Login
Step 16: Select a project and submit the warehouse integration. Data processing would be initiated only after warehouse is configured successfully
Select warehouse project
Step 17: Allow sometime for data to flow and one can verify the integration status on My Integrations page. Initial data loads take several hours to a few days to completely replicate the data depending on data source . Data replication speed depends on the the number of historic years of data selected as well as the API quotas enforced by data source platforms
Step 18: Continue with other data source integrations and enjoy the data
Last modified 3yr ago