Have a Wetpaint account? Sign in
Oracle Warehouse Builder
Welcome!
Please add new Wiki pages and other links of interest to the list of links below.
Installation Tips and Tricks
- Oracle Workflow: Tips on installing workflow as used with OWB.
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
- OTN OWB Product Page
- OTN OWB Documentation Index
- OWB Forum
- Metalink: Releases and Patches until OWB 11g
Recent Activity on other OWB Web Sites
antonio.romero |
Latest page update: made by antonio.romero
, Apr 2 2009, 5:41 PM EDT
(about this update
About This Update
Edited by antonio.romero
9 words deleted view changes - complete history) |
|
Keyword tags:
audit
data
data governance
data quality
ELT
ETL
governance
integrator
knowledge module
Oracle Warehouse Builder
OWB
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 | ||
 |
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 |
||||
| 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?
Keyword tags:
ksh
OMB+
Oracle Warehouse Builder
OWB export
tcl
|
|||||
| anthonychow | Expert: Source-to-Target Impact Analysis | 3 | Apr 2 2009, 5:37 PM EDT by antonio.romero | ||
 |
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?
Keyword tags:
Expert
Impact Analysis
Oracle Warehouse Builder
OWB
|
||||
Showing 3 of 4 threads for this page
- view all
|
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.
|
|
|
|
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.
|
|
|
|
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.
|
|
|
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
|
