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 Azure SQL server where your database is hosted.
• Database Name – The name of the database used during the database creation process.
• SQL Username – The SQL account created during the database creation process.
• SQL Password – The SQL password created 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=tcp:<Server FQDN>,1433;Initial Catalog=<Database Name>;Persist Security Info=False;User ID=<SQL Username>;Password=<SQLPassword>;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;
These keys are required for Loome Publish to function correctly. They must be present in the Application Settings of the App Service
| Key Name | Value |
|---|---|
| ClientId | This is the Application ID of the App Registration created during Active Directory app registration. |
| AppKey | This is the App Key generated during Active Directory app registration.. You cannot go back and retrieve this afterwards. If you did not save the App Key, you will need to generate a new App Key. |
| PostLogoutRedirectUri | Look on your Web Application overview for the URL. Remember to include the trailing forward slash (Ex. https://portal.azurewebsites.net/). |
| Tenant | Look under your Azure Active Directory > Domain Names > And locate the .onmicrosoft.com domain name. |
| TenantId | Look under your Azure Active Directory > Properties > Directory ID. |
These keys are required for Loome Publish to function correctly. They must be present in the Application Settings of the App Service
| Key Name | Value |
|---|---|
| BiPortalDb | This is a SQL connection string for your web application. Please refer to Azure Connection String Format when entering this value. |
| BiPortalDb_DatabasePublish | This is a SQL connection string for your web application. Please refer to Azure Connection String Format when entering this value. |
These reply URLs are required for Loome Publish to function correctly. You will need to replace <mysitename> with the configured name of your Azure App Service and put these in the reply URLs section of your Azure App Registration.
URL
https://<mysitename>.azurewebsites.net/
https://<mysitename>.azurewebsites.net/Home/ActivateLicense
https://<mysitename>.azurewebsites.net/Home/NoAccess
https://<mysitename>.azurewebsites.net/Home/Eula
https://<mysitename>.azurewebsites.net/Account/SessionTimeout
https://<mysitename>.azurewebsites.net/Account/InvalidSession
https://<mysitename>.azurewebsites.net/Account/Token