Skip to main content

Scheduled Synchronization with BI platforms

Pre-requisite#

All the Agents must be configured in the BI Hub platform and the instances must be up and in running status.

Synchronize Users or Reports#

  1. Go to C:\Program Files\Visual BI Solutions\VBI View\VBIViewServer\utilities.
  2. Click on File > Open in command prompt > Open command prompt as administrator and type the command: "BI Hub Instance Synchronisation.exe"
  • The command accepts 2 parameters:
    1. Synchronization option: It can either be Users or Reports to synchronize users and reports respectively.
    2. Instance list: List of configured Instances for which the synchronization process should take place.

      An Instance name with more than one word must be included in double-quotes(").

Here are some sample commands that can be stored in a batch file and scheduled to run using the organization’s scheduling tool:

To Synchronize Users#

#Synchronize users from all instances
"BI Hub Instance Synchronisation.exe" --u -i
#Synchronize Users from certain instances
"BI Hub Instance Synchronisation.exe" --u –i "BOBJ_Rest SSL" Tableau "QlikSense SSL"
  • --u: Users
  • -i: Instance
  • BOBJ, Tableau and Qlik Sense : Instance names configured in BI Hub.
note

Only common users from all the agents will be synchronized, rest excluded.

Sync details

Sync details

To Synchronize Reports#

#Synchronize Reports from all instances
"BI Hub Instance Synchronisation.exe" --r -i
#Synchronize Reports from certain instances
"BI Hub Instance Synchronisation.exe" --r –i BOBJ Tableau
  • --r: Reports
  • -i: Instance
  • BOBJ, Tableau: Instance names configured in BI Hub.

In case of a failure, refer the Troubleshooting section.