...
The database content is delivered as an executable that performs all necessary updates an existing Insights database.
Step 1 and 2 are only necessary for new installations. If performing an update you may skip to step 3.
Step 1 (only for new installations):
- Create a new Insights database (e.g. "dzreporting") next to the DAM database.
...
- Create a new SQL server login (e.g. "insights")
...
- .
You can use any authentication you want (Windows/SQL), but it should have the following properties:- Default database = "dzreporting" (database created in 1)
- Under User Mapping set "db_owner, public" for the insights database, and "db_datareader" for the DAM database.
...
...
You can use any authentication you want (Windows/SQL), just as long as it is the same all over and the permissions are met. This is just an example.
- Unblock and unpack the database zip file into a local folder.
...
- Edit the file "Digizuite.Insights.DbUpgrade.exe.config" with a text-editor and change to match you setup:
- ConnectionString (use credentials created in step 2).
- DAMDatabaseName
...
- Run the executable "Digizuite.Insights.DbUpgrade.exe" and inspect the output (optionally using the created 'log.txt').
Power BI
- Create a Power BI PRO account and login (or use an existing).
- Install Power BI Desktop on any computer (
...
- recommended is the 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 any computer (recommended is 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:
...