Networked Solutions Access, Management, with OpenLAB CDS Administration, Data Storage and Reporting Features March 14, 2013 Jon Welsh Applications Specialist Agilent Technologies 1 March 15, 2013

Agenda • • • • • • 2 Overview of OpenLAB CDS Remote Instrument Access Instrument Management Centralized Administration Data Storage Reporting March 15, 2013

Overview of OpenLAB OpenLAB manages instruments, people, process and content! Multi-Vendor Instrument Control (OpenLAB CDS) Intelligent Reporting Central Data Storage (ECM or Data Store) Business Process Manager (BPM) Electronic Lab Notebook (ELN) • OpenLAB is a fully integrated laboratory system that links people, processes and data. • Provides all information needed for accelerated decision making. • Web-based, n-tier architecture scalable from small lab to global implementation. 3 March 15, 2013

Overview of OpenLAB CDS • OpenLAB CDS has 2 editions: EZChrom and ChemStation • OpenLAB CDS comes with a Shared Services component common for both systems. Shared Services EZChrom CDS Workflow EZChrom Data Analysis EZChrom Sequencing EZChrom Storage 4 Instrument Navigation Project Navigation User management Permissions User Authentication Software Diagnostics Shared Components Common Reporting Multi-Vendor Control Easy Sequence Wizard New Data Analysis ChemStation CDS Workflow ChemStation Data Analysis ChemStation Sequencing ChemStation Storage March 15, 2013

OpenLAB CDS Scalability Increasing Users/Instruments Enterprise OpenLAB CDS with ECM Enterprise Distributed Distributed CDS-File based OpenLAB CDS with ECM Workgroup or Data Store (EZChrom Only) Networked Workstations Workstations Increasing Functionality 5 March 15, 2013

From a Single Workstation to a Networked Solution OpenLAB CDS Control Panel Central Point for: • • Viewing and Managing Instruments • Administration of users, licenses, storage, and instruments • Centralized Data Storage Solution (ECM or Data Store) • 6 Remote Instrument Access Integrated Intelligent Reporting March 15, 2013

OpenLAB Control Panel Functionality Instrument Management Network Communication Infrastructure • Create/edit instruments and instrument access • Central instrument status overview including activity logbook • Communication between different components of a C/S system Diagnostics Infrastructure Projects Management • Access security for data stored “in” projects • Manage application user privileges per project • Software diagnostics and tracing • Support for workstation as well as C/S systems License Management Users / Groups / Roles Management • User authorization • Manage users and user groups...

Remote Instrument Access 8 March 15, 2013

Remote Instrument Access Overview In a networked configuration, you can control, configure, monitor or launch your ChemStation or EZChrom instrument from any OpenLAB Control Panel that is connected to the OpenLAB Shared Services server. Lab • Centrally store all data, reports, knowledge • Security, versions, audit trail, e-signature • OpenLAB unifies data, information and regulatory compliance 9 Office/Home • Run and reprocess from anywhere • Easily find data and results • Create custom reports March 15, 2013

Instrument Management 10 March 15, 2013

Instrument Management Features Lab-at-a-Glance • View all installed instruments on the system • Tree view lets you view or organize instruments in a hierarchy of locations • View the instrument name, status, location, type of instrument, and more Create, Edit, or Delete locations and instruments Edit Privileges, Notifications, and Printers for a location or instrument • Control which user, group, or role has access to a location or instrument • Send email notifications to a user, group, or role when one or more events occurs within a location or instrument (e.g. send a notification to a group...

Centralized Administration 12 March 15, 2013

Centralized Administration Features Review the settings of the logged user: email, roles, etc… Review the available servers Review / edit the configuration of your system (workstation, storage type, etc…) Manage users, user groups, roles Add new licenses Create links to preferred websites Review the list of available instrument controllers Manage printers Lists all actions performed in the Control Panel and instrument activity Create adminstrative reports about your system 13 March 15, 2013

Data Storage 14 March 15, 2013

Advantages of OpenLAB Central Storage Efficient Data Storage and Retrieval • • • • Centralized storage for OpenLAB CDS Supports project based organization and rights Files can be efficiently searched and retrieved Local language support (Chinese & Japanese) Secure repository for storage of raw data and reports fullfiling 21 CFR Part 11 and GMP/GLP requirements. Security • • • Fully secures data Authorizes access for registered users with roles Integrates with OpenLAB Control Panel OpenLAB Data Store or ECM Data Integrity and Traceability • • • • File history is maintained Activities are fully...

Intelligent Reporting • State-of-the-art Intelligent Reporting is fully integrated into the ChemStation and EZChrom allowing you to easily create standard or custom reports • Report across runs for multiple instruments on the same report such as instrument utilization • Create various types of reports based on the same data set • Reports can include standard or advanced result calculations • View reports on-line, printed, or save to files (e.g. PDF, MS Excel) 17 March 15, 2013

Intelligent Reporting Features Integrated into EZChrom and ChemStation, the easy-to-use report template editor allows you to create reports using simple drag-and-drop and configuration operations. 1 Select a Report Layout from the list of pre-defined or custom Configured templates. 3 From the WYSIWYG editing pane, edit the report title, add a logo, reposition report items, or edit the properties of a report item. 2 View, Print, Save, or customize your report by selecting a Report Item, then dragging and dropping the report item into the editing pane. 18 March 15, 2013