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 permissionsto [email protected] service account
Read setup instructions in detail for BigQueryhere
White list 188.8.131.52/32 Daton IP Address in security groups for the required RedShift cluster
Create a database user on RedShift and grant CREATE permissions on the database
CREATE USER daton WITH PASSWORD 'yourpassword';
CREATE SCHEMA daton AUTHORIZATION daton;
GRANT CREATE ON DATABASE db-name TO daton;
Read setup instructions in detail for RedShifthere
White list 184.108.40.206/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 -
databases such as MySQL, PostgreSQL, Amazon Aurora, Amazon RedShift, GCP MySQL, GCP PostgreSQL, Amazon RDS MySQL, Amazon RDS PostgreSQL
Ecommerce platforms such as Magento, Capillary MartJack, WooCommerce, and BigCommerce
SaaS Applications with OAuth Authentication
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.
SaaS Applications with Basic Authentication
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.