Configure Patient Database Credentials

Add database connection details & credentials

• Input the D2E Portal URL into 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.

  • Note: Values below are based on setting up the sample synpuf1k database. Please adjust and configure it as per your requirements. For users following the creation steps for the sample synpuf1k database, add the values from the table/image below based on the previous Postgres database and users setup step.

• Click Save

name	value	note
Host	alp-minerva-postgres-1	PostgreSQL container name /or/ external database FQDN
Database code	alpdev_pg	display name
Database name	alpdev_pg	actual name
Vocab schemas	cdmvocab	Enter the vocab schema 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	*****	@

notes:

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

Restart Containers

Run the following command to restart the system for the new connection details be provisioned to the data services

d2e stop
d2e start