Requirements
- Microsoft™ SQL Server 2014 or higher with an existing DAM installation using the DBO schema.
- To use the Power BI reporting service, at least one Power BI PRO account with configured on-premises data gateway.
- Digizuite™ Insights files: Database BAK file and the Power BI PBIX .
Database
The database is delivered as a 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.
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
Part One
Part Two
Part Three