Steps for Adding a New Tenant

Login to RDS Database Using PGAdmin

1. Open PGAdmin: Launch PGAdmin on your system.

2. Connect to RDS:

   • In PGAdmin, add a new server connection using the credentials (hostname, port, username, password) for your RDS instance.

Create a New Database

• Run the Create Database Script: (Replace the name of the database for the county name)

• Run Database Schema Script

• Run Database Data Script

Update Central Database.

1. Connect to the Central Database: Log in to the central database for the environment where the new tenant will be added (e.g., Test, QA, Stage, or Prod).

   1. Add New County: If the county is not present, execute: (Replace name of the County)

   2. Add New State: If the state is not present, execute: (Replace name of the State)

   3. Add New Tenant: Execute the SQL script to add the new tenant. Make sure to replace the placeholders with the actual values:

Insert Default User

1. Still Connected to Central Database: Ensure you're connected to the central database where the default user should be added. This script with insert the Default user testcoral@catalisgov.com. This user is already registered in the Catalis Identity Server.

Login to Catalis Identity Server https://test-login.automonapps.com/Account/Login

1. Access Identity Server: Log in to the Catalis Identity Server using your credentials.

2. Create New Tenant: Follow the steps within the Identity Server to add a new tenant. Ensure that:

   • The tenant name matches the database name created.

   • Additional details are filled in as required by the server.

3. Create new tenant

   Open

   

4. Assign Default user to new Tenant

Coral application will do a redirect to the identity server to determine if the user is authorized

Identify server will return the Token and TenanId

Apis will be authorized by using the Token Id returned by the Identity Server