Customer data is managed in SAP and transferred to the Latrobe SQL server (by a process outside of the scope of this project). The SQL table is [chemlab].[inquiry].SAP_Sold_To.
As the existing OPTIMAT software needs to refer (and link) to customers in its own “Contacts” data table, the relevant information is further synchronised into OPTIMAT. In this case it is only the customer Code and Name that is required.
No user action, or maintenance of the OPTIMAT customer data, is required.
A background application (MImportCustomersLSS) runs via the Windows Task Scheduler, every 15 minutes, and checks that all of the customer data in the SQL table is reflected in OPTIMAT. Any changes are updated in the OPTIMAT tables.
For interest, or to spot check the data in OPTIMAT, the customer data can be seen in OPTIMAT Menu –> Utilities –> Contacts. Only the fields highlighted have data.
