...
- 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 file.
Database
The database content is delivered as a 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:
...
| Note |
|---|
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/
...