Oracle upgrades Data Warehouse Builder

Eliminate Hidden Processes that Sap Up to 40% of Developers' Time Transferring Best Practice Analytics from Experts to Everyone When The BI You Know Isn't The BI You Need Gaining Insights Through Analytics Sign up to receive Security Resource Alerts

March 13, 2003 (IDG News Service) -- A new version of Oracle Corp.'s 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 announced yesterday.
Version 9.0.4 of the Oracle9i Data Warehouse Builder (OWB) includes a number of enhancements from previous versions, according to Oracle.
Those enhancements include:

• A new SAP Integrator that makes it easier to extract information from SAP R/3 systems by SAP AG.


• Better workflow features and a more user-friendly interface that simplifies the process for creating extract, transform and load (ETL) processes.


• Support for industry standards such as XML 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. Once data is in a predictable format within Oracle, it 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 Inc.
OWB competes with similar "native" ETL tools from Microsoft Corp., which offers its Data Transformation Services (DTS), and IBM, which sells Warehouse Manager, according to Shainman.
By making it easier for database developers to pull data into a specific database environment such as Oracle or SQL Server, native ETL tools are competing with more expensive, but "database agnostic" tools such as those by Cognos Inc. and Informatica Corp.
Database vendors are investing heavily in ETL tools, hoping to drive adoption of their databases as platforms for centralized data warehouses, according to Shainman. "People want to know what's going on in their businesses. The database licensing sales and momentum are behind decision support and data warehouses. That's where the spending is," he said.
Gregory Richard, chief technology officer of Canadian company DecisionsToday Inc. in Hull, Quebec, said that his company uses OWB in addition to Microsoft's DTS and Cognos' Decision Stream to build tools that accelerate the process of building data warehouses. Decisions Today's software does analysis of an organization's business databases and systems, automatically generating a data warehouse model and ETL routines to supply it. The software is licensed directly to database vendors and sold to large enterprises, Richard said.
Due to limitations in OWB's scripting environment, Decisions Today was prevented from integrating with prior product editions. Version 9.0.4 of OWB fixed that problem, and Decision Today is now using OWB to build and automate ETL processes for Oracle, Richard said.
The product's user interface is also much improved in the latest version, Richard said. "It used to be quite cumbersome to use. You had to pop in and out of dialog boxes a lot."
The product's new interface brings it more in line with competing products, providing a diagram to represent an overall build and "point and click" support for editing object properties.
Version 9.0.4 runs on a variety of platforms, including Linux, Sun Solaris and Windows. The product is being offered for $5,000 per Named User Plus as part of the Oracle9i Developer Suite, according to Oracle.
Despite its focus on deploying to the Oracle environment, OWB offers a powerful and relatively inexpensive alternative to other solutions, Richard said. "When you look at price per feature, OWB blows the others away," he said.

Print this Story

Send Us Feedback

E-mail this Story

Digg this Story

Slashdot this Story

"We don't need al-Qaeda to blow us up. We are perfectly capable of lighting the fuse ourselves, courtesy of our..." Read more... "Analyzing data from online and your network may be a little easier because of a new browser. Yes, a browser...." Read more... Read more Business Intelligence posts or See all Blogs

Microsoft to limit capabilities of cheap laptops FBI worried as DoD sold counterfeit networking gear Update: Microsoft to appeal $1.3B EU fine More top stories...

XP SP3 cripples some PCs with endless reboots Windows Vista more secure than XP, says security company Microsoft grows DAISY for blind computer users while Adobe wilts

