Comment on page
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 184.108.40.206/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 220.127.116.11/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.