XLCubed App Service

Overview

Web Edition can be hosted on-premise or in the cloud. There are several cloud options:

• Host in a VM with any Cloud provider
• Run in an App Service in Azure

If connecting to Azure-hosted data sources or PowerBI then the Azure App Service offers an automatic flow of security, as well as fitting in well with the Azure architecture.

Installation

The easiest approach is to install the XLCubed App Service installer. This is installed on a client machine and runs through the configuration of the App Service, this needs the user running the App to have the following access:

And for the "XLCubed App Config" enterprise app to be granted access to the following permissions:

Pre-requisites

The following page contains the pre-requisites that need to be installed on the client machine before running the setup application:

[XLCubed App Service Installer Prerequisites.png]

A blank SQL Azure database will need to be created, this can be at the lowest sizing, you will need the connection string and allow access from other Azure resources.

The next step is to create the App Service resource in Azure:

The minimum level is: ****, no other configuration is needed at this point, or you can enable authentication if you'd prefer configure that manually:

Setup

After running the application you will need to pick the appropriate tenant, subscription, resource group and App Service:

You will now be guided through the setup and any changes that need to be made will be shown and you can either allow the application to apply the change or make it yourself manually.