Skip to content
Documentation

Database Connection Configuration

This guide describes how to configure database connections for the application.

All database settings are located under the following base path:

HAKOM:Persistence:Repositories:Repository:{RepositoryName}

Replace {RepositoryName} with your chosen repository identifier (e.g., MainDatabase, ReportingDB).

{RepositoryName}
├─ Name (must repeat {RepositoryName})
└─ Provider
├─ Type
└─ Settings
└─ Setting
└─ {SettingName} (provider settings)
<HAKOM>
<Persistence>
<Repositories>
<Repository Name="MainDatabase">
<Provider>
<Type>postgresql</Type>
<Settings>
<Setting Name="Server">db.example.com</Setting>
<Setting Name="Port">5432</Setting>
<Setting Name="Database">myapp</Setting>
<Setting Name="User ID">app_user</Setting>
<Setting Name="Password">secret123</Setting>
</Settings>
</Provider>
</Repository>
</Repositories>
</Persistence>
</HAKOM>

Configure the basic provider settings for your repository.

The repository itself also requires a Name (path HAKOM:Persistence:Repositories:Repository:{RepositoryName}:Name) that repeats the configuration key. In XML the Name attribute of <Repository> supplies both.

Path: HAKOM:Persistence:Repositories:Repository:{RepositoryName}:Provider

Element Type Default Required Description
Type enum — ✓ Database type. Allowed values: oracle, sqlserver, postgresql.

Configure how to connect to your database server.

Path: HAKOM:Persistence:Repositories:Repository:{RepositoryName}:Provider:Settings:Setting

Confidential values such as passwords should not be stored in clear text. Mark them with Encrypted="true" and, optionally, a Certificate name, as shown in the examples below. How to set up the certificates is described in Cryptography Configuration, and how to encrypt a value in HAKOM.Cryptography.Console.

The exact parameters needed for an Oracle connection can be found in the Oracle connection string documentation.

flask Oracle repository connection

Section titled “ Oracle repository connection”

The following fragment shows a repository entry under HAKOM:Persistence:Repositories:

<Repository Name="TSM_ORACLE">
<Provider>
<Type>oracle</Type>
<Settings>
<Setting Name="User ID">HAKOM_TSM_TEST</Setting>
<Setting Name="Data Source">(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1522))(CONNECT_DATA=(SERVICE_NAME=ORCLPDB1)))</Setting>
<Setting Name="Min Pool Size">0</Setting>
<Setting Name="Password" Encrypted="true" Certificate="Shared Development Key">TaE+e+...</Setting>
</Settings>
</Provider>
</Repository>
© 2026 Volue.Version v0.6.38017 November 2026