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