| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "XLCubed App Service"
(→Overview) |
(→Installation) |
||
| (6 intermediate revisions by one other user not shown) | |||
| Line 1: | Line 1: | ||
=Overview= | =Overview= | ||
| − | [XLCubedWeb] can be hosted on-premise or in the cloud. There are several cloud options: | + | [[Web Edition|XLCubedWeb]] can be hosted on-premise or in the cloud. There are several cloud options: |
* Host in a VM with any Cloud provider | * Host in a VM with any Cloud provider | ||
| Line 9: | Line 9: | ||
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. | 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. | ||
| − | [[File: | + | [[File:AppServiceArchitecture.png]] |
=Installation= | =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 | + | 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 |
| + | Contributor role in the Resource Group. | ||
| + | And for the "XLCubed App Service Config" enterprise app to be granted access to the following permissions: | ||
| − | + | [[File:AppServiceConfigAppApiPermissions.png]] | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
==Pre-requisites== | ==Pre-requisites== | ||
| − | + | {{:XLCubed App Service Installer Prerequisites}} | |
| − | |||
| − | |||
| − | A blank SQL Azure database will need to be created | + | 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 next step is to create the App Service resource in Azure: | ||
| − | [[File: | + | [[File:AppServiceConfigGeneral.png]] |
| − | + | You may use any App Service plan level. No other configuration is needed at this point, or you can enable authentication if you'd prefer configure that manually: | |
| − | [[File: | + | [[File:AppServiceAzureAuth.png]] |
==Setup== | ==Setup== | ||
| Line 43: | Line 38: | ||
After running the application you will need to pick the appropriate tenant, subscription, resource group and App Service: | After running the application you will need to pick the appropriate tenant, subscription, resource group and App Service: | ||
| − | [[File: | + | [[File:AppServiceAfterSelection.png]] |
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. | 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. | ||
Latest revision as of 11:17, 30 March 2023
Contents
[hide]Overview
XLCubedWeb 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 Contributor role in the Resource Group.
And for the "XLCubed App Service Config" enterprise app to be granted access to the following permissions:
Pre-requisites
 |
This article refers to the latest XLCubed version. For other versions, see XLCubed App Service Installer Prerequisites/Versions. |
XLCubed App Service Installer requires several packages installed in order to operate correctly:
- Microsoft .NET Framework 4.7.2
- Microsoft Visual C++ 2019 Redistributable (x86) or (x64) Note: install the version appropriate for the Excel architecture you are using
- Microsoft SQL Server 2016 System CLR Types (x86) or (x64)
- Microsoft SQL Server 2016 Shared Management Objects (x86) or (x64)
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:
You may use any App Service plan level. 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.
