How can files from islands of automation become GMP compliant? InfoBatch InfoETL is a product suite that can take stranded files from equipment skids, instruments, and HMIs and store them in a secure archive accessible to the InfoBatch reporting engine.
Request Demo
When “File” is a Four-Letter Word
Numerous manufacturing systems generate text files that, if not handled appropriately, cause data integrity vulnerabilities. The potential risks on product integrity and release can be significant. Data files may also contain valuable operational information that cannot be effectively utilized without additional processing.
When files need to be compliant, InfoBatch InfoETL is the solution. Data is extracted from the files, transformed to meaningful information and loaded in a secure repository. InfoBatch InfoETL provides an ETL (Extract-Transform-Load) framework suitable for manufacturing and automation systems. Whereas many ETL solutions are oriented towards cloud-based data warehouses, InfoBatch InfoETL is designed to reside close to the automation infrastructure, immediately processing files without the latency of other approaches.
InfoBatch InfoETL and data warehouses are not mutually exclusive. In fact, InfoBatch InfoETL databases can be used to buffer information that is subsequently uploaded to enterprise systems.
Connecting to Files
InfoBatch InfoETL can be used to process a wide range of manufacturing data. Typical inputs include CSV, XML, SQLite, and JSON files from a variety of devices including instruments and analyzers, equipment skids and HMIs.
Just a few compatible data sources:
- DeltaV Spectral PAT
- Rockwell HMI
- RAM5 (Resodyn Acoustic Mixers)
- HAMO Washer
- Tablet Press
Key Features
Service-based file extraction that does not rely on scripting
System transforms data into meaningful information
System loads data into secure local data repositories
Original data files are securely maintained to satisfy data integrity requirements
Unlike conventional process historians, archive technology handles complex data records
Repository seamlessly auto-archives to satisfy data retention policies
Archive supports SQL queries, ensuring integration with third-party reporting and data transfer applications
Key Benefits
Ensures compliance with GMP data integrity guidelines
Eliminates custom scripting that can be prone to failure
Ensures secure and reliable end-to-end data processing
Enables critical manufacturing data to be digitized in a manner that supports reporting and integration with other manufacturing and information systems