SAP ties up with Teradata for detailed drill down in BI - News Review

Rethink IT, March, 2004

Why would SAP, which has its own Business Warehouse software, sign a partnership with Teradata, a company that might be considered a competitor?

The truth about the continued success of Teradata, in the face of challenges from Microsoft, Oracle and IBM in the business intelligence market, is that the company is selling something entirely different from most of those other companies.

That's the attraction that has made SAP sign up with Teradata, and you might say that the devil is in the detail.

Because it is the fact that the approach Teradata brings to data warehousing and analytics is about retaining details of all of the data for which it acts as a window

As Stephen Brobst, CTO for Teradata explained to us recently, "None of our competitors keep data at the basket level of detail. Because their systems aren't designed to cope with as much data as our hardware/software combination, most of our competitors don't even to, to keep the original data to drill down to. They just keep summaries. This sometimes seems more efficient, but it rarely ends up that way.

"Clients always say they know what summaries they want from a datamart, but when you give them those summaries they find that they have more questions and pretty soon you are building out a new datamart that will hold a new summary."

"This leads to datamart proliferation and it's short sighted, We have found that on average customers end up with an extra 70% cost when they approach data warehousing this way, Accenture has made a great business consolidating all the datamarts, as a part of budget tightening exercises, these last few years.

"In the end this approach is a false economy, and they should retain all the data and then new views can be created at will without the need to go through the effort of defining a new set of canned reports on a new datamart."

In essence, what SAP and Teradata have agreed to do is join the Teradata engine to SAP using its Netweaver application integration software, so that Teradata held data can either be available to SAP applications or through its own Business Warehouse interface.

Teradata reckons the market splits between Microsoft taking business intelligence databases of under 50Gb, Oracle lording it in the 100Gb to 300Gb range, and above that Teradata and IBM fighting it out, Above ITb or 2Tb it reckons it has the field to itself and is moving onwards and upwards to build out databases in the petabyte range. Teradata uses a massively parallel, Intel-based, hardware server to drive its hash based file system, which it says would give a write time overhead if used for transaction processing, but which gives blazing speed in finding data.

The first step with SAP will be easy and completed by end of the first quarter, making Teradata data available to Netweaver, The work was almost already done by the time the deal was struck and will go to beta in three months. The two companies have swapped engineering teams to tweak what they've already done, Secondly, it will deliver full basket level drill down from Business Warehouse, delivered three months later. The two companies will initially begin looking at telecommunications, financial services, pharmaceuticals and aerospace and defense, but Brobst added," eventually SAP will be letting Teradata into the strong manufacturing base of SAP and we'll be getting SAP into the strong retail base of Teradata, once we feel that the deal is working out."

Teradata is part of NCR, which announced revenues for the year yesterday of $5,6bn, with Teradata revenues making up over $1.2bn of that with licenses down slightly and total revenues off 1% But it finished on a high with revenues for the fourth quarter up 6% over this time last year, and an operating profit of $61m compared to $34m this time last year and $145m net income for the year.