Digizuiteā„¢ Insights 5.6.x - Installation

Owned by Niels Erik Knudsen (Unlicensed)
Last updated: Jul 05, 2023 by Katrine Birk
2 min read

Steps

  1. Back up database

  2. Get install files and edit variables in install.ps1 file

  3. Run install.ps1 as admin from PowerShell

Installing Digizuiteā„¢ Insights

TheĀ Digizuiteā„¢ Insights module is installed using Powershell. The Package, provided by the Digizuite DAM Vendor is a zip file with the following structure:

NOTE

If Datasynchronziation in PowerBI fails with cyclic reference errors - use pbix file from 5.6.1

OR modify the 5.6.o pbix file as follows

the issue is newer PowerBI Apps do not allow the parameterName Schema - Select Transform Data, and rename the parameters (left pane)

  • DatabaseĀ ā†’ parDatabase

  • SchemaĀ ā†’ parSchema

  • ServerĀ ā†’ parServer

Click Close & Apply + Refresh



How to Install

To install theĀ Digizuiteā„¢ Insights module, do the following:

  1. Edit Install.ps1, see ā€˜Variablesā€™ section for a description of all the parameters

  2. Run the Install.ps1, as administrator, either from Powershell or the PowerShell ISE

Variables

Variable

Mandatory

Description

Example

Variable

Mandatory

Description

Example

ConnectionStringMaster

True

ConnectionString to Master Database on the SqlServer that should contain the Insights Database

Server=SERVERNAME;Initial Catalog=master;Integrated Security=SSPI;Persist Security Info=False;MultipleActiveResultSets=False;

ServicesFolder

True

The path where Insights service should be installed

EH:\Services\Digizuite

connStrDam

True

Connection String to Dam Database (copy from Dam site Web.config)

Ā 

damSiteFQDN

True

Fully qualified Domain Name of the Dam Center

dc.digizuite.com

DbName

True

Database Name of DamCenter Database

Ā 

InsightsDbPassword

True

SQL Password for Insights User

Ā 

LogRoot

False

Root folder for LogFiles

H:\LogFiles

Ā 

Power BI

When Insights is installed, configure PowerBI

Troubleshooting

Per default, PowerBI will try to logging as a Windows user.

If you wish to log in with the generated MS SQL user instead,

FileĀ ā†’ Options and settingsĀ ā†’ Data source settings

Add your user, and then press: Edit permissions



Under Credentials, press Edit

Select Database, beneath Windows, l and add your login credentials here



Now, you should be fully prepped for logging in to PowerBi.