Connection Strings

A connection string in Bragi defines how to connect to a database.

Each connection string can have separate values for different environments. This lets you fully separate Develop, Test, and Production systems.

Bragi supports Microsoft SQL Server and PostgreSQL. Only Microsoft SQL Server can be used as the Warehouse.

Base Connection String Settings

Field	Description
Friendly Name	Human-readable name for identifying the connection string.
Code	Short code used for quick reference in Code configs.
Type	Purpose of the connection: • Warehouse: Main connection to Bragi’s Warehouse (only one allowed; required for operation). • Source: Database to import data from. • Destination: Database to export data to.
DBMS	Database type: Microsoft SQL Server or PostgreSQL. Only Microsoft SQL Server is valid for Warehouse connections.

Per-Environment Settings

Each connection string typically has one entry per environment:

Field	Description
Environment	Target environment for the connection string.
Server	Hostname or IP address of the database server.
Database	Name of the database to connect to.
User ID	Database username (optional).
Password	Password for the specified user.
Encrypt (SQL Server)	Enables TLS encryption for the connection.
Passfile (PostgreSQL)	Path to password file for authentication. Format: `hostname:port:database:username:password`.
Trust Server Certificate	Enables encrypted connections while bypassing certificate chain validation.

Advanced Editing

For advanced scenarios or when copying/pasting known configurations, switch from the Parameters tab to the Connection String tab to edit the raw connection string directly.

09 March 2026