Appendix

SQL Connection String Format

The connection string format shown below is to be used with the Enterprise BI Portal. 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;

Web Application Settings

These keys are required for the Enterprise BI Portal 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 Identity Server app registration.
ClientSecret This is the Client Secret generated during Identity Server 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 Identity Server, followed by :443/ (Ex. https://identity.my.domain:443/)
RedirectUri This is the URL of your BI 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.

Identity Server Client Settings

Key Name Value
Client Name This is a display name to identify the client configuration. (Ex. Enterprise BI Portal)
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 BI 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