SQL database export

Starting with object generation 4.58, SCOUT and CODE can export data like fit parameters or values of optical functions (in CODE also integral quantities) to external SQL databases. If you have done a measurement with a spectrometer system and performed a fit of a model you can send the results to your company database.

We have implemented an ADO database connection which lets you contact Microsoft, Oracle and Informix databases. Before you can do that the corresponding client software has to be installed on your computer.

Which values are exported to which columns of the open database table is defined in scripts. Scripts are view elements which appear like a button in the main view. When clicked they execute a sequence of commands, including calling other scripts.