Oracle Warehouse Builder


Welcome!

Please add new Wiki pages and other links of interest to the list of links below.


Installation Tips and Tricks

Usage Survey

Do you want to give your 5cents on what is important in OWB or what you want next? Fill out the survey now and let your voice be heard!
Go to the blog (here) and fill out the survey. Make sure you send it using the email send option.

Other OWB Web Resources



Recent Activity on other OWB Web Sites





No user avatar
antonio.romero
Latest page update: made by antonio.romero , Apr 2 2009, 5:41 PM EDT (about this update About This Update antonio.romero Edited by antonio.romero

9 words deleted

view changes

- complete history)
More Info: links to this page
Started By Thread Subject Replies Last Post
david.jenkinson Versions of Warehouse Builder at 11.1.0.x 2 Jun 22 2009, 9:00 AM EDT by david.jenkinson
david.jenkinson
Thread started: Jun 18 2009, 12:33 PM EDT  Watch
I installed what I thought was the latest version of Oracle Warehouse Builder (11.1.0.6) but I can't connect to my data warehouse which is 11.1.0.7. I get the following error: "API5036: Client Version 11.1.0.6.0 is not compatible with repository version 11.1.0.7.0". This seems crazy!! Is there a workaround or a patch to OWB to make it version 11.1.0.7? Googling seems to suggest that 11.1.0.7 is available but I can't find a patchset for it (for OWB).

Help please.

Thanks
Dave Jenkinson
Do you find this valuable?    
Keyword tags: None
Show Last Reply
htu Export all OWB projects with a batch job 7 May 27 2009, 8:06 AM EDT by skott99
Thread started: Nov 21 2007, 11:41 AM EST  Watch
I have developed a ksh script to run an OMB+ script to export all the projects in a OWB repository. The scripts will be posted in the end.

Know limitations:
- it requires single user mode to connect to the repository
- it stops the export if users are still in a project
6  out of 8 found this valuable. Do you?    
Show Last Reply
anthonychow Expert: Source-to-Target Impact Analysis 3 Apr 2 2009, 5:37 PM EDT by antonio.romero
anthonychow
Thread started: Nov 21 2007, 10:36 AM EST  Watch
The goal for this Expert is to locate all target tables for any given source table and output the results to a CSV. Through OMB+, I used the technique of parsing the result strings from OMBIMPACT DEPENDENCYTYPE calls.

Some assumptions used during development, which you can certainly modify:
· "Project" is equivalent to projects shown as top nodes in the Project Explorer
· "Study" is equivalent to Oracle databases under each project
· Select to analyze multiple source tables by using the Ctrl key
· Target tables have "_FINAL" as the suffix in the name

Known limitations:
· Patience is certainly virtuous; great results take time to produce
· OMBIMPACT DEPENDENCYTYPE is unable to detect impacts against columns embedded into expressions; and the pivot and unpivot operators
3  out of 5 found this valuable. Do you?    
Show Last Reply
Showing 3 of 4 threads for this page - view all
Unknown File sp_get_pm.sql (Unknown File - 5k)
posted by htu   Dec 3 2007, 4:04 PM EST
Stored procedure for tracing back dangling objects to t heir corresponding projects and modules.
Unknown File owb_exp_prjs.tcl (Unknown File - 13k)
posted by htu   Nov 21 2007, 12:08 PM EST
This OMB+ script was from OWB beta and modified so that the exports will be saved in a separate folder for each run.
Unknown File run_ombplus (Unknown File - 6k)
posted by htu   Nov 21 2007, 12:03 PM EST
OK, here it is the whole script. Sorry for the code chunks.
Compressed Archive OWB Impact Analysis Expert Oracle Wiki.zip (Compressed Archive - 208k)
posted by anthonychow   Nov 21 2007, 10:45 AM EST
Expert: Source-to-Target Impact Analysis