Glossary · 7 · Product information systems and data roles
Source system
Also known as: Upstream system, Originating system
German: Quellsystem
In data integration and data warehousing, a source system is the system from which data is extracted or received for a given data flow; seen from the receiving system, it is the upstream system.
- Data management
- System integration
In one sentence
In data integration, the system from which a data flow extracts or receives its data — the upstream system seen from the receiver.
Example
For the nightly export to the spare parts catalog, the ERP system is the source system, although the part revisions in it were copied from PLM.
Explained in context
Context cards connect this term with others to answer one question. Also in British English and German.
How it applies
- Relative term: Every system is a source system for some flow and a downstream system for another. The term describes a position in one flow, not a quality of the system.
- Documentation: When a value in a document is wrong, the source system of the last flow shows where the copy came from; data lineage shows how far back the path goes.
Source system vs. system of record
A source system is where data comes from in one flow. A system of record is where the value is decided. A source system may hold a copy that is already out of date; being upstream is not being authoritative.
External references
- DAMA International, DAMA-DMBOK: https://www.dama.org/cpages/body-of-knowledge