Exo Integration Config

The following steps are involved:

Install SQL Scripts

• On the Workbench database

  • wb_Install_Workbench_WBI_Scripts.sql

  • wb_Install_Workbench_WBI_Exports.sql

• On the WBInterface database:

  • Install_WBInterfaceExo_Scripts.sql

• On each Exonet database:

  • Install_Exonet_Interface_Scripts.sql

  • Set the link to the WBInterface database with a SQL statement like: update dbo.GENERAL_INFO set WorkbenchInterfaceDatabase = 'WBInterfaceExo'

WBIMonitorExo MDE

On a PC with access to the SQL Server:

• Install the latest Access 365 runtime

• Put the WBIMonitorExo.mde into a folder

• Create a shortcut to run the WBIMonitorExo.mde with the /runtime parameter

Run the WBIMonitorExo and choose the Configuration option, and click the Relink button.

Open

Connect to both the Workbench and WBInterface databases.

Back on the main screen, specify the settings (especially these) on the Workbench Database tab

Open

and the WBInterface tab

SQL Job for syncing data from Exonet

Create a SQL Job, on say an hourly schedule, to execute for each Exo database:

exec Exo_01.dbo.X_WB_FROM_Exonet '01'
exec dbo.wbiProcessExportLog