Oracle's latest version of Data Warehouse Builder will make it easier for database developers and administrators to tie together information from different data stores within an enterprise, the company claimed yesterday.
Version 9.0.4 of the Oracle9i Data Warehouse Builder (OWB) includes a number of enhancements from previous versions of the tool.
Those enhancements include:
- A new SAP Integrator that makes it easier to extract information from SAP R/3 systems
- Better workflow features and a more user-friendly interface simplify the process for creating extract, transform and load (ETL) processes.
- Support for industry standards such as XML (Extensible Markup Language) Metadata Interchange and Process Description Language to simplify the process of integrating OWB with third-party products.
Oracle9i Warehouse Builder is used to pull data from disparate sources such as financial and accounting databases into an Oracle9i database, for example as part of an effort to build an enterprise data warehouse that consolidates data from across an organisation.
Once in a predictable format within Oracle, data can be accessed by more sophisticated analytic tools such as customer relationship management and enterprise resource planning applications, according to Mark Shainman, a senior analyst at Meta Group.