Entries from Oracle Warehouse Builder (OWB) Weblog tagged with 'owb'
How to turn on Logging for OWB 11.2 Design Client
OWB 11.2 uses one of the widely used logging API: the JavaTM Logging APIs to handle log messages. The JavaTM Logging APIs are introduced in package java.util.logging, whose central goal is to support maintaining and servicing software at customer sites....
OWB 11gR2 - Subquery
One of the new mapping operators introduced in 11gR2 is the much talked about (over the years) subquery filter operator. As well as the heterogeneous capabilities added, a number of enhancements to existing operators (such as joiner and lookup operator)...
Introducing the new startup configuration file for OWB 11.2
As OWB adopts the Fusion Client Platform (FCP), it is now using the new FCP startup configuration file for specifying the startup parameters for OWB. Unlike previous versions of OWB, where startup parameters are directly set inside the file owbclient.sh...
OWB 11gR2 – Template mapping variables?
Here we'll see how you can add runtime variables and reference them from code template mappings in OWB 11gR2; variables can be used in many places including expressions, filters, joiners and execution unit code template assignments. This lets you control...
OWB 11gR2 – Cube Organized Materialized Views
Here we will look at building cube organized materialized views for a relational fact table. The illustration uses the Oracle OLAP 11g Sample Schema and rather than the cube organized materialized views being created via the script in the demo,...
OWB 11gR2 – Bulk File Loading - more, faster, easier
A common problem in warehouses is to load a number of similar files into the database, often the filenames are dynamic so the names cannot be hard-wired, if they are known its easy enough to configure the external table or...
OWB @ the W Hotel: Warehouse Builder Goes Hybrid
When? Thursday October 15th, 2-4 pm Where? The W Hotel, Workroom 2 Who? OWB users, LinkedIn members, Open World attendees How? Register using LinkedIn or send an email. Come to this 2-hr interactive session to talk with a panel of...
OWB 11gR2 – Trickle Feed Data Acquisition and Delivery
The OWB 11gR2 release introduced near real time data warehousing capabilities. OWB has been enhanced to also support a continuous trickle feed loading approach by introducing the concept of trickle feed mappings. A trickle feed mapping is a mapping with...
Data Integration at Oracle Open World 2009
Open World 2009 is almost upon us. For those thinking about attending, there's a schedule of events and product demos around data integration on OTN, here: http://www.oracle.com/technology/products/oracle-data-integrator/events/data_integration_openworld-2009.html This page will be updated on an ongoing basis as we get closer...
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...
Process Flow Parameters
Ever wondered how to pass values out of one process flow activity into another? The use of variables and activity parameter bindings is the key. In the example below process flows are used as the activities, the same applies for...
Search OWB documentation, whitepapers, blog entries and forum all at once!
Looking for OWB information but not sure where to find things? Now you can search all of the OWB documentation, collateral, web logs, and discussion forums in one place!...
Want to learn more about the HP Oracle Database Machine?
Here is your chance, sign up now to attend the Oracle BIWA Summit 2008 Dec. 2-3. Attend this unique two-day IOUG Business Intelligence, Warehousing and Analytics (BIWA) SIG (www.oraclebiwa.org) event to gain the knowledge and information critical for success in...
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...
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...
Search All Blogs
Google Search
Feed Subscription
If you use an RSS reader, you can subscribe to a feed of all future entries tagged 'owb'.
