System Interfaces

SAP Interface

Waters Millennium/Empower Interface

NuGenesis Interface

NWA Quality Analyst Interface

One of the key benefits identified by our customers is the ability to interface LabWare LIMS to other systems within the company. LabWare has an excellent track record of successful bi-directional interfaces, both to other vendor solutions as well as to in-house systems.

LabWare LIMS has been integrated with many other business systems including SAP R/3, BPCS, Movex, and JD Edwards among others. In addition to ERP systems, we have integrated to a wide range of other process control systems, MRP, planning, accounting packages, mail systems and productivity packages. Many of these systems are proprietary in-house systems that need integrating into the LIMS environment.

Some of the features that facilitate system-to-system communication are:
  • Import / export - A standard import / export utility allows automatic sample login from external systems or exchange of information. This utility uses XML and CSV file formats and can be easily configured using a standard spreadsheet editor.
  • Event Triggers - Any activity can be initiated from a trigger that allows a routine to be executed that will export data to an external system.
  • LabWare LIMS can read and write to the databases of external applications, so in many cases it is not necessary to do much configuration on the other applications' side.
  • Scheduled events, such as reports, sample login and LIMS Basic routines can be predefined and then run based on a schedule.

LabWare LIMS provides extensive interfacing capabilities with other systems to allow for information to be shared between systems and not have to be manually re-entered.

The capabilities that can be utilized for interfacing include the following:
  • Files (XML, CSV, etc)
  • Database Tables
  • Dynamic Data Exchange
  • Mail Messages
  • RS-232 Serial Communications
  • Import / Export Files
  • Dynamic Link Library
  • External Program Execution
  • LabWare LabStation
  • FTP
  • TCP / IP Sockets
  • OLE Automation, ActiveX

SAP R/3 - LabWare LIMS has a SAP-certified interface with SAP R/3's QM module, following an interface specification called QM-IDI. This interface is enabled on both the SAP and LIMS applications. Additionally other transfer mechanisms can also be utilized to provide seamless integration as required.

Waters Millennium32 and Empower - LabWare are a premier partner of Waters and provides a direct interface between LabWare LIMS and Waters Millennium32 / Empower Chromatography Software, which has been designed using the Millennium Toolkit. Using the interface, scientists can remain within LIMS while performing most common chromatographic workflows such as assigning LIMS samples to run sequences, monitoring real time data collection, and reviewing and approving processed results before they are committed to the LIMS database. Regulated laboratories needing to comply with the FDA's 21 CFR Part 11 ruling are major beneficiaries because the interface is validated and provides seamless exchange of electronic records without generating any disk files. The interface leverages the built-in security and audit trails in both LabWare LIMS and the Millennium32 / Empower software and can be configured within minutes.

Microsoft Office products - LabWare LIMS can create native Microsoft Word documents and Microsoft Excel spreadsheets, without going through an interim format such as RTF and CSV files. It is also possible to create reports by opening Microsoft Word and / or Microsoft Excel and "tagging in" the desired LabWare LIMS data.

Microsoft Exchange and Lotus Notes - LabWare LIMS provides full compliance to the MAPI and VIM standards, and hence can be used to automatically e-mail reports, as well as warn appropriate users of Out of Specification results.

Major systems interfaced include:
  • BaaN
  • BPCS
  • JD Edwards
  • Movex
  • Optiva Formulation System
  • Oracle GEMMS & Financials
  • PI
  • PRISM
  • SAP
  • Various In House systems
Copyright 2005 LabWare, Inc.