Oracle Read - Oracle Blogs Aggregator

OWB 11gR2 White Paper on Code Template/Knowledge Module Support Available

A new whitepaper on code template/knowledge module support in Warehouse Builder has been published on OTN. For those who have followed this blog and other third party discussions of OWB 11gR2 closely, the technical information here may already be familiar, and you may have even dug deeper into the details than this paper can in the space available. But for those looking to get up to speed on what’s been happening with OWB 11gR2, its place in Oracle’s data integration product lineup, and how ODI knowledge module technology figures into OWB, you can download the PDF here. More white papers on

...click on the title to read the full article...

Advanced Find and Search in OWB

With Tahoe release of OWB, search functionality is enhanced for a more efficient development process. This includes advanced find and search inside various components. Advanced find enables a user to quickly locate any item inside a graph editor, e.g., a mapping editor. Usually, mappings are used to perform an ETL task. A real world complex mapping can contain hundreds to thousands of objects, including operators, groups and columns. It would be a boring and tedious work for an ETL designer to locate a certain column in the mapping canvas manually. With Advanced Find, tasks like search for a column in

...click on the title to read the full article...

Bread-and-Butter: Classic OWB Implementations in the News

I’m taking some time off at the moment (back next week, no worries) but things still land in my inbox, and I can’t help but look at them and sometimes process them… So when a couple of classic OWB implementations showed up in press releases this week, I figured I had to share them with the blog readership. Solid, successful implementations that tap into the strengths of Oracle databases and Warehouse Builder no doubt happen all the time, so in that sense it’s not news, but each was important enough to the parties involved for a press release, and we

...click on the title to read the full article...

Advanced Properties of Location: New for 11gR2

In OWB 11gR2 the location object has a number of advanced properties for supporting a wide variety of data systems. These properties allow users to specify a range of information from how systems are accessed to the naming convention for temporary objects on the system. We will introduce these properties below. 1.Details In OWB Design Client, when you open the editor of a location, you will see several tabs such as Details, Advanced, Prefix, Mask and Connection Pool listed on the left panel. Click on the Details tab, the right panel displays the general credential information for a location. Let’s take an

...click on the title to read the full article...

New Training Resources Available for OWB 11.2

Oracle University now offers an instructor-led course on OWB11.2 entitled Data Integration and ETL with Oracle Warehouse Builder. The entire course is 5 days long and is divided into two parts: Part I is 3 days and covers designing and debugging ETL mappings, performing data cleansing, integrating with OBIEE and other basic ETL functionality included in the Oracle Database license. Part II is 2 days and covers metadata management, accessing non-Oracle sources (code templates), right-time data warehousing, and the other features in the Enterprise ETL/ ODI EE license. For a listing of other training resources, including the free OBE’s, see the OWB Training

...click on the title to read the full article...

OWB Public Views in 11g Release 2

Oracle Warehouse Builder (OWB) Public Views is a relational public interface to OWB repository. It helps users to have a direct access to OWB metadata by using SQL. The Warehouse Builder provides a set of pre-built views for both the design and runtime environments. Compared to other OWB public access methods, such as Scripting Command and OWB Repository Browser, Public Views provides fast, lightweight, secure, multiple-user enabled and remote access to the OWB metadata. OWB Browser is entirely relying on OWB Public Views to provide metadata support. Many OWB customers, such as data warehouse developers, consultants and administrators, are using OWB

...click on the title to read the full article...

OWB 11gR2 New Features eStudy

The OWB 11gR2 New Features eStudy is available! You can use the following URL to enroll in iLearning and play the eStudy: http://ilearning.oracle.com/ilearn/en/learner/jsp/offering_details_find.jsp?classid=776869450 Thanks to the authors and contributors, hope you find it useful.

Troubleshooting Control Center Agent

The control center agent, as a runtime middle-tier, is integrated in OWB 11g Release 2 to support heterogeneous access. It is essential for users to get an insight into how to troubleshoot and diagnosis the control center agent. This article describes some common approaches to help users to diagnosis the control center agent. The Oracle Diagnostic Logging (ODL) After users deploy and execute a code template map in the design center, they may encounter deployment or execution error. We take a simple code template map as an example. The CT_MAP is a simple TABLE-to-TABLE map. After the CT_MAP is executed,

