🦚 Use Datagran to Centralize your Data
🤩 Clean, deduplicate and organize your data
🦚 Use Datagran to Centralize your Data
Task:
I want to make all my data available in a single place. I want my data to update automatically and to be able to do my analysis using many sources at the same time.
How it can be done with Datagran:
With Datagran you will be able to integrate many data sources such as:
- Datagran's Web Pixel
- Datagran's Mobile SDK (Android/IOS)
- Datagran's Cordova Plugin
- Stripe
- Google Ad Insights
- Amazon Redshift
- SFTP CSV Integration
- Amazon S3 CSV Integration
- Google Sheets
- Facebook Ad Insights
- Hubspot
- PostgreSQL
- mySQL
- WooCommerce
- Shopify
- mongoDB
- SQL Server
- Snowflake
- Amplitude
- Among others.
How can you actually do this:
- In your workspace, click on “Integrations” on the top left. On this page you will be able to see your current integrations and its status. Also, for Web Pixel integrations, you will be able to see live events.
- Click on “Create Integration”
- Choose the Integration you want to add. Follow the on-screen instructions. In some cases, you will have to choose which tables/tabs exactly to import, whether to do a full-table update or key-based update and other integration-specific options.
- Once your integration is set, you will be able to see its status in your integrations page. A yellow icon means your integration was created, a blue icon means the data is being gathered, a red icon means there was an error and a green icon means your data was successfully imported. Your data will update daily at about the same time the integration was created.
![https://s3-us-west-2.amazonaws.com/secure.notion-static.com/a3af3ccd-013b-4d30-b929-51eb957e1788/Screen_Shot_2020-07-12_at_4.52.02_PM.png](https://s3-us-west-2.amazonaws.com/secure.notion-static.com/a3af3ccd-013b-4d30-b929-51eb957e1788/Screen_Shot_2020-07-12_at_4.52.02_PM.png)
Recommendations:
There are some integration-specific recommendations that you will find also in the integration-creating process:
- For databases (mongoDB, PostgreSQL, mySQL, SQL Server) you need to make sure your server is accessible from an external IP address. Also if you have restricted the access firewall rules. You can find our IP list in the “Create Integration” page.