Database connector (MySQL, PostgreSQL, MSSQL)

Setup connection

Using database connectors, you can connect Amalia to database servers and clusters to synchronize needed tables.

Once you click on the database connector icon, the first step will be to setup the connection to your database server. The connection is done using a "user & password" authentication, so you'll have to provide these information:

Enabling secure database access

IP address allowlist

The first step is to limit access to your data from the network layer. We recommend granting access to your database only from specific, trusted hosts.

You can ask to Amalia support to have the list of IP addresses that are needed to allow network traffic from your database cluster.

All network traffic from Amalia will come from one of the listed IP addresses. Prohibiting traffic to your database, except from these and other trusted IP addresses, is an easy way to limit data access.

Encrypted connection using SSH Tunnel

You can secure the connection to your database server using a SSH tunnel. Using a tunnel provides an encrypted connection and extra authentication for enhanced security.

Prerequisites

Before you can set up your SSH tunnel, you need to ensure that you have configured and installed SSH keys on your running environment.

SSH Tunnel configuration

To enable database connection through SSH tunnel, you'll have to check the "use SSH tunnel ?" option and provide following information:

How did we do?

Related Articles

• Connect to an external data source
• View, refresh and overwrite your custom object
• 📨 Set up integrations for external notifications (Slack...)