Entries from Oracle Warehouse Builder (OWB) Weblog tagged with 'database'
Oracle Warehouse Builder 11gR2
Great news, today Oracle released the Linux x86 and x86-64 versions of 11gR2 for the Oracle Database which includes Warehouse Builder (see Oracle Database 11gR2 here). Nice to finally see all the hard work eventually come to fruition. This has...
Why does it take forever to build ETL processes
ETL is a lengthy process... what can you do about it?
Data types - using complex data types in ETL
Not sure this is a widely known fact, but one of the changes we made in OWB 10.2 (and up of course) is the extensive support for complex Oracle data types. Areas such as spatial data will benefit from this...
Comments, questions and the forum
When going through the blog I noticed some comments actually are questions. Not sure if everyone knows, but there is a very active product forum on OTN. The link has changed over the past couple of weeks, so make sure...
OWB and DW @ Oracle Openworld
Tickets are booked, hotels are reserved, excitement is building... yes it is time for Oracle OpenWorld! As data warehouse and OWB enthusiasts we all want to know the best sessions to go to. Here is a useful PDF printable booklet...
SQL for workspace enablement
As a quick follow up on my post on accessing SQL views in 11g OWB, here is a simple one if you are in SQL Dev or SQL Plus: begin owbsys.wb_workspace_management.set_workspace('workspacename', 'workspaceowner'); owbsys.start_enable_owb_roles; end; Replace the italics for workspacename and...
Sizing an OWB system...
Should I even go here...? Maybe not, but one thing that I thought would be interesting to mention here is an avenue to take when you are struggling with sizing. Yes, this will have loads of disclaimers but might be...
OWB Public Views in 11g Release 1
In OWB 11g the repository is a set of workspaces. In the public views this means you need to set the workspace context.This is not an issue from within a map as the workspace context is set prior to invoking...
Working in an SAP production environment with OWB
SAP is a bit different... it is more structured than most other environments and there are specific requirements on running ABAP programs in production systems. Since this is a common topic, and since we have a very nice solution (if...
DBLinks the sequel
Did the #2 option today on an 11g database (just to remind me that things are different in 11g). The simple way of getting OWB to use a dblink is to create your own connector (you may have to delete...
Full Outer Joins in OWB
One of the questions I noticed recently was on full outer joins. How do you do that in OWB. Well it is quite simple, but I guess not that obvious. So here is a quick post on how to do...
Modifying icons for process flow activities
I would guess many people are using user defined activities in process flow. As do we when we do partner work. Wouldn't it be nice if you could change the icons for the user defined activities to better show what...
OWB, web services and the database
Since we get this question quite often, lets go back into this a little more. What is the story with OWB (or better the database) and web services? Well, you have all the tools and mechanisms around to simply hook...
Data Watch and Repair for Master Data Management
Some happy news on the data quality front (yes I'm harping on that quite a bit these days...). We just completed the new Data Watch and Repair solution using the entire OWB technology stack. One of the things we phased...
Checking referential integrity with data rules
So you read my KQIs thingie. This one is a bit more practical in that it is real code without coding :-)I get incoming data into a table, and what I want to do is check referential integrity without FKs,...
Manual intervention in a process flow (restart, retry or reroute): Part II
Doing the actual "go back after I did something" is very simple. I've extended and changed the process flow used in the previous post (part I) to look like this:Essentially I have some execution part (my silly procedure which insert...
Manual intervention in a process flow (restart, retry or reroute): Part I
As a follow up on the emailing errors from process flows, this post looks at using the Manual activity in the process flow editor to choose a path interactively. If you combine this post with the emailing post, you basically...
Search All Blogs
Google Search
Feed Subscription
If you use an RSS reader, you can subscribe to a feed of all future entries tagged 'database'.
