Auto-Pilot · Consolidation

Scattered data and formats become one workspace.

Scattered data and formats become one workspace.

Scattered data and formats become one workspace.

ERP export.csv, bills of materials.xlsx and supplier declarations.pdf are automatically analysed, classified and merged into a shared database. Your QA leadership signs off.

In use by
JUNGHEINRICHSCHOCKSIKAWIKALINDIG
What this is about

Built for QA teams that turn Excel silos and supplier documents into a verified database, without keying every substance into ten spreadsheets by hand.

Four building blocks

This is how automation becomes audit-ready.

PDFXLSXCSVSCHEMA

Multi-format ingestion

PDF, Excel, CSV, IMDS-XML and free-form email text all go in. The schema is detected automatically.

SUPPL.SUBSTANCEBOMPRODUCTCUSTOMER

Auto-classification

Suppliers, substances, bill of materials, products and customers are recognised and sorted automatically.

CUSTOMER K001Bosch10 suppliersSUPPL.TE CONNECT.SUPPL.COROPLASTSUPPL.BOREALISSUPPL.HARTING

Relationships mapped

Who supplies whom with which component? Aggregation per customer and supplier at the push of a button.

Analyzing document📎 ERP_Demo.csvStructure with 5 scopes and 14records prepared. Check thedatabase view.all correct

Sign-off assistant

The AI assistant explains every classification. QA leadership accepts with a click or corrects entries one by one.

Automated Consolidation in Action

From the first source to a connected database. In four steps.

Inbox · Sources5 active
CSV
BOM_2026_Export.csv
ERP master data · 8,412 rows
PDF
REACH_Erklaerung_Murata.pdf
Supplier document · 4 pages
XLS
Substanzliste_Q2.xlsx
Manual upload · 234 rows
@
RE: Cu-Legierung CW024A
Supplier email
API
SAP MM Integration
Live connection · every 4h
PDF
Zertifikat_ISO9001.pdf
Manual upload
Step 01

Structured and unstructured data in one source.

On one hand, you have the ERP export and bill of materials (BOM); on the other, around 1,200 supplier documents across PDF, Excel, and email. Auto-Pilot analyses both environments, extracting substances, CAS numbers, and compliance statuses to consolidate everything into a single, unified database.

Schema detection23 columns classified
ColumnTypeClassified
Article numberSTRINGPrimary Key
SupplierSTRINGForeign Key
CAS-Nr.STRINGSubstance ID
SVHC contentDECIMALSubstance value
Last checkDATETimestamp
RoHS complianceBOOLEANStatus-Flag
Datasheet URLURLSource reference
Step 02

Schema and data types detected automatically.

For each source, the Auto-Pilot analyses columns, classifies data types, and determines the hierarchy. Seven steps, one minute. Zero manual configuration required—even for the 800th document.

Classification · Domains
ArticleDomainTags
MAT-1247Raw materialREACH · RoHS · PFAS
PCB-M450AssemblyRoHS · WEEE
SERVO-711Finished productREACH · Customer duty
DICHTUNG-FKMComponentPFAS · REACH
CoroplastSupplierActive · ISO 9001
SVHC-Liste 31RegulatoryEU · Live
Step 03

Data classified, sorted into areas.

The Auto-Pilot automatically creates five distinct sections: suppliers, substances, bills of materials, products, and customers. Every entry is precisely allocated to the correct section, with cross-references to other areas displayed as colour-coded pills.

Relationships aggregated5.247 Nodes · 14.892 Edges
SupplierSubstanceComp.ProductCustomer
TE Conn.1274126412
Murata84298479
TDK712343911
Vishay62187327
Coroplast1254188
LANXESS194196
Borealis21982711
Step 04

Relationships aggregated, at the push of a button.

Per customer, per supplier, and per substance, you can immediately identify key interdependencies. Should the ECHA place a substance on the SVHC Candidate List tomorrow, you will know within two clicks which of your customers are affected and which suppliers you need to contact.

"A product is compliant only when all of its components are. You map that automatically for us."
Managing Director · Speciality chemicals DACH · Reference customer
three related auto-pilots

What happens after Consolidation

Ready to see the database?

Discover how we turn your ERP export into a connected database.

We will demonstrate automated consolidation using a data structure tailored to your requirements. No slides, no sales pitch: we will present the live workspace directly.

Reply within one business day · No obligation · No sales pressure