...click on the title to read the full article...

OWB 11gR2 – MySQL Bulk Extract

Next on the MySQL series, let’s look at bulk extract to file from MySQL. We’ll see how the OWB 11gR2 out of the box functionality can be enhanced to utilize some native MySQL capabilities and boost the performance! All with some baby steps into the code template world… To make it a little more interesting we will create multiple files from a single map, one with the high bonuses and another with the low bonuses. The mapping will have 2 execution units and we will utilize the SQL to File integration code template which is shipped with OWB 11gR2. Look at

...click on the title to read the full article...

OWB 11gR2 – MySQL Error Detection

This is an introduction to the error detection capabilities using the check/control pattern supported in the code template framework and carries on from the previous post on OWB 11gR2’s Open Connectivity using MySQL. The error detection scenario will leverage the mapping from the previous post. The check/control pattern is a generic framework for error handling that is supported out of the box with the supplied code templates, you will see how rules are logically declared and enabled within the mapping. The framework is incorporated into integration code templates and can be initiated whilst the data is being integrated (flow in image

...click on the title to read the full article...

OWB 11gR2 – MySQL Open Connectivity

With the 11gR2 release of OWB there were significant changes to mapping to support native heterogeneous connectivity to systems, prior to this release the heterogeneity was achieved by using Oracle Database Gateways - in OWB each system was projected as an Oracle system, so the data-types for those systems was mapped to Oracle by the Database Gateway. In 11gR2 the types for these systems is captured within OWB - so when tables are designed or reverse engineered for example the native types for these systems are captured. So what? Now as well as the Oracle connectivity provided via Database Gateways, OWB

...click on the title to read the full article...

How to Start Oracle Warehouse Builder Repository Browser

The Repository Browser is a browser-based tool that generates reports from data stored in Oracle Warehouse Builder (OWB) repositories. When you install Warehouse Builder from Oracle Universal Installer, the Repository Browser is also installed and runs in all the languages that you selected during installation. The Repository Browser connects to Warehouse Builder repositories and enables you to view metadata, run Web reports, perform lineage and impact analysis on your metadata, and audit runtime executions. Using the Repository Browser, you can view: Detailed information about the design of a workspace. Reports are generated from data stored in the workspaces. Reports that provide access

...click on the title to read the full article...

Connecting Mapping Operators – the OWB 11GR2 way

In OWB11GR2 release, we have a new feature in our Mapping Editor that allows users to connect mapping operators quicker and easier. This article will discuss the new feature “Quick Mapper” as well as other tips that will come in handy when you are building your Mapping in the Mapping Editor. Let’s use a simple Mapping for our illustration. This simple mapping loads data from a source Oracle Database table to a target Oracle Database table: SALES -> SALES_TGT The completed mapping looks like this: How do we arrive at this Mapping? In the Mapping Editor Canvas, we’ll need to connect

...click on the title to read the full article...

Introducing Optimize Repository

Have you ever had the experience that Oracle Warehouse Builder (OWB) Client becoming extremely slow after you create a bulk of objects or import a huge project into the repository? If the answer happens to be yes, maybe next time you can try one of the tools OWB Design Client comes with, Optimize Repository. What is the Optimize Repository? OWB uses the Oracle database for its metadata repository. While OWB is running, it frequently accesses its metadata repository for querying or managing metadata. So OWB will perform better if database access and operations are fast and efficient. Optimize Repository is

...click on the title to read the full article...

OWB 11gR2 – Intra Batch Dimension Changes

There are a number of improvements and new features for data warehousing projects related to the OWB dimensional modeling capabilities. The improvements range from improved partitioning capabilities, to richer dimension modeling transformation capabilities to name a few. This post will look at how to handle intra batch dimension member changes. Before I illustrate the intra batch functionality just want to give a quick summary of some of the changes in the dimensional modeling area; support for orphan management for dimensions and cube/facts (handles early arriving facts for example or hierarchy loading) plus slowly changing enhancements to support tracking change intra batch. Partitioning

...click on the title to read the full article...

Please Don’t Run on Holidays

This post is for the standalone users out there, I’ll explain why in a moment. I was with a customer in sunny, warm Nebraska last week, OK, OK it was sunny but ‘warm’ is a little of an exaggeration. It was freezing, somewhere around 3F without the windchill. As I drove into Omaha, I was wondering why it seemed deserted; upon opening the car door, it became all too clear, where was my pullover. I should have realized when picking up the car but that was under cover and they had pre-heated the car. The customer was looking for a way

...click on the title to read the full article...

Oracle Exadata: A Single Source of Truth (New Video)

Over the last 6-9 months we have been releasing a series of videos on YouTube under the banner of “DBA2.0″ (a quick search on YouTube will list all these videos). These videos follow the work of a dedicated team of DBAs and business users as they try to get their jobs done in an environment that just keeps throwing up new challenges. Fortunately, Oracle is there to save the day… This latest scenario deals with data warehousing and specifically Exadata. It is in two parts and the first installment has just been released - “Oracle Exadata: A Single Source of Truth“.

...click on the title to read the full article...

Using MindMapping to view OLAP hierarchies…

I came across this interesting article by accident. One thing I have always wanted within AWM is a way of viewing a hierarchy or series of hierarchies. In the old days of Express I wrote a various Express programs, EIS code (who remembers Express EIS?), Express Objects extensions, that would list out a hierarchy. However, this article by Robert Brooke takes this idea way beyond anything I have seen because it uses the open source tool called MindMapping. Take a look at the series of articles Robert has written: http://ofaworld.wordpress.com/2010/02/09/ofa-mindmapping/http://ofaworld.wordpress.com/2009/06/10/sample-olap-dml-code-gplcode/http://ofaworld.wordpress.com/2009/12/01/oracle-olap-mindmapping/ Now that is cool! Now I am thinking if we

...click on the title to read the full article...

Junk Viz - the 100 slice pie chart

As junk visualizations go, while there has been enough that has been written on the drawbacks with the pie chart, this example below, from 10 Ways to Archive Your Tweets, brings out the problem in a most, shall we say, visual manner. As far as gleaning any information from this chart goes, it’s a lost cause. You would need to possess incredibly powers of being able to precisely position your

Gartner Magic Quadrant for Business Intelligence Platforms, 2010

In my last post, Gartner Magic Quadrant for BI Platforms 2010, I wrote that Oracle had been positioned in the ‘Leaders’ quadrant, for the fourth year in a row. The link to the Gartner Research Note is now available, on the Gartner site, at Magic Quadrant for Business Intelligence Platforms

Oracle Read - Oracle Blogs Aggregator

OWB 11gR2 White Paper on Code Template/Knowledge Module Support Available

Advanced Find and Search in OWB

Bread-and-Butter: Classic OWB Implementations in the News

Advanced Properties of Location: New for 11gR2

New Training Resources Available for OWB 11.2

OWB Public Views in 11g Release 2

OWB 11gR2 New Features eStudy

Troubleshooting Control Center Agent

OWB 11gR2 &ndash; MySQL Bulk Extract

OWB 11gR2 &ndash; MySQL Error Detection

OWB 11gR2 &ndash; MySQL Open Connectivity

How to Start Oracle Warehouse Builder Repository Browser

Connecting Mapping Operators &ndash; the OWB 11GR2 way

Introducing Optimize Repository

OWB 11gR2 &ndash; Intra Batch Dimension Changes

Please Don’t Run on Holidays

Oracle Exadata: A Single Source of Truth (New Video)

Using MindMapping to view OLAP hierarchies…

Junk Viz - the 100 slice pie chart

Gartner Magic Quadrant for Business Intelligence Platforms, 2010

OWB 11gR2 – MySQL Bulk Extract

OWB 11gR2 – MySQL Error Detection

OWB 11gR2 – MySQL Open Connectivity

Connecting Mapping Operators – the OWB 11GR2 way

OWB 11gR2 – Intra Batch Dimension Changes