Our network

etl tools

Tools and those who enable their misuse

February 1, 2010 by Ted Cuzzillo
with 196 views
0

To get a data architect I know worked up, just ask him about how customers end up buying the wrong tools. How about sales people who push federation tools on those who actually need data warehouses? “It all sounds extremely sexy,” says my source, who works for a major business intelligence vendor and whom I can’t identify. “You... [read more]

No Shortcuts: Focus on DW/BI Architecture and Processes, then Think about the Tools

December 18, 2009 by Rick Sherman
with 135 views
0

A common problem from an IT perspective is the perception that BI is just about learning how to use the tools such as databases, ETL, reporting and online analytical processing (OLAP).  You use a carpenter to build your house, but you need an architect to design it. Simply knowing how to mechanically use the tools does not help... [read more]

ETL tools: Don’t Forget About the Little Dogs

November 17, 2009 by Rick Sherman
with 321 views
0

I’m not only concerned about hand-coding versus ETL tools; I’m also concerned that potential buyers of ETL tools and the market in general are only looking at a small number of players in the ETL marketplace.For many years industry analyst research groups have identified the top two product vendors: Informatica and IBM (from its... [read more]

#25: Here's a thought...

November 7, 2009 by BrianRoger
with 190 views
0

An occasional series in which a review of recent posts on SmartData Collective reveals the following nuggets:And the customer is...A critical first step for your company is to develop your definition of a customer. Don't underestimate either the importance or the difficulty of this process. And don't assume it is simply a matter of... [read more]

Data Integration: Hand-coding Using ETL Tools Part 2

November 6, 2009 by Rick Sherman
with 168 views
0

This is a continuation of an earlier post that discussed the problems of hand-coding using ETL tools.What Went Wrong?There are two aspects of effectively leveraging an ETL tool. First is learning the tool’s mechanics, for example, by taking the tool vendors’ training either in a class or through their on-line tutorials. Most IT people... [read more]