Synchronizing Pluggable Maps
By David Allan-Oracle on Jun 05, 2007
This post illustrates a simple process to determine which maps depend on a pluggable mapping component and to actually synchronize them. The MDL
for the expert is here, feel free to download, use, comment and enhance;) It works for OWB 10gR2 and 11g.
After importing the MDL the following 2 steps are a one-off to setup the expert in the repository. You can add a shortcut to run the expert from a pluggable map (the expert only supports pluggable mappings just now);
You will see a dialog, click on the box next to SYNCHALL, now the setup is done!
Now you can actually run the expert from the main tree as if it was another OWB component;
Now the fun starts! You should see a dialog appear with all the maps
that use your component, I have 2 maps that use my pluggable map;
You can select multiple maps and click OK to synchronize. Be patient, you will get a dialog indicating the expert is complete. If you want to see what goes on behind the scenes you can switch the log window on and the task assistant (both expert properties) and see the OMB that gets executed, in the end there are statements such as the following executed to synchronize dependent mappings;
Feel free to
look under the hood of how this works and hope it is useful.