Oracle Magazine - OWB 11gR2 and Heterogeneous Databases

Posted by David Allan on Oracle Blogs See other posts from Oracle Blogs or by David Allan
Published on Wed, 21 Apr 2010 12:56:16 -0800 Indexed on 2010/04/21 21:33 UTC
Read the original article Hit count: 370

Filed under:

etl

|

press

|

resources

|

11gR2

|

heterogeneous

|

OWB

|

code templates

|

knowledge modules

|

templates

There's a nice article titled 'Oracle Warehouse Builder 11g Release 2 and Heterogeneous Databases' from Oracle ACE director and cofounder of Rittman Mead Consulting, Mark Rittman in the May/June 2010 Oracle Magazine that covers the heterogeneous database support in OWB 11gR2:

http://www.oracle.com/technology/oramag/oracle/10-may/o30bi.html

Big thanks to Mark for this write up. There is an Oracle white paper on the support here and for examples of this extensibility you can go to the OWB blog archive where there are quite a few posts. I would recommend the following interesting posts out of the archive architecture overview, bulk file loading, MySQL open connectivity and MySQL bulk extract as interesting posts amongst others.

© Oracle Blogs or respective owner

Related posts about etl

SQL SERVER – Introduction to Adaptive ETL Tool – How adaptive is your ETL?

as seen on SQL Authority - Search for 'SQL Authority'
I am often reminded by the fact that BI/data warehousing infrastructure is very brittle and not very adaptive to change. There are lots of basic use cases where data needs to be frequently loaded into SQL Server or another database. What I have found is that as long as the sources and targets stay… >>> More
SQL SERVER – 4 Tips for ETL Software IDE Developers

as seen on SQL Authority - Search for 'SQL Authority'
In a previous blog, I introduced the notion of Semantic Types. To an end-user, a seamlessly integrated semantic typing engine significantly increases the ease of use of an ETL IDE (integrated development environment, or developer studio). This led me to think about other ease-of-use issues I have… >>> More
PostgreSQL to Data-Warehouse: Best approach for near-real-time ETL / extraction of data

as seen on Stack Overflow - Search for 'Stack Overflow'
Background: I have a PostgreSQL (v8.3) database that is heavily optimized for OLTP. I need to extract data from it on a semi real-time basis (some-one is bound to ask what semi real-time means and the answer is as frequently as I reasonably can but I will be pragmatic, as a benchmark lets say we… >>> More
ETL Operation - Return Primary Key

as seen on Stack Overflow - Search for 'Stack Overflow'
I am using Talend to populate a data warehouse. My job is writing customer data to a dimension table and transaction data to the fact table. The surrogate key (p_key) on the fact table is auto-incrementing. When I insert a new customer, I need my fact table to reflect the id of the related customer… >>> More
Kimball University: Three ETL Compromises to Avoid

as seen on SQL Server Central - Search for 'SQL Server Central'
Why neglecting slowly changing dimensions, failing to capture metadata and overlooking scope creep can be the undoing of a dimensional data warehousing initiative. >>> More

Related posts about press

10 Tips to a Better SEO - Friendly Press Release

as seen on Ezine Articles - Search for 'Ezine Articles'
Writing that is more SEO-friendly is not impossible; follow these tips and you will reach your ultimate goal. Forget the jargon. The most important thing in this step is telling your story. >>> More
Using Keywords in Your Press Releases For Greater SEO Success

as seen on Ezine Articles - Search for 'Ezine Articles'
As the web continues to evolve, one thing has remained consistent -- text and keywords remain the linchpins of SEO. This is especially true with your press releases. >>> More
HIMSS 2011 and New Press Release

as seen on Oracle Blogs - Search for 'Oracle Blogs'
We're here at HIMSS 2011 in booth 1651. If you're at the show, tomorrow (Wednesday) is the final day for the exhibits, so come over and see all of the Oracle demos displayed on Sun Ray Clients. It's extremely cool! Also, we did a press release here at the show about caregiver mobility with Wolf Medical… >>> More
Oracle Desktop Virtualization Press Release

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Even though Oracle has introduced new products (HW and SW) and pricing, and part numbers, modified licensing, and an EVP and an SVP have discussed openly where Oracle is going with Virtualization, you may still have heard from "the other guys' that Oracle isn't going to be keeping the legacy… >>> More
Catch Up on Your Reading

as seen on Oracle Blogs - Search for 'Oracle Blogs'
AutoVue 20.0 was a major release which included many new features and enhancements. We eagerly shared the news with members of the media, who in turn wrote about AutoVue enterprise visualization in various online articles. Here is a summary of the articles featuring AutoVue 20.0. Happy reading… >>> More