Loading small batches of master data–and maintaining governance
Here’s the trouble with information governance: governance requires enforceable policies for key master data elements. Good. Fabulous. But *sometimes* the business perceives that enforcing these policies takes too much time. Now, what some of your ingenious data creators will do—when time is of the essence–is try to find ways around the information governance policies.
What we need to do is to give the business tools to load small batches of data (creating 20 suppliers at once, for example) very quickly, while still enforcing all of the relevant information governance policies.
One way to do this is with an Excel upload into Master Data Governance. I bet you didn’t know you could do that. Lars Reuter has created a Code Exchange piece to do just that. There are two major benefits:
- Enter small batches of suppliers quickly into an Excel spreadsheet and submit.
- All relevant Master Data Governance policies are still executed and enforced.
Sounds like the best of both worlds to me!
Overview (make sure to accept the Terms and Conditions. There will be a slight delay to verify the terms.)
Using the Excel Upload
Installation and Configuration
Please let us know what you think.
Not sure why, but none of the links work for me...
The links won't work until you accept the Terms and Conditions, and then there is a delay for verification.
Looks like after the migration to Code Exchange 2.0 the project excel2mdg no longer exists... Are you able to open it from your side?
I'll have to call in Lars Rueter on this one, as he created the Code Exchange project. Lars?