The data warehouse I've built gets data from transactional databases, web services, flat files, and a few other bits and pieces. It also writes back to some of these, and to analysis tools. I'm building a unified system for passing changes between these different systems, and it occurs to me that I don't have a single simple term that covers them all.
- "Database" and "service" are correct for some, but not all.
- "Data source" implies that these only supply data, which is not correct.
- "System" and "data system" are correct, but very vague.
- "End point" fits my mental model of spokes connected to the data warehouse hub. It's not true in that some of these systems to talk to each other directly.
What term do you use for all the systems you integrate, as part of a data warehouse or just in general? Ideally I'd like a single word which will make intuitive sense to both DBAs and non-technical parties.