One thing we take seriously is data security. We strongly recommend you use SSH or some other form of encryption to secure your data. If this is not an option, you can still directly connect Stitch to your database using the instructions in this article.
Click here for more info on replicating your views.
Connecting MySQL RDS
Stitch supports connecting a MySQL-based Amazon RDS instance.
In this article, we'll walk you through directly connecting your MySQL database to Stitch. These settings can also be used with Magento and any other eCommerce databases that use MySQL.
Connecting MySQL is a five-step process:
For the connection to be successful, you must configure your firewall to allow access from our IP addresses. Whitelist the following IPs before continuing onto the next step:
Note that anything inside square brackets -
[like this], for example - is something you need to define when running the commands yourself.
The simplest way to create a MySQL user for Stitch is to execute the following query when logged into MySQL with
GRANT SELECT ON *.* TO '[stitch username]'@'<[Stitch IP address]>' IDENTIFIED BY '<[secure password]>';
To restrict this user from accessing data in specific databases, tables, or columns, you can instead run
GRANT queries that only allow access to the data you permit.
GRANT query for all required IPs using the same user and password.
To wrap things up, we need to enter the connection and user info into Stitch.
mysql_marketingin the data warehouse.
The Replication Frequency controls how often Stitch will attempt to replicate data from your data warehouse. By default, the frequency is set to 30 minutes, but you can change it to better suit your needs.
When you're finished, click the Save Integration button to complete the setup.
Now that your MySQL database is connected to Stitch, the last step is selecting the tables and fields you want to sync from your database.