Can't connect to PostgreSQL db from Architect

support
1

I have a MS SQL and PostgreSQL databases running in docker. When I try to open a project in Architect connected to MS SQL db, it works. When I try to connect to PostgreSQL db I end with the following error. In both cases I use Data Source=localhost in the DataConnectionString setting.

Origam Architect version 2025.5.2.3862

ERROR Origam.Security.AbstractProfileProvider - Couldn't set data source
Parameter name: data source
System.ArgumentException: Couldn't set data source
Parameter name: data source ---> System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.
   at Npgsql.NpgsqlConnectionStringBuilder.GeneratedSetter(String keyword, Object value)
   at Npgsql.NpgsqlConnectionStringBuilder.set_Item(String keyword, Object value)
   --- End of inner exception stack trace ---
   at Npgsql.NpgsqlConnectionStringBuilder.set_Item(String keyword, Object value)
   at System.Data.Common.DbConnectionStringBuilder.set_ConnectionString(String value)
   at Npgsql.NpgsqlConnection.SetupDataSource()
   at Origam.DA.Service.PgSqlDataService.GetConnection(String connectionString)
   at Origam.DA.Service.DataLoader.Fill()
   at Origam.DA.Service.AbstractSqlDataService.LoadDataSet(DataStructureQuery query, IPrincipal principal, DataSet dataset, String transactionId)
   at Origam.DA.Service.AbstractSqlDataService.LoadDataSet(DataStructureQuery dataStructureQuery, IPrincipal principal, String transactionId)
   at Origam.Workflow.DataServiceAgent.LoadData(DataStructureQuery query, DataSet data)
   at Origam.Workflow.DataServiceAgent.Run()
   at Origam.Security.OrigamProfileProvider.GetProfileData(String userName)
   at Origam.Security.OrigamProfileProvider.GetProfile(String userName)
2

The issue was that when connecting to a PostgreSQL db using Npgsql, the DataConnectionString needs to be modified to match the parameter names used by this data provider library.

<DataConnectionString>Host=localhost;Port=5432;Database=test;Username=xx;Password=yy;Pooling=false</DataConnectionString>