Access permissions for Daton
Daton will require access permissions both for extracting data from data sources and for loading data to cloud based data warehouses and data lakes. As a generic rule, Daton would need read access to data sources and write access to data destinations. The following write-up will talk in detail for each variety of integration.
- Google BigQuery will require BigQuery Data Owner and BigQuery Job User permissions to [email protected] service account
- White list 35.238.200.205/32 Daton IP Address in security groups for the required RedShift cluster
- Create a database user on RedShift and grant CREATE permissions on the databaseCREATE USER daton WITH PASSWORD 'yourpassword';CREATE SCHEMA daton AUTHORIZATION daton;GRANT CREATE ON DATABASE db-name TO daton;
- White list 35.238.200.205/32 Daton IP Address
- Create a database user READ permissions on the database
Each database will have different ways to configure the above steps and following links describe them in detail -
- 1.databases such as MySQL, PostgreSQL, Amazon Aurora, Amazon RedShift, GCP MySQL, GCP PostgreSQL, Amazon RDS MySQL, Amazon RDS PostgreSQL
- 2.Ecommerce platforms such as Magento, Capillary MartJack, WooCommerce, and BigCommerce
- Scopes will be pre-defined as Read-Only for most of the OAuth sources such as Facebook Ads, Google Analytics, etc. Users can verify the scopes during authentication on Daton.
For Example:

Scopes for Google Analytics integration on Daton
- It is however recommended that a separate user with Read-Only access be created for Daton on the respective platform and those credentials be used to integrate the data source. Read detailed documentation of respective applications at Data Sources.
- Applications with basic authentication protocols use API Keys and Secrets.
- It is however recommended that a separate user with Read-Only access be created for Daton on the respective platform and those credentials be used to integrate the data source.
- Note that some of the applications might not allow data extraction or usage of APIs with read-only access. Read detailed documentation of respective applications at Data Sources.
Last modified 3yr ago