5 easy ways to commit career suicide Mistakes such as putting down co-workers or burning bridges when you resign are surefire ways to darken your career prospects. Here's how to avoid them Opinion: Get ready for these 6 game-changing technologies Hype and promises abound in the IT world, but these six breakthroughs really will change your life, says author and former IT manager John Brandon. What brain drain? Baby boomers are retiring and taking their knowledge with them. Why do so few in IT seem to care? Tales from the crypt: Our first computers Computerworld editors share stories of their first PCs, including some classics and some real clunkers -- then we ask readers to share their early-PC tales. Windows Vista A to Z Reviews, analyses, how-tos, visual tours, hot issues and predictions about Microsoft's new OS. More Continuing Coverage After 9/11: Homeland SecurityAsk a Premier 100 IT LeaderBlackBerry Legal BattleData Security BreachesElectronic VotingFirefoxH-1B VisasHP's Boardroom ScandalHandheld DevicesHurricane Katrina AftermathMicrosoft Legal IssuesMicrosoft's VistaOpen SourceRFID TechnologySCO's Linux FightSarbanes-Oxley ActSpamVoice Over IPWi-FiWindows Meta File VulnerabilityWindows XP Service Pack 2 IT Careers 2010 Four years from now, the IT field will be a vastly different place. Will you be ready? More Special Reports Premier 100 IT Leaders 2007 Best in Class2006 Computerworld Horizon Awards2006 Premier 100 IT Leaders2006 Salary Survey2007 Best Places to Work in IT2007 IT Forecast2007 Premier 100 IT Leaders40 Years of ComputerworldASPs, Take TwoBest Places to Work in IT 2003Best Places to Work in IT 2004Best Places to Work in IT 2005Best Places to Work in IT 2006Business Intelligence Home RunsBusiness Intelligence: Smarter BIBusiness Intelligence: The Future of BICRM Goes VerticalCRM: Sober CRMCareer Planning Guide 2005Careers: IT Profession 2010Computerworld Horizon Awards 2005Data Management: Mining for GemsData Management: Taming Data ChaosDevelopment: Hard-Workin' Web SitesDevelopment: New Tools New ChoicesDevelopment: The New World of Application DevelopmentDevelopment: The Web Services TsunamiDevelopment: Web Services HurdlesDisaster Recovery: Preparing for the WorstE-commerce Grows UpE-mail/Groupware: Big DecisionsFaces of Mobile ITForecast 2006Global MobileHardware: Multiple Cores, Multiple ChallengesHardware: On-Demand Un-HypedHardware: The Shape of Things to ComeHorizon Awards: 10 Cool Cutting Edge TechnologiesIT Management: Guide to Managing VendorsIT Management: Navigating Global ITIT Management: Recovery AheadIT Management: The Future of ITIT Management: The Resourceful Project ManagerInnovative Technology Awards 2004Management: Reinventing ITMicrosoft in TransitionMobile/Wireless Leaders and LaggardsMobile/Wireless: The Untethered WorkerMobile/Wireless: Tiny Gadgets, Huge CostsNetwork Management: Taking ControlNetworking: Turbulence Ahead!Networking: VoIP Goes MainstreamOperating Systems: In the Slow LaneOperating Systems: Linux Goes GlobalOperating Systems: Should You Nix Unix?Outsourcing: Offshore Buyer's GuideOutsourcing: Outsourcing DangersPremier 100 IT Leaders 2004 Best in ClassPremier 100 IT Leaders 2005 Best in ClassROI: Do the Math!Salary Survey 2003Salary Survey 2004Salary Survey 2005Security Action PlanSecurity: Compliance HeadachesSecurity: Proactive SecuritySecurity: Risk and RewardSecurity: Tips From Security ProsSouped-up SecurityStorage: Battling ComplexityStorage: Cheap & Secure Data StoresStorage: Stretching Your Storage DollarsStorage: The Lean Storage MachineStorage: The New Rules of StorageStorage: The Ultimate Backup GuideSupply Chain: Missing LinksSupply Chain: RFID Reality CheckThe Business of SecurityWeb 2.0 SecurityWireless: Wireless At Work All Zones Application Performance Zone Enterprise-Class Security Zone Enterprise Solutions Zone The File Data Management Zone Grid Computing on Windows Zone Security Management Zone ITIL Best Practices Zone The SAS Zone Storage Virtualization Zone The Data Center Management Zone See your link here

Computerworld Report : Smart Storage Download this Computerworld report, free for a limited time, compliments of HP. (Source: Computerworld) Faced with growing demands, immature tools and a confusing array of technologies, IT decision-makers have to make some strategic choices. Learn how to avoid the pitfalls in this Computerworld report, a $49.95 value, available free for a limited time, compliments of HP. Download this executive briefing  Managing B2B Web Channels For Success Download this survey results white paper for free, compliments of Tealeaf. (Source: Tealeaf) In March 2008, Computerworld invited Web site visitors to participate in a survey regarding their organizations' use of the Web. Specifically, the goal of the survey was to better understand organizations' goals and priorities for their B2B Web channels in 2008. The survey was commissioned by Tealeaf, but data was gathered and tabulated independently by Computerworld Research. The following report represents top-line results of the survey conducted among 250 respondents at organizations that leverage the Web for B2B commerce or self-service. Download this white paper  Long Tail Supplier Collaboration - What's In It For You? Long Tail Supplier Collaboration - What's In It For You? Download this webcast, free, compliments of Sterling Commerce Go to the webcast  White Papers Read up on the latest ideas and technologies from companies that sell hardware, software and services. New Fujitsu High-End Itanium Windows- and Linux-Based PRIMEQUEST Servers Offer the Utmost in High Availability New Fujitsu High-End Itanium-Based PRIMEQUEST Servers Offer Industry-Leading System Management for Linux and Windows Symantec State of the Data Center Report 2007 View more whitepapers

• Microsoft to limit capabilities of cheap laptops
• FBI worried as DoD sold counterfeit networking gear
• Update: Microsoft to appeal $1.3B EU fine
• More top stories 

Maturing Your Demand Management Practices A CIO's guide to maturing your demand management practices. Executive Coach Susan Cramm shares six key requirements for demand management. Learn how to gather, evaluate, categorize and prioritize IT requests based on business objectives. Read it now. Download this white paper



Best Places to Work in IT Where can you earn top dollar, get the best benefits, the latest IT and more? Find out in our 14th annual survey.



Try Fluke Networks' EtherScope Analyzer on your network FREE Quickly solve the wide range of problems you encounter - 10, 100 and Gigabit, twisted pair and optical fiber, LAN or wireless LAN. The EtherScope Analyzer combines the essential tools you need to monitor network traffic and switch interfaces, discover devices, networks, VLANs, access points, mobile clients and more. See the power of this portable network analyzer on your network. Request free trial now *Terms and conditions: Evaluation units are available only for a limited time and will be scheduled on a first-come first-served basis. Not available in all geographies. Limited quantities available; customers requesting evaluation units may be waitlisted for the next available unit. It will be at the discretion of Fluke Networks to accept or decline requests for this free evaluation.