After you install DPA and open it for the first time, you must create a repository database.
The repository database is the permanent storage location for monitoring user credentials and performance data captured by SolarWinds DPA from the monitored database instances.
You can use a SQL Server, Azure SQL, MySQL, or Oracle database as the repository. When planning your connection, consider the following:
SolarWinds DPA requires one of the following users to create users and grant them privileges to create the repository:
The SolarWinds DPA server connects to the repository through a TCP/IP connection. Make sure that connection is not blocked by a firewall.