Our client provides a data file with Cost Center members including Parent/Child Relationship. They would like to Automatically update new Cost Centers when the data file is loaded. Any existing Cost center moves from one parent to another should also be handled (instead of Merging it should Replace).
Appreciate any pointers or advice if anyone has worked on solving similar requirement.
The MarketPlace app Application Control Manager is probably where you need to start. It has processes and business rules for automatically updating the metadata.
The Metadata with Parent - Child Relationship reside within the data file and we want to update the members during data load. Is ACM suitable to load data file as well?
I am far from an ACM expert. As far as I know ACM is not configured to import data files but it does manage the process of creating metadata members. You would need to write an event handler (probably TransformationEventHandler) to pick up the new metadata members and hand them over to an ACM-like process. That would involve populating the custom ACM tables with the metadata info and then committing those changes. You would need to install the ACM app and then import some test metadata and follow it through the process so that you can then adapt it to a data file import.
