SAP is built for this, however: Being in a very locked-down corporate environment, I used... Excel. A 'master sheet' output various files to various directori

SAP is built for this, however: Being in a very locked-down corporate environment, I used... Excel. A 'master sheet' output various files to various directories that themselves were permissioned for user access, updated once per minute. Which is a crux: If you're trying to tie a range of systems you need to take into account: * Permissions. If you have user-related data, you probably don't want everyone accessing and/or writing to this data; * Data quality. You're lucky to get a unique ID across these systems, unless you've got a unique ID policy in place.