Although it is important to link your databases via SSH channel, connecting them via encrypted VPNs may also ensure their security. Thus, you can use VPN to integrate any kind of our databases. In simple terms, this process is more or less similar to creating an SSH channel.

It includes the following stages:

1. Creating Magento BI database for the user
2. Creating a Magento BI VPN for the user
3. Whitelisting Magento BI IP address
4. Entering the VPN user data and connection into Magento BI

Aside from database qualifications, you will need to include a VPN user qualification to make things complete. While any type of VPN user may apply, creating a Magento BI user can be a wise idea. This will allow you to easily monitor the inbound traffic on your site.

Let’s begin by:

Generating a Magento BI user database

This process varies depending on the type of database you intend to connect. You may visit:

1. MySQL
2. Microsoft SQL
3. PostegreSQL and
4. MogoDB

This will help you to understand how to go about each type of database.

Developing a Magento BI VPN database for the user

As aforementioned, any legitimate VPN user may work; however, it is highly recommended that you generate a user specifically for Magento BI application.

Magento BI IP address whitelisting

In order for you to achieve a successful connection, you will need to organise your firewall so as to enable access from IP based addresses. This can be obtained from any vpn database qualification pages.

Inserting into Magento BI, the VPN user and connection info

To finalise things, you will need to feed into Magento BI, the user and connection details. In case you did not leave open the database certification page, visit Manage Data > Connections and press the button denoting Add New Data Source, followed by your target database icon. Remember to Yes-toggle the encrypted key.

After that, feed the following details in to the provided page. Begin with that section denoting Database Connection:

1. Username – Magento BI database username
2. Password – Magento BI database user’s password
3. Port – Your server’s default ports (MySQL-3306, PostegraSQL-5432, MicrosoftSQL-1433 and MongoDB-27017)
4. Host – 127.0.0.1 (by default); yet, it can be the public IP address of your server or local network ID
5. Name of database (optional) – in case you enabled to only a single database, you may enter the name as well.
6. Under the Encrypted Connection part:
7. Encryption Type – Ensure setting it to Cisco

IPsec VPN

1. Gateway Address –The VPN server IP address
2. Group Name - group name for authentication
3. Group Secret - password related to the organisation
4. Username: Username for the Magento BI VPN
5. Password: password for Magento BI VPN client

There we are! Once you are done, press the Save and Test key to finish the setup.

Author's Bio: 

I am blogger from USA, and writing is my passion. I love to explore creative things and learn new things. I write what i learn and share with people.