3 Set Up Analytics Server

The Analytics server has a three-fold purpose:

  • Hosting SQL server for LS Analytics database.
  • Hosting the Analytics product folder and running the deployment script.
  • Hosting the Integration runtime gateway - used for communication from Azure to LS Central source and from Azure to Analytics database.

It is important that this server is within the same domain as the LS Central SQL server and there are two reasons for that:

  1. If you use a machine on the customer domain that has access to the LS Central source database to run the deployment script, the script can check the connection parameters to LS Central before resources are created in Azure. This prevents errors and unnecessary cost.
  2. Hosting the gateway on a server within the same domain means you can use the same gateway for communication from Azure to LS Central and from Azure to Analytics.

It is also important that this server is always running. It needs to be up and running when the pipelines are scheduled to load data from LS Central to Analytics. Otherwise, the pipelines will not run and no new data will be loaded to the warehouse.

At this point, you can set up everything except the Integration runtime, which will be set up later in the process.

Set up SQL server

If you already have an SQL server with a license that you want you use, which is fine, you do not need to do anything further in this step.

If you are using a new server, check that the server fulfills the hardware and software recommendations set by Microsoft for SQL server 2019.

Whether the server you use needs a full SQL server license or not, is up to the customer and depends on the database size. SQL Express only allows databases up to 10 GB.

We recommend also setting up SQL Server Management Studio.

Prepare hosting Integration Runtime management gateway

The Integration Runtime management gateway will be set up after the deployment of Analytics.

The hardware and system requirements follow the requirements set for the Integration Runtime by Microsoft.

Set up VS Code

To run the Analytics deployment script, the machine should have PowerShell installed. We recommend setting up VS Code with PowerShell extension and then configure PowerShell as described below.

Configure PowerShell

To run the onboarding script, you must have the new Azure PowerShell Az module installed. For further instructions see Introducing the new Azure PowerShell Az module.

Note: You must open the PowerShell 'as administrator' to be able to set up the module.

In case you do not have the Az module installed, run the following command as Administrator in PowerShell:

Install-Module -Name Az -AllowClobber

You must also register the AZ resource provider by running these lines in PowerShell:

Connect-AzAccount

If you have issues with connecting to the correct Azure account, you can add the subscription and tenant/parent management group to the connect command:

Connect-AzAccount -Tenant 'Tenant/ParentManagementGroupIDfromAzure' -Subscription 'SubscriptionIDfromAzure'

This opens an Azure login window in the background where you must log in before you continue with the next line:

Register-AzResourceProvider -ProviderName Microsoft.DataFactory

In order to install bicep, you need to copy and run this scrip from Microsoft:

# Create the install folder

$installPath = "$env:USERPROFILE\.bicep"

$installDir = New-Item -ItemType Directory -Path $installPath -Force

$installDir.Attributes += 'Hidden'

# Fetch the latest Bicep CLI binary

(New-Object Net.WebClient).DownloadFile("https://github.com/Azure/bicep/releases/latest/download/bicep-win-x64.exe", "$installPath\bicep.exe")

# Add bicep to your PATH

$currentPath = (Get-Item -path "HKCU:\Environment" ).GetValue('Path', '', 'DoNotExpandEnvironmentNames')

if (-not $currentPath.Contains("%USERPROFILE%\.bicep")) { setx PATH ($currentPath + ";%USERPROFILE%\.bicep") }

if (-not $env:path.Contains($installPath)) { $env:path += ";$installPath" }

# Verify you can now access the 'bicep' command.

bicep --help

# Done!

Note: If you have already downloaded the product package, you can also run the InstallBicep.ps1 from there.

Download product package zip file

To get the Analytics for LS Central product package from LS Retail you first need to request an Analytics license.

  • Please contact LS Retail license department through email or put in an Additional order request through the portal, if you have not done so already.
  • Analytics for LS Central is included in the NAV and LS Central pricelists that are valid from April 2023 but it is fine to send in requests before that time.

Once license department has processed your request you will receive a link to the request product package form.

Enter the relevant information to the form, and you will receive an email with a download link to a zip file that includes everything you need.

Once you have downloaded and unzipped the Analytics product package to your server, you can start the setup of Analytics.

The package contains a folder with the following files:

  • arm_template folder
    • arm_template - LS Insight.json
    • arm_template_parameters.json
  • Modules folder
    • LSInsight folder
    • LSInsightUtilities folder
  • Power BI templates folder
    • Actionable Insights.pbit
    • Hotel Analytics.pbit
    • Inventory Analytics.pbit
    • Sales Analytics.pbit
    • Supply Chain Analytics.pbit
  • DeploymentScript.ps1
  • Scheduler Job Header.json
  • Scheduler Job Header_Hotels.json

Note: The folder you extracted the package to, will from now on be referred to as the Base folder.

 

< BackNext >