Welcome to All Things Warehouse Builder

  • ETL
    June 5, 2007

Synchronizing Pluggable Maps

David Allan

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);
Experts Add Remove:

You will see a dialog, click on the box next to SYNCHALL, now the setup is done!

Experts Sync:

Now you can actually run the expert from the main tree as if it was another OWB component;

Experts Synchronize Dependents:

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;

Experts Sync Run:

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.

Join the discussion

Comments ( 10 )
  • Deny Watanabe Friday, February 8, 2008
    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).
  • David Allan Monday, February 18, 2008

    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?
  • Bruno Wednesday, April 16, 2008
    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...
  • David Allan Friday, April 18, 2008
    Hi Bruno

    An updated expert has been posted and the original post updated to reference this update, download here;


  • guest Monday, May 23, 2011
    A Synchronizing Pluggable Maps looks good to me and very helpful.
  • guest Tuesday, May 24, 2011
    When i try to synchornize after importing process flows, the functions inside the process flows lose their default parameter value. But if i just import don't synchronize it, they retain the value.
    Here is the command i use to synchronize
    Here is the OMBPlus command i use to synchronize
    I don't know why it loses the value when i synchronize it.
  • David Monday, June 6, 2011
    Hi Guna
    Sorry I missed this comment after the blog migration. Did you resolve this, or its a bug?
  • Richard Tuesday, March 18, 2014

    Where can we find the updated expert. The version I downloaded has the issue mentioned above about the workspace being part of the source path causing the error object exists outside workspace.

    The suggested fix to updated file no longer works.



  • David Allan Tuesday, March 18, 2014
  • Richard Wednesday, March 19, 2014

    Thanks, thats an older version of the same as in it upgrades when installing and only has one of the experts in it. The synchronise to dependants.

    It still has the same problem.

    Which is because my workspace contains my project as part of its name -prefixed.

    So I have fixed the original. I just needed to get to grips with the wizy editor.



Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.