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.
Connect to both the Workbench and WBInterface databases.
Back on the main screen, specify the settings (especially these) on the Workbench Database tab
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: