Oracle Warehouse Builder 11gR2

Spolu s druhým releasem Oracle Database 11g byl v září uvolněn i druhý release Oracle Warehouse Builder 11g. Narozdíl od prvního release verze 11, která byla víceméně stejná jako verze OWB10gR2, je v současné verzi řada vylepšení a novinek (detailní seznam viz. níže).

Mezi ty nejdůležitější určitě bude patřit nativní podpora heterogenních zdrojů, Code-Template Mapping, webové služby a generování metadata repository pro Oracle Business Intelligence Enterprise Edition.

Tři výše uvedené jsou v současné chvíli prvním krokem integrace klasického OWB a ODI (v únoru 2009 jsem psal o vzniku nové edice s názvem Oracle Data Integrator Enterprise Edition, která licenčně spojuje Oracle Data Integrator a placenou DB Option OWB Enterprise ETL, která od té doby přestala být samostatně prodejná).

Zajímá-li vás roadmapa pro Oracle Warehouse Builder, pak ji najdete zde, Statement of Direction nejdete zde.

OWB11gR2 si můžete stáhnout z OTN

• buď jako součást Oracle Database
• nebo jako samostatnou instalaci

Bohužel stejně jako Oracle Database 11gR2 je i OWB11gR2 v současné době dostupné pouze na platformě Linux - tzn. chcete-li začít vyvíjet v novém OWB musíte mít jako OS klientské stanice Linux a nebo spustit OWB na některém z vašich Linux serverů a např. přes VNC nebo jiný remote desktop se k němu přihlásit.

Seznam nových vlastností OWB11gR2, seskupeno podle kategorií:
Upozornění: Z pohledu licencování mohou být některé nové vlastnosti použity pouze v případě, že vlastníte licenci Oracle Data Integrator Enterprise Edition. Seznam licencovaných vlastností najdete zde.

Native Support for Heterogeneous Databases

OWB now provides extensive built-in support for non-Oracle databases. JDBC connectivity is added alongside previous support for ODBC and database gateways, and OWB now supports in-database ELT operations on non-Oracle databases. Other enhancements improve access to data from non-Oracle sources such as mainframe and flat file data.

Features in this area include:

• Code Template Mappings and JDBC Connectivity Support

• Enhanced Support for Flat File Imports

• Extensible Platform Framework

• Java-Based (J2EE) Control Center Agent

• Metadata Import from COBOL Copybooks

SOA Integration Enhancements for ETL and Data Quality

The ETL and data quality functionality in OWB can now be integrated into SOA-style architectures.

Features in this area include:

• Web Service and SOA Integration Support for ETL and Data Quality

• Java-Based (J2EE) Control Center Agent

Data Warehousing and Business Intelligence Enhancements

The data warehousing-specific support in OWB has improved. These improvements provide smarter dimensional object operators for ETL and support for more storage types for dimensional objects.

Features in this area include:

• Oracle Business Intelligence Enterprise Edition Integration

• Automated Orphan Management Policy for Loading Dimensional Objects

• OLAP Cube-Organized Materialized Views Support

Developer Usability Enhancements

The Design Center user interface in OWB has been extensively redesigned to improve developer productivity and make advanced features more accessible.

Features in this area include:

• Advanced Find Support in Mapping Editor

• Copy and Paste of Operators and Attributes in Mapping Editor

• Current Configuration Drop-down Box in Design Center Toolbar

• Experts Available in Editor Menus

• Expression Editing in Operator Edit Dialog

• Improved User Interface for Managing Locations (for Sources and Targets)

• Grouping and Spotlighting of Objects in Mapping Editor

• Improved Metadata Search and Find for Dependency Management

• New JDeveloper-Style User Interface

• Operator Comments Included in Generated PL/SQL Code

• Organizing Objects with User Folders

• Quick Mapper in Mapping Connection Dialog Box

Administrator Usability Enhancements

OWB administration tasks are simplified and improved by a number of features in this release. Administration has been extended to support new feature areas such as heterogeneous database support and Web services integration.

Features in this area include:

• Multiple Configuration Management Usability Improvements

• Web Service and SOA Integration Support for ETL and Data Quality

• Improved Management of Locations Registered in Multiple Control Centers

• Heterogeneous Audit and Reporting

• Repository Browser Changes

• Simplified Oracle Warehouse Builder Repository Upgrades

ETL Mapping Enhancements

ETL mappings have been enhanced to add new transformation capabilities and to improve the productivity of developers working with flat files and designing and debugging ETL mappings.

Features in this area include:

• Operator Comments Included in Generated PL/SQL Code

• Key Lookup Operator Enhancements

• Mapping Debugger Enhancements

• Enhanced Table Function Support

• Improved Code Generation for Extraction of Peoplesoft Application Data

• Support for Subqueries in Join Operator

• Web Service and SOA Integration Support for ETL and Data Quality

Process Flow Enhancements

OWB process flows have been enhanced to integrate with new activity types, out of the box, and to support integration of OWB ETL and data quality with SOA solutions.

Features that enhance process flows include:

• Support for EJB/Java Activity Type in Process Flows

• Support for OMB*Plus Activity Type In Process Flows

• Web Service and SOA Integration Support for ETL and Data Quality

Kompletní seznam nových vlastností OWB11gR2 je dostupný zde, dokumentaci najdete zde.



Erik Eckhardt.