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.
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).
Note: 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.
- Optional: Install Power BI Mobile:
https://powerbi.microsoft.com/en-us/mobile/
Self-service access
To setup self-service access:
- Create a SQL login under the "SELFSERVICE" schema.