Configure patient database credentials

Add database connection details and credentials

• Log in to the Researcher Portal using a Chrome web browser

  • https://localhost:443/portal - local workstation
  • https://<FQDN>/portal - remote server

• Login as the new admin user

• Switch to Admin Portal

• Select Setup on top right

• URL is now:

  • https://localhost:443/portal/systemadmin/setup - local workstation
  • https://<FQDN>/portal/systemadmin/setup - remote server

• Select Databases Configure button

• Select Add database

• Enter the database information.

  • Values below are based on setting up the sample synpuf1k database. Adjust and configure it as per your requirements.
  • (for users following the steps to create synpuf1k database) Add the values from the table below based on the previous Postgres database and users setup step.

• Click Save

name	value	note
Database ID	alpdev_pg	display name
Host	d2e-minerva-postgres-1	PostgreSQL container name /or/ external database FQDN. Ensure the correct container name is used.
Database name	alpdev_pg	actual name
Vocabulary / CDM Schemas	cdmvocab cdmdefault	Enter the vocab/cdm schemas value and press Enter to confirm.
Extra	{"max": 50, "schema": "cdmdefault", "queryTimeout": 60000, "statementTimeout": 60000, "idleTimeoutMillis": 300000, "connectionTimeoutMillis": 60000, "idleInTransactionSessionTimeout": 300000}
Admin username	postgres_tenant_admin_user	*
Read username	postgres_tenant_read_user	*
Admin password	*****	@
Read password	*****	@
Cache replication		Not required

note

• * - schema/usernames are the values expected for sample data load steps - do not change
• @ - create a random password
  • For synpuf1k dataset setup use the password that was created for postgres_tenant_admin_user and postgres_tenant_read_user respectively in section 3-setup-pg-permissions.

After adding database

The expected result after adding a database is: