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!