Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company. Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company.

Using MSDgen Interfaces

Dale Augustyn August 9, 2017

Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company. Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company.

MSDgen Interfaces • MSDgen Formulation Interface (DMgen) • MSDgen Data Export Interface (DEgen) • MSDgen SDS Distribution and Label Generation

Interface (DLI)

Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company. Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company.

Typical Environment

Material based Import Interface Source Data

Formulation System

Testing Lab Data Collection System

Order Entry System

Transaction based Interface Source Data

Material based Export Interface Data Labeling System

DMgen Formulation Interface

DMgen SDS and Label Distribution Interface

DMgen Material Data Export Interface

Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company. Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company.

Integrating DMgen Formulation Import Interface

Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company. Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company.

DMgen Benefits • Synchronization of multiple and diverse systems • Single point of entry for testing lab data values • Consistent procedure to introduce data into the

Material Management workflow • Material classification is consistently and

automatically triggered as a result of new information

Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company. Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company.

DMgen Data Types • Physical / Chemical • Formulation • ATN • Material Attributes • DSD/DPD • Toxicological • Eco-toxicological • GHS • Glossary • Translation Phrases

• Dangerous Goods • Archive Template • Hazard and Regulatory • OELS • MSDgen Settings • Product Specifications • REACH • Regulatory Information • Synonyms

Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company. Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company.

DMgen Data Transfer Solutions • COFFEE • Direct access to the DMgen tables in the

MSDgen schema • Macros and Batch Streams

Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company. Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company.

Batch Stream

Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company. Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company.

Prepare Data Tables

Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company. Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company.

Import Material Data Records

Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company. Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company.

ASCII File Mapping

Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company. Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company.

Execute DMgen

Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company. Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company.

Execute Batch Stream

Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company. Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company.

DMgen COFFEE Process

Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company. Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company.

COFFEE Import Records

Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company. Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company.

COFFEE Execute DMgen

Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company. Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company.

Direct Access to Records

Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company. Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company.

Direct Access to Execution

Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company. Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company.

Import Process Control • Keep individual Record sets separate to avoid

interference • Loop processing of multiple Record sets • Using Triggers in the external system • Sweep of changes that have been made in the

external system • Single execution instance

Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company. Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company.

Running Calcs and Rules • Using Multi-Thread Service

Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company. Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company.

Finalization Control • Windows Scheduler Task • Batch Stream Execution Interval • Execute MSDgen using a Batch Stream

command line • COFFEE Instance

Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company. Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company.

Finalize Materials Batch Stream

Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company. Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company.

Finalize Materials Macro

Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company. Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company.

Macro Users Processes

Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company. Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company.

DMgen Status Handling

Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company. Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company.

Integrating DMgen Material Export Interface

Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company. Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company.

DEgen Benefits • Reliable single source of classification data • Provides data that is responsive to changes in

formulation and other material characteristics • Automatic synchronization of data to all external

processing systems • For example, automatically pre-populate data

value lists and other information displays

Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company. Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company.

MSDgen Transport Information

Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company. Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company.

Sample Order Entry Window

Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company. Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company.

DEgen Data Transfer Solutions • COFFEE • Macros, ASCII File exports and Batch Streams • Direct access to the DEgen tables in the MSDgen

schema tables

Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company. Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company.

DEgen Features • Foreign language translation using MSDgen

language phrases • Control over which materials to export • Data Export Modes

– Full – Incremental – Full Upon Change

Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company. Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company.

Integrating DMgen SDS Order and Label Distribution Interface

Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company. Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company.

DLI Benefits • Automated creation of labels • Full support for transaction data from the

external system (i.e. weight, addresses, order #) • Automatic creation of all associated regulatory

documents • Automatic processing of grace periods for

Document distribution

Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company. Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company.

Data Transfer Solutions • COFFEE • Macros, ASCII File imports and Batch Streams • Direct access to the DLI tables in the MSDgen

schema

Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company. Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company.

Document Configuration

Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company. Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company.

Printer Configuration

Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company. Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company.

DOCUgen Document Creation

Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company. Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company.

Label Prompts in DLI

Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company. Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company.

Sample Label

Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company. Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company.

Document Integration • DLI • DOCUgen • Print Queue • Label Generator • Smart Queue

Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company. Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company.

Print Queue Consolidation

Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company. Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company.

Label Request Consolidation

Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company. Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company.

LABELgenerator Search Process

Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company. Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company.

LABELgenerator Documents

Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company. Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company.

LABELgenerator Printing

Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company. Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company.

Associated Interfaces • Document Data Extract • Transparent Data Extract • Indexed Image Import • SAP EHS modules • SAP Material Master module

Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company. Proprietary and Confidential. Not to be distributed or reproduced without permission of 3E Company.

Q A

Thank You!