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.
- White list 22.214.171.124/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 126.96.36.199/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.
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.