Databases

A database is a set of parameters used to connect to a database.

A database instance refers to an active connection established to a database from these parameters.

You can add databases via the UI.

Only administrators can edit databases.

Database type

Databases of type PostgreSQL, MySQL, MariaDB are supported in all editions.

Databases of type Oracle, Microsoft SQL Server are only supported in BUSINESS and SOVEREIGN Edition.

SSH Tunneling

If a firewall is blocking the connection port to the database, you can try to connect through a node (the latter will be used to create an SSH tunnel).

What involves using databases

SQL script tasks will execute a SQL script on a set of databases.

SQL report tasks will execute SQL queries to populate charts, and each of these queries may be executed on a different database.