Normally I'd use SSIS for these types of integrations, but I don't know if you can make that flexible enough without having to train the business users to be able to create SSIS packages, so that may not be suitable
Another option that may work is to use Record Creation and Update rules. The general approach is:
- Create a custom activity entity with fields for the data that users might want to update
- Create a Record Creation and Update rule to update the regarding entity
- Create a data map, and have users import data using the data map into the custom activity entity
If you have multiple entities that you'd need to update, then you'd need to repeat steps 2 and 3 for each entity
Microsoft CRM MVP - http://mscrmuk.blogspot.com/ http://www.excitation.co.uk