...
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:
...
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:
exec Exo_01.dbo.X_WB_FROM_Exonet '01'
exec dbo.wbiProcessExportLog