Entries from Oracle Warehouse Builder (OWB) Weblog tagged with 'metadata'

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...

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...

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 Model Introspection

There are useful OMB APIs (see OMBDESCRIBE) to introspect the OWB model and query object definitions. They provide a useful insight when building accelerators. I've used them for building a few things including the configuration experts on the exchange (slice...

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...

Feed Subscription

If you use an RSS reader, you can subscribe to a feed of all future entries tagged 'metadata'.

Subscribe to feed Subscribe to feed