Certificate of Analysis Solution (COAS)
Automated processing of Certificates of Analysis
Chemical and pharmaceutical companies, food corporations, semiconductor equipment manufacturers and many other businesses which process Certificates of Analysis from various product suppliers will certainly benefit from incorporating SiMX COA solution into their daily operations. For a long time SiMX helps Air Liquide U.S. operations to automate and support COA related workflows. The solution implements dozens of data extraction templates which automatically parse COA documents from over thirty different suppliers.
SiMX agile data extraction components receive data through emails, web scrapping, HTML requests, FTP, SFTP, and proprietary protocols or programming interfaces.
Certificates of analysis in the form of PDF, Word, Excel, XML, HTML, and text documents are handled with no human interaction. The extracted product data is validated against norms and limits lookup tables. All valid products are loaded into a database. All problems and their reasons are listed in exception reports and emailed back to the managers. All that is done 100% automatically on a predefined schedule.
The main worker horse of the process is SiMX TextConverter 4 - the leader in the data parsing technology. The tool facilitates creating data extraction templates in minutes, making it very easy to adopt new COA layouts from new suppliers.
The reversed process of creating COA output documents is also supported by the solution. XML output for digital data transmission and human readable formats such as PDF, Word, HTML, or Excel can be produced from product data stored in a database. All database systems are supported.
The solution also implements web portals for accessing, validating and dynamic querying the processed data. Interactive executive, performance, and exception reports can be available online.
Cutting Adge Technology
- Retrieving data from anywhere - emails, websites, HTTP and programming interfaces
- Extracting loosely structured data from any file formats - PDF, Word, Excel, HTML, TXT, etc.
Visual setup for single and multi-line templates, tag based and multi-line fields
Multiple templates and multiple input dictionaries to support hierarchical (multi-level) data extraction
Visual feedback, dynamic highlighting of the data to be extracted - what you see is what you get
Export of all input lines skipped by the extraction process will help to make sure that nothing was missed inadvertently
Auto parsing of composite input values like street addresses and names
Input and output filtering using lookup tables, regular expressions or scripting
Calculated fields support
TextConverter 4 integration with TARGET Reports facilitates further data analysis and presentation
- Loading the extracted data into any database (SQL Server, Oracle, DB2, Access, Excel, etc.)
- Reconciling incoming data with the data in the system
- Data analysis, reporting, PDF refactoring
Top N and Bottom N reporting at any grouping level
Aggregate fields for ratio calculations
Multiple data sources per report document
Cross-database joins (Oracle to Excel i.e.)
Summary, detailed, and summary with details reports
Table, crosstab, and graph layouts
More than 15 different charts with support for two levels grouping
Output formats: PDF, Excel, RTF, HTML, XML/XSL
Export to any database format
Grouping by ranges (scales)
Recursive calculated fields
SQL and VB Script calculations
- Automated exceptions handling and notifications
- Web portals for data access, interactive querying and reporting
How it works
Please email us with any questions or suggestions.