Synchronizing Pluggable Maps

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;

OMBSYNCHRONIZE PLUGGABLE_MAPPING '/DIM_EXAMPLES/PLUGGA' TO MAPPING '/DIM_EXAMPLES/WH/ANOTHER_USE_OF_PLUG' OPERATOR 'PLUGGA' USE (RECONCILE_STRATEGY 'REPLACE', MATCHING_STRATEGY 'MATCH_BY_NAME')

Feel free to
look under the hood of how this works and hope it is useful.


Comments:

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 on February 08, 2008 at 02:12 AM PST #

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 on February 18, 2008 at 02:15 AM PST #

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 on April 15, 2008 at 08:13 PM PDT #

Hi Bruno

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

Cheers

Posted by David Allan on April 18, 2008 at 06:26 AM PDT #

A Synchronizing Pluggable Maps looks good to me and very helpful.

Posted by guest on May 23, 2011 at 04:26 AM PDT #

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 OMBSYNCHRONIZE FUNCTIOIN '<FUNCTION_PATH>' TO PROCESS_FLOW '<PROCESS_FLOW_PATH>' ACTIVITY '<FUNCTION_NAME>' USE (RECONCILE_STRATEGY 'REPLACE', MATCHING_STRATEGY 'MATCH_BY_OBJECT_NAME') I don't know why it loses the value when i synchronize it. Thanks, Guna

Posted by guest on May 24, 2011 at 12:13 AM PDT #

Hi Guna Sorry I missed this comment after the blog migration. Did you resolve this, or its a bug? Cheers David

Posted by David on June 06, 2011 at 09:10 AM PDT #

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.

Thanks,
Richard.

Posted by Richard on March 18, 2014 at 01:06 PM PDT #

Hi Richard

The link is below;
https://blogs.oracle.com/warehousebuilder/resource/gems/synchronizeexpert.mdl

Cheers
David

Posted by David Allan on March 18, 2014 at 01:17 PM PDT #

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.

Cheers,
Richard.

Posted by Richard on March 18, 2014 at 06:23 PM PDT #

Post a Comment:
  • HTML Syntax: NOT allowed
About

ETL, CDC, Real-Time DI and Data Quality for the Oracle Database from the inside.

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today