Warehouse Builder 11gR2 Platform and Application Adapter Extensibility Cookbook Now Available
By antonio romero on Jul 16, 2010
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.