Warehouse Builder 11gR2 Platform and Application Adapter Extensibility Cookbook Now Available

owb_mysql_platform Extensibility for non-Oracle platforms is one of the major strides forward in OWB 11gR2. The OWB 11gR2 Platform and Application Adapter Extensibility Cookbook describes everything needed to add new database platforms and ERP application adapters to Warehouse Builder:

  • Creating your own platform definitions to define native types and map them to OWB's built-in types
  • Defining custom metadata importers using SQL or Java procedures
  • Creating application adapter definitions to support new ERP data sources
  • Create OWB platform definitions from ODI Technology definitions

The white paper on this topic and a Zip file containing several examples will be posted on OTN soon (OTN is undergoing some maintenance, so no updates for the next several days).

For now, though, they're attached to this post:

Also, this year's Oracle OpenWorld Data Integration track will feature a talk by OWB blogger Suraj Bang, entitled "Extend ETL with Oracle Warehouse Builder 11g Release 2". Suraj's work has made use of the technology now documented for all through this part of the OWB SDK. The abstract follows:

Beyond basic Oracle-to-Oracle extract, transform, and load (ETL), data warehousing customers need to integrate data from multiple datasources spanning multiple database vendors, file formats (CSV, XML, HTML), and unstructured datasources such as PDFs and log files. This session describes experiences with extending Oracle Warehouse Builder 11g Release 2 to extract data from Postgres, SQL Server, MySQL, Sybase, PDF documents, and more for a major banking client's data warehousing project supporting IT operations. It included metadata extraction, custom knowledge-module-based ETL, and replacing ad hoc Perl and Java extraction code with a manageable ETL solution built on Oracle Warehouse Builder's extensible plaform.

This talk was solicited and approved through the Oracle OpenWorld/Oracle Mix "Suggest-a-Session" process.

We are also working to set up some Unconference sessions where more OWB 11gR2 users can present brief case studies. If you would like to contribute case studies, tips and techniques based on your own work, reach out to us through the LinkedIn group for OWB, ODI and other data integration products, and let us know what you have in mind.

Comments:

The zip file link is broken. Please advise if it was moved or removed. Thanks. I do ODI work and did OWB for many years.

Posted by James on July 30, 2013 at 04:46 PM PDT #

Hi

The link below has the content of the cookbook I believe.....
https://blogs.oracle.com/warehousebuilder/resource/OWB11gR2/owb112-platform-app-samples-177345.zip

Cheers
David

Posted by David on July 31, 2013 at 03:50 PM PDT #

Post a Comment:
  • HTML Syntax: NOT allowed
About

ETL, CDC, Real-Time DI and Data Quality for the Oracle Database from the inside.

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today