PRTG Manual: Target Databases

Setting

Description

Database type

Select the type of database:

▪MSSQL

▪MySQL

▪Oracle

▪PostgreSQL

▪MariaDB

Alias

Enter the alias of the new database. This is a unique identifier specific to PRTG Data Exporter.

Host

Enter the hostname that you will use to store the PRTG Data Exporter data.

The format used is Server\Instance. If it uses a local installation of SQL, you can use (local)\INSTANCE.

Port

Enter the port needed to connect to the host.

Database name

Enter the name of the database where the application stores the data.

If left empty, PRTG Data Exporter uses the default name: prtg_data_exporter.

Authentication

Select the type of authentication:

▪SQL

▪Windows

Username

Enter the user name used for SQL Authentication.

Password

Enter the password used for SQL Authentication.

SSL Settings | Encrypt

Select if you want to encrypt the connection to the database with SSL:

▪No: Do not encrypt the connection. This is the default.

▪Yes: Encrypt the connection.

SSL Settings | Trust server certificate

Select if you want to trust the server certificate.

▪Yes

▪No

Test connection

Test the connection to the database.

Setting

Description

Search

Use the search bar to filter for a specific database.

Edit

Edit the selected database.

Delete

Delete the selected database.

You cannot delete the local PostgreSQL database.