Requirements
- Microsoft™ SQL Server 2014 or higher with an existing DAM installation.
- To use the Power BI reporting service, at least one Power BI PRO account with configured on-premises data gateway.
- Digizuite™ Insights files: Database file and the Power BI file.
Database
The database content is delivered as an executable that requires BAK file which has to be restored on the same SQL server instance as the DAM center.
After the restore, you need to run the "spSetup" procedure in order to connect the DAM database using the DAM database name as parameter:
EXEC [dbo].[spSetup] @damdb = 'your_dam'
This will return a result indicating that the DAM database can be reached (echoing the default language selection of the DAM Center).
This step is also required when updating.
Database (scripting)
Unblock and unpack the database zip file into a local folder.
- Create a new Insights database (e.g. "dzreporting") next to the DAM database.
- Create a new SQL server login (e.g. "insights") that has the following properties
:- Default database = "dzreporting"
- Under User Mapping set "db_owner, public" for the insights database, and "db_datareader" for the DAM database.
- Edit the file "Digizuite.Insights.DbUpgrade.exe.config" with a text-editor and change to match you setup:
- ConnectionString
- DAMDatabaseName
- Run the executable "Digizuite.Insights.DbUpgrade.exe" and inspect the output (optionally using the created log.txt).
You can use any SQL authentication you want, just as long as it is the same all over and the permissions are met. This is just an example.
Power BI
- Create a Power BI PRO account and login (or use an existing).
- Install Power BI Desktop on any computer (may be on SQL server).
https://powerbi.microsoft.com/en-us/desktop/ - Open the PBIX file and publish to the Power BI account.
- Download and install the Power BI gateway on the SQL server
https://powerbi.microsoft.com/en-us/gateway/ - Setup the Gateway using the Power BI account and ensure that is is available in Power BI settings afterwards.
- Go to the DataSet in Power BI and enable desired schedule for updating the online cube.
- Optional: Install Power BI Mobile:
https://powerbi.microsoft.com/en-us/mobile/
Self-service access
To setup self-service access you need to create a SQL login that defines:
- Read access to the Insights database using the SELFSERVICE schema.
- Execute rights on the [dbo].[spHelp] stored procedure.
Insights Installation & Configuration Guides
Restoring The Database
Installation & Configuration Part One
Installation & Configuration Part Two
Installation & Configuration Part Three