Copyright © 2009 ILS
System Integration: Equipment, Instruments and Databases
Batch Expert is uniquely designed as a platform that integrates equipment, instruments and
achieved through a variety of data interfaces and more importantly graphical user interface (GUI)
generate reports based upon historical data.
System integration will reduce maintenance costs by reducing the count of stand-alone computers
required to control and collected data from differing equipment and instruments. In addition, this
approach allows scientists and engineers adopt more of a plug-and-play approach to instruments
within the laboratory. Instruments such as glucose/off-gas analyzers, scales, pumps, etc. may be
plugged into the existing system and directly applied to control and data analysis with minimal
effort.
With this system based approach, instrument, batch header, and analytical data are centrally
stored in standard SQL compliant databases. This database provides a cost effective means to
archive historical data. These databases can be setup and managed to meet 21 CFR Part 11
compliance by corporate IT departments. The scientists and engineers will greatly appreciate the
time-saving features the database provides. Batch Expert provides database tools that allow the
scientists to download data and create reports with a few simple clicks of the button. This can
include data from continuous measurements, batch header information, and off-line analytical
analysis.
Intelligent Laboratory Solutions provides custom based solutions that can fit the particular needs
of the customer. This includes an evaluation of the current systems, and system engineering and
software design for new systems.
Instrument and Equipment Interfaces
Batch Expert can support many different types and equipment and instrument interfaces,
including ones custom developed for a particular need. The two most common interfaces are OPC
and Serial RS-232/422/485 interfaces. These two common interfaces provide the majority of the
data communication to and from Batch Expert. Other possible equipment interfaces include
software based solutions such as Dynamic Data Exchange (DDE) and direct IO based upon 4-20
mA connections.
The OPC interface strives to provide a common protocol for client/server communication. This
interface is common to Programmable Logic Controllers (PLC) such as those provided by
Allen-Bradley®, Mitsubishi®, Honeywell®, etc. For example, BioEngineering® provides PLCs with
their bio-reactors that are easily accessible through an OPC server.
The most common data interface is a Serial RS-232/422/485 interface. Many hardware vendors
provide a Serial interface. This includes instruments such as those provided by YSI®, and
Mettler-Toledo®, and equipment such as bio-reactors provided B. Braun®, New Brunswick® and
BioEngineering®. Intelligent Laboratory Solutions can provide systems that support Ethernet
based Serial terminal servers. The terminal servers provides one to many serial interfaces on a
standard local area network connection (LAN) without the need of a computer. This significantly
reduces maintenance and increases bench top space by reducing the amount of PCs required.
Intelligent Laboratory Solutions provides system integration consulting for automating
instruments such as pumps, scales, and analyzers. Example includes glucose control based upon
measurements from a YSI® glucose analyzer, where equipment control and material balances are
combined to control a peristaltic pump in unattended in real-time.
Database Interface
Batch Expert can communicate to the majority of databases or similar systems such as LIMS and
data historian systems through an ODBC interface. The most common databases supported by
in-house corporate IT groups are Microsoft® SQL Server and Oracle® databases. These
databases are common and usually fit within the spectrum of corporate supported IT software
solutions. Intelligent Laboratory solutions provides tools and services that tailor these
databases for batch based processes. This includes data archiving and retrieval tools, custom
reporting based tools, and services for 21 CFR Part 11 compliance. Day-to-day laboratory or plant
personnel will reduce their effort and time spent collecting and reporting data, and IT
professionals can maintain common, well known databases.

