topics that matter; ideas worth sharing

share a tip, submit a link, add something new

Making Oracle applications easier

March 19, 2001, 04:32 PM —  Computerworld — 

When British Telecommunications PLC decided last year to upgrade to a newer version of Oracle Applications, Oracle Corp.'s suite of back-end business management software, the London-based communications company faced an expensive "wither and die" migration process for its data, says systems development accountant Chris Lacey.

That approach would create two diverging Oracle Applications implementations: one with several instances of the old version containing the historical data collected before the change, and another running on the new software version that combined invoice and ordering information from departments within the company's wireless division.

Crystallize Inc.

Location: 1410 Woodridge Ave., Ann Arbor, Mich. 48105

Telephone: (734) 668-8100

Web: www.crystallizes.com

The technology: Software tools for rapid integration and migration of Oracle Applications databases

Why it's worth watching: Automated processes can save time and produce more consistent results when integrating Oracle Applications databases.

Company officers: Helene Abrams, CEO and founder; Richard Earley, president and chief operating officer

Milestones: February 1998: Firm founded as Data Merger Technologies Inc. September 1999: First product launched. January 2001: Granted patent for methodology.

Employees: 77; 100% annual growth projected

Profitability date: Expected by August

Burn money: $13 million from M Group Inc., UBS O'Connor LLC and others

Products/pricing: Instance Cleansing, Change Key Flexfield, Instance Consolidation and others range from $150,000 to $2 million each.

Customers: British Telecommunications, Cummins Inc., Infogrames Entertainment SA

Partners: Aris Corp., Computer Systems Authority, Mincom Ltd., P4C Inc.

Red flags for IT: Conversion projects still require experts versed in a company's Oracle Applications implementations and business processes. The software doesn't currently support all Oracle versions.

Then, at an Oracle user's conference last spring, Lacey came across Crystallize Inc. in Ann Arbor, Mich. The start-up's software automates the process of merging different implementations of Oracle Applications, changing the underlying database fields and restructuring financial systems.

What previously required custom scripts, a raft of consultants and a brute-force approach can be done in-house within a few months, claims Joshua Greenbaum, a principal at Enterprise Applications Consulting in Daly City, Calif. "Crystallize is trying to solve an age-old problem that has typically been solved the hard way," he says.

Using Crystallize's software, British Telecom was able to combine its multiple instances of Oracle Applications before its planned upgrade. The process took five months instead of the year or more that Lacey predicted, and he estimates the company will save as much as 1 million pounds because of the unified data stores. In addition, he says, historical data can migrate into the new software, allowing the company to provide better customer service because of that integrated database.

At the center of Crystallize's software is a patented rules engine developed by CEO and former Oracle consultant Helene Abrams. The rules describe patterns common to most implementations of Oracle Applications, she says.

The engine focuses on many areas, including undocumented Oracle processes, like the sequence of loading relational databases, and

I like it!
Post a comment
The content of this field is kept private and will not be shown publicly.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd>
  • Lines and paragraphs break automatically.
Resources
White Paper

Symantec Backup Exec 12 and Backup Exec System Recovery 8 deliver industry leading Windows data protection and system recovery. Download this whitepaper to find out the top reasons to upgrade and how to get continuous data protection and complete system recovery.

Webcast

Data and system loss — from a hard drive failure, malicious attack, natural disaster, or simple human error — can happen anytime. Don’t leave your business vulnerable. Make sure you have a secure recovery strategy in place. Symantec's latest backup and system recovery technology can efficiently restore critical applications, individual emails and documents and even restore your entire system in minutes in the event of a loss.

White Paper

Businesses face a growing challenge to ensure that the IT environment is properly protected. Backup Exec 12 integrates with other applications in the Symantec family of products, to complement your current data protection strategy, keep your data securely backed up and make it recoverable when you need it most.

Free stuff
Featured Sponsor

AISO founders envisioned a Web hosting company that was environmentally friendly. While the company employed energy-efficient innovations like solar panels, its infrastructure produced unacceptable power and cooling requirements. Find out how AISO leveraged AMD technology to overcome their challenge in this case study white paper.

In this whitepaper, Scalar explores the opportunity to change the landscape with respect to mission critical databases built around Oracle. Leveraging technologies such as Linux, high-end commodity processing power and Oracle RAC technology to architect, design, build and maintain database infrastructure that delivers maximum availability, reliability and performance at a fraction of traditional cost.

On a typical day, weather.com, the Web site for The Weather Channel in Atlanta, serves up between 15 million and 20 million page views. But in September 2004, when back-to-back hurricanes ransacked Florida, the peak traffic on one day more than tripled: over 70 million page views by more than 7 million unique visitors. Read the full success story now.

More Resources