...
- 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 installer and the Power BI file.
Database
| Note |
|---|
This step is also required when updating. |
Database installation / update
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:
| Code Block |
|---|
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).
| Note |
|---|
This step is also required when updating. |
Database (scripting)
Unblock and unpack the database zip file into a local folder.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.
Step 2 (only for new installations):
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.
| Info |
|---|
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. |
Step 3:
Unblock and unpack the database zip file into a local folder.
Step 4:
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
Step 5:
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 (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/
...