Glossary term
What is ETL (Extract, Transform, Load)?
Definition
ETL is the process of extracting data from source systems, transforming it into clean and standardised structures, and loading it into a target platform. In PIM, ETL pipelines are used during data onboarding, catalog consolidation, and integrations. It ensures product data is complete, accurate, and ready for downstream usage.
ETL separates source extraction, rule-based transformation, and loading into a destination. For example, an autonomous product data operation could take a supplier export containing lighting dimensions, extract records and convert approved measurement formats, and load validated target values and report rejected rows.
ETL (Extract, Transform, Load) in an autonomous operation
- Step 1:
Input
A supplier export containing lighting dimensions
- Step 2:
ETL (Extract, Transform, Load)
Extract records and convert approved measurement formats
- Step 3:
Outcome
Load validated target values and report rejected rows
Related terms
What is Data Transformation in PIM?
Data transformation in PIM converts raw, inconsistent product data into structured, standardised, and channel-ready formats. It ensures accuracy and...
What is Cross-System Integration?
Cross-system integration connects PIM with ERP, CRM, OMS, DAM, and eCommerce systems to create a unified data ecosystem. It ensures smooth data...
What is Integration Hub / Middleware?
An Integration Hub acts as a central layer that connects ERP, CRM, PIM, and other enterprise systems. It ensures seamless, real-time data flow by...
What is XML Integration?
The process of exchanging product data between systems using XML as a common format.
What is JSON Schema?
JSON Schema defines the structure, rules, and validation constraints for data exchanged through APIs. In PIM, it ensures that incoming and outgoing...
What is Third-Party Data Integration?
The connection of external data sources—such as suppliers, ERPs, marketplaces, or content providers—into the PIM. It streamlines data flow, reduces...