The connection string format shown below is to be used with Loome Publish. You will need to replace a few pieces of information within the connection string;
• Server FQDN – This is the fully qualified domain name of the SQL server where your database is hosted.
• Database Name – The name of the database used during the database creation process.
Ensure you remove the <> values from the string, these are just to highlight tokenized parts of the connection string.
Server=<Server FQDN>;Initial Catalog=<Database Name>;Integrated Security=true;TrustServerCertificate=True;Pooling=False;MultipleActiveResultSets=False;Encrypt=True;Connection Timeout=30;
These keys are required for Loome Publish to function correctly. They must be entered during the application installation.
| Key Name | Value |
|---|---|
| ClientId | This is the Application ID of the App Registration generated during Loome Identity app registration. |
| ClientSecret | This is the Client Secret generated during Loome Identity app registration. |
| PostLogoutRedirectUri | This is the URL to redirect to after a logout. It is the URL of the web application followed by /Account/SignOutCallback (Ex. https://portal.my.domain/Account/SignOutCallback). |
| Authority | This is the URL of your Loome Identity server, followed by :443/ (Ex. https://identity.my.domain:443/) |
| RedirectUri | This is the URL of your Loome Publish portal, followed by a trailing forward slash. (Ex. https://portal.my.domain/). |
| BiPortalDb | This is a SQL connection string for your web application. Please refer to SQL Connection String Format when entering this value. |
| BiPortalDb_DatabasePublish | This is a SQL connection string for your web application. Please refer to SQL Connection String Format when entering this value. |
| Key Name | Value |
|---|---|
| Client Name | This is a display name to identify the client configuration. (Ex. Loome Publish) |
| Client Uri | This is the URL of your web application followed by a trailing forward slash. (Ex. https://portal.my.domain/) |
| Post Logout Redirect Uri | This is the URL to redirect to after a logout from your Loome Publish portal. It is the URL of the web application followed by /Account/SignOutCallback (Ex. https://portal.my.domain/Account/SignOutCallback) |
| Redirect Uris | Add the following five redirect Uris, replacing portal.my.domain with your own DNS name for the portal https://portal.my.domain/ https://portal.my.domain/home/activatelicense https://portal.my.domain/home/noaccess https://portal.my.domain/Account/SessionTimeout https://portal.my.domain/Account/InvalidSession |