Configure Digizuite.Insights Synchronization

Owned by Niels Erik Knudsen (Unlicensed)
Last updated: Jan 20, 2022
1 min read

Insert labelids for Meta Combos that should be synchronized to PowerBI, must he inserted in the table dbo.SyncLabels in the Insights SQL Database.

Note: Only Tree and Combo datatypes supported.

Note: only use one language / AutoTranslate

 

Insert Into dbo.SyncLabels (LabelId) values (51835),(51839),(51540) GO

 

Force a complete data synchronization.

  • Stop the Insights service

  • Run the following sql

Delete from dbo.sync_change_tracking_info

  • Start the Insights service

Verify that data is transfered

 

Select * from SELFSERVICE.ComboValues Select * from SELFSERVICE.TreeValues