Data warehouse
A data warehouse is a database used by decision support systems. Data is usually exported from one or more operational systems for analysis.
On this page
Source content checked . English translation published 2026-10-27.
In business automation
A data warehouse centralizes information from operational systems for reports and decisions, not for continuously updating every order. In automation, it is a destination for scheduled synchronization or a source for reading, not a replacement for the live CRM.
Examples
These examples illustrate a possible workflow. Adapt the connections and rules to your own systems.
Copying orders to an overnight report
At the end of the day, a process copies closed orders to a data warehouse. The marketing report reads from there. Same-day status updates remain in the order system and are not written directly to the report, so there are not two sources of truth.
Relevant tools
- n8n
- You can schedule extraction from operational systems and loading into an analytics destination, provided the mapping and keys are defined in advance.
What to check
- Bidirectional writes between the warehouse and the operational system create conflicts that are difficult to resolve.