A ROUTE is an ETL pipeline that moves data from a data SOURCE to a data TARGET. A ROUTE consists of several elements:
- A SOURCE adaptor that receives data from an external system.
-
SOURCE records:
- A set of fields that comprise the starting point for transformations.
- Are persisted to the K3 database.
- Transformations (Mappings & Rules)
-
TARGET records:
- A new set of fields that comprise the transformed data.
- Are persisted to the K3 database.
- A TARGET adaptor that delivers transformed data to an external system.