Database handling and interactions with databases is a key area in automation. Often it is easy to generate large amounts of data, but less easy to automate its storage. OVERKLORD offers full integration tools to common database formats.

There are several key stages (not all of which are used on every system):

• Receive instructions for sample preparation/analysis from external source
• Collect data from the automated system
• Archive all runtime data
• Perform data manipulation or data reduction to get key results
• Report key results to external source
• Data Handling

Often the data from the analysis method (usually a plate reader) is in a format decided by the plate reader manufacturer, and usually contains a large amount of unwanted verbiage. OVERLORD allows the user to call either a Microsoft Visual Basic Script or Microsoft EXCEL, either of which will reduce the information to the required key data points, and restructure the information ready for integration with the next data level.

The external source can be a database of a flat file data repository. OVERLORD and OVERLORD Scheduler can interact with a number of different types of external source.

For data and method input, the OVERLORD suite of products can receive information from a flat data file or database table. For data output, OVERLORD can send information to flat data file or database table.

A flat file is a text file or binary file, although the most common form is a comma separated variable or csv file (each line relates to the information of one sample, multiple information per sample is separated by commas, see below).

Any database that conforms to the Microsoft ODBC standard can be used for input and output with OVERLORD, these include Oracle, SQL and of course Microsoft Access.

Using Overlord2 with a Database, download presentation

• Enhanced tools for data exchange with a wide range of sources
• OVERLORD fits in with your system, not the other way around