Steps for configuring MySQL
To configure MySQL with Intentwise analytics Cloud, follow these steps:
Create a new database ‘intentwise' in the MySQL cluster.
If your database is behind the firewall, whitelist the following IP addresses. This is required for the Intentwise data pipeline to access your database.
52.25.90.16
34.216.244.114/32
52.68.49.96/32
52.26.72.39/32
52.48.81.207/32
54.86.110.101/32
52.64.101.124/32
52.74.180.132/32
18.196.243.206/32
Create any new user with the <password> in your MySQL database.
Create the following new schemas within the database:
amazon_source_data
intentwise_ecommerce_graph
amazon_marketing_cloud (recommended if you are currently using or intend to use Amazon Marketing Cloud)
criteo_source_data (recommended if you are currently using or intend to use Criteo)
instacart_source_data (recommended if you are currently using or intend to use Instacart)
walmart_source_data (recommended if you are currently using or intend to use Walmart)
Grant read/write permissions for the user created in step #3 by using these queries:
GRANT ALL PRIVILEGES ON amazon_source_data TO <intentwise_user>;
GRANT ALL PRIVILEGES ON intentwise_ecommerce_graph TO <intentwise_user>
Now, go to the Intentwise platform and navigate to My Connections under Intentwise Analytics Cloud. Click on "+ Add Destination", choose MySQL as the destination and click Next.
And enter the Host, Port, Database, User, and Password details and Save.
On successful completion, you will see this message:
For any further questions on the pipeline setup, please reach out to us on chat or at [email protected].