For security purposes, Pro2 validates and controls access to your multi-tenant database.

Set-up secure connection to a multi-tenant database

With Pro2, you can configure a secure connection to your multi-tenant database. Each tenant in a multi-tenant database must have its own installation of Pro2, a schema holder, and an ODBC connection. However, for all the tenants, the logical name of the ODBC connection can be the same, and the schema holder name can be same as the Pro2 installation folders are different for each tenant.

To establish a secure connection to a multi-tenant database:
  1. Embed Repl database into your source database by performing the following tasks:
    1. Shutdown the source database.
    2. In the repladd.st file, add the Repl database structure to the source database by updating the command:

      prostrct add <sourcedb_name> repladd.st

    3. Load repl.df to the new database.
    4. Start the source database by running the following command:

      proserve <sourcedb_name>

  2. Create a separate folder for each tenant, such as Pro2_tenant1, Pro2_tenant2, etc., and install Pro2 for each tenant.
  3. Edit the Pro2_env file and update the paths to point to the corresponding tenant.
  4. Create <database>.pf files for each tenant, such as Tenant1DB.pf, Tenant2DB.pf, etc., and edit them to point to their corresponding Pro2 instances.
  5. Specify the username and password in the <database>.pf files if you are connecting to the database for the first time.

The Pro2 web user interface is now set to connect to your multi-tenant database securely using your credentials.