While we recommend you connect your databases using an SSH tunnel, you can also use an encrypted VPN connection to keep things secure. A VPN can be used for any of our database integrations and, to keep things simple, the process is just about the same as setting up an SSH tunnel:
In addition to database credentials, you'll have to enter credentials for a VPN user to wrap things up. Any VPN user will work, but we recommend you create an Magento BI user - it'll make it easier for you to keep track of the users on your account.
Let's get started.
The process for creating a database user will vary depending on the database type you're connecting. To see the instructions for each database type, click the links below.
As we mentioned before, any valid VPN user will work - but we strongly recommend you create a user solely for Magento BI use.
For the connection to be successful, your must configure your firewall to allow access from our IP address. It's 22.214.171.124/32, but it's also on any of the database credentials pages:
To wrap things up, we need to enter the connection and user info into Magento BI. Did you leave the database credentials page open? If not, go to Manage Data > Connections and click the Add New Data Source button, then the icon for the database you're connecting. Don't forget to toggle the Encrypted button to Yes.
Enter the following info into this page, starting with the Database Connection section:
Under the Encryption Connection section:
That's it! When you're finished, click the Save & Test button to complete the setup.