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.
Comments (4)
The expert installs ok, but I can't sychronize the PM with its dependants because the dependencies list shows up empty (the PM *does* have a few dependencies).
Posted by Deny Watanabe | February 8, 2008 10:12 AM
Posted on February 8, 2008 10:12
Hi
Could you describe your pluggable map, what operators are in it? I remember an old bug where the dependency OMB command didn't return dependencies if the pluggable didn't represent what was though of as a data flow, but this may not be the problem. Are your operators connected to either the mapping input or output group?
Cheers
David
Posted by David Allan | February 18, 2008 10:15 AM
Posted on February 18, 2008 10:15
Hi,
Are there any known issues related to this expert? I'm having a few problems to get this to work... When I start the expert on the context of a pluggable mapping it throws me an error because the value of the $P_SRC_PATH variable includes the workspace name resulting on a "path X is outside of the current Project" error message.
I'm having a lot of issues with pluggable mappings but I don't think they are related...
Posted by Bruno | April 16, 2008 3:13 AM
Posted on April 16, 2008 03:13
Hi Bruno
An updated expert has been posted and the original post updated to reference this update, download here;
Cheers
Posted by David Allan | April 18, 2008 1:26 PM
Posted on April 18, 2008 13:26