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
In addition to database credentials, you will have to enter credentials for a VPN user to wrap things up. Any VPN user will work, but we recommend you create an MBI user - it makes it easier for you to keep track of the users on your account.
Let us get started.
The process for creating a database user will vary depending on the database type you are connecting. To see the instructions for each database type, click the links below.
VPNuser for MBI
As we mentioned before, any valid
VPN user will work - but we strongly recommend you create a user solely for MBI use.
For the connection to be successful, your must configure your firewall to allow access from our IP addresses. They are
220.127.116.11, but it is also on the
credentials page for any database integration:
VPNuser info into MBI
To wrap things up, we need to enter the connection and user info into MBI. Did you leave the database
credentials page open? If not, go to Manage Data > Connections and click Add New Data Source, then the icon for the database you are connecting. do not forget to change the
Encrypted toggle to
Enter the following info into this page, starting with the
Database Connection section:
Username: The username for the MBI database user
Password: The password for the MBI database user
Port: The database’s port on your server. Defaults are:
Host: By default, this will be localhost
127.0.0.1, but it could also be your server’s public IP address or a local area network address.
Database Name (optional): If you only allowed access to one database (this is specified during the database user creation step), enter the name of that database here.
Encryption Connection section:
Encryption Type: Set this to
Cisco IPsec VPN
Gateway Address: The IP address of the VPN server
Group Name: The name of the group used for group authentication
Group Secret: The password corresponding to the group.
Username: The MBI
Password: The MBI
That is it! When you are finished, click Save & Test to complete the setup.