The three major database vendors that
practically ship ETL solutions ???at no extra charge??? are pinpointed: Oracle with
Oracle Warehouse Builder (Oracle, 2001), Microsoft with Data Transformation
Services (Microsoft, 2003), and IBM with the Data Warehouse Center (IBM,
2003). Still, the major vendors in the area are Informatica??™s Powercenter (Informatica,
2003) and Ascential??™s DataStage suites (Ascential, 2003) (the latter
part of the IBM recommendations for ETL solutions). As a general comment,
we emphasize the fact that the former three have the benefit of the minimum
cost, because they are shipped with the database, while the latter two have the
benefit to aim at complex and deep solutions not envisioned by the generic
products. The aforementioned discussion is supported from a second recent
study (Gartner, 2003), where the authors note the decline in license revenue
for pure ETL tools, mainly due to the crisis of IT spending and the appearance
of ETL solutions from traditional database and business intelligence vendors.
The Gartner study discusses the role of the three major database vendors (IBM,
Microsoft, Oracle) and points out that they slowly start to take a portion of the
ETL market through their DBMS-built-in solutions.
??? Research focused specifically on ETL: The AJAX system (Galhardas, Florescu,
Shasha & Simon, 2000) is a data cleaning tool developed at INRIA
France.
Pages:
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235