By using this site, you agree to the Privacy Policy and Terms of Use.
Accept
SmartData Collective
  • Analytics
    AnalyticsShow More
    data analytics in sports industry
    Here’s How Data Analytics In Sports Is Changing The Game
    6 Min Read
    data analytics on nursing career
    Advances in Data Analytics Are Rapidly Transforming Nursing
    8 Min Read
    data analytics reveals the benefits of MBA
    Data Analytics Technology Proves Benefits of an MBA
    9 Min Read
    data-driven image seo
    Data Analytics Helps Marketers Substantially Boost Image SEO
    8 Min Read
    construction analytics
    5 Benefits of Analytics to Manage Commercial Construction
    5 Min Read
  • Big Data
  • BI
  • Exclusive
  • IT
  • Marketing
  • Software
Search
© 2008-23 SmartData Collective. All Rights Reserved.
Reading: ETL tools: Don’t Forget About the Little Dogs
Share
Notification Show More
Latest News
data analytics in sports industry
Here’s How Data Analytics In Sports Is Changing The Game
Big Data
data analytics on nursing career
Advances in Data Analytics Are Rapidly Transforming Nursing
Analytics
data analytics reveals the benefits of MBA
Data Analytics Technology Proves Benefits of an MBA
Analytics
anti-spoofing tips
Anti-Spoofing is Crucial for Data-Driven Businesses
Security
ai in software development
3 AI-Based Strategies to Develop Software in Uncertain Times
Software
Aa
SmartData Collective
Aa
Search
  • About
  • Help
  • Privacy
Follow US
© 2008-23 SmartData Collective. All Rights Reserved.
SmartData Collective > Business Intelligence > ETL tools: Don’t Forget About the Little Dogs
Business Intelligence

ETL tools: Don’t Forget About the Little Dogs

RickSherman
Last updated: 2009/11/17 at 5:11 PM
RickSherman
6 Min Read
SHARE

Bigdoglittledog 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 acquisition of Ascential Software). So, naturally, these two appear on any evaluation shortlist. The rest of the evaluation shortlist usually includes the bundled products (mentioned in my recent posts) that come with the databases, BI tools or applications that the evaluating company already owns. Beyond these usual suspects, other ETL or data integration products are pretty obscure and almost invisible, at least from a general market perspective.

There are many ETL and integration products in the marketplace that lie somewhere between the mega-products and the bundled tools in terms of functionality and total cost of ownership (TCO). The problem for the vendors that offer these products is that very few people know about them — other than data integration nerds like me and the vendors’ relatives!

To make matters even worse, industry analysts also seem . …

More Read

tips for making the most of business intelligence

5 Vital Business Intelligence Tips All Companies Should Embrace

Understanding ETL Tools as a Data-Centric Organization
The 6-Step Guide to Integrating Business Intelligence and Analytics
Business Intelligence for Fairs, Congresses and Exhibitions
Top BI and Analytics Tools for Data-Driven Businesses



Bigdoglittledog 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 acquisition of Ascential Software). So, naturally, these two appear on any evaluation shortlist. The rest of the evaluation shortlist usually includes the bundled products (mentioned in my recent posts) that come with the databases, BI tools or applications that the evaluating company already owns. Beyond these usual suspects, other ETL or data integration products are pretty obscure and almost invisible, at least from a general market perspective.

There are many ETL and integration products in the marketplace that lie somewhere between the mega-products and the bundled tools in terms of functionality and total cost of ownership (TCO). The problem for the vendors that offer these products is that very few people know about them — other than data integration nerds like me and the vendors’ relatives!

To make matters even worse, industry analysts also seem to ignore these vendors because of their company size and relatively small installed base. I am not arguing with the industry analyst firms’ objective criteria to include/exclude vendors, but it definitely works against the “unknown” vendors.

Also, to add insult to injury, industry pundits generally speak and write about the high-tech titans and ignore the smaller vendors. If everyone only talks about the well-known vendors, then the smaller vendors will remain unknown.


Conventional wisdom says…

If you need it and can afford it a data integration project will be successful if you buy the “best-in-class” tools. The old IT industry adage was you can’t get fired for buying IBM. Let’s expand that in the current world of ETL and say you can’t get fired if you buy IBM or Informatica (although you can if you don’t complete the project on time and on budget… and in this economy no one’s job is completely safe.)

On the other end of the spectrum, where budgets and data integration needs are limited, the bundled tools may indeed do the job. My qualifier, as I mentioned in my previous post, is that if you skip learning the what and how of data integration processing then you could easily fail at using these tools.

Change the paradigm…

Completing the data integration project tasks is fine, but what about TCO, skills needed and time to market? The answer is that there are other ETL products in the marketplace that compete with the Titans and bundled products. Broaden your evaluation shortlist beyond the usual suspects. Maybe you will find a better fit for your data integration tasks than the “best-in-class” or the cheapest option. Or maybe you’ll still choose the usual suspects. But either way, at least you will have taken a good look at the possibilities.

Final thoughts

Advice to ETL evaluators: broaden your search and you might be pleasantly surprised.

Advice to ETL vendors: get visible. First, get recognized. Second, differentiate yourself. Third, your message needs to be understandable to people who do not know ETL.


Link to original post

TAGGED: bi tools, etl tools
RickSherman November 17, 2009
Share this Article
Facebook Twitter Pinterest LinkedIn
Share

Follow us on Facebook

Latest News

data analytics in sports industry
Here’s How Data Analytics In Sports Is Changing The Game
Big Data
data analytics on nursing career
Advances in Data Analytics Are Rapidly Transforming Nursing
Analytics
data analytics reveals the benefits of MBA
Data Analytics Technology Proves Benefits of an MBA
Analytics
anti-spoofing tips
Anti-Spoofing is Crucial for Data-Driven Businesses
Security

Stay Connected

1.2k Followers Like
33.7k Followers Follow
222 Followers Pin

You Might also Like

tips for making the most of business intelligence
Business Intelligence

5 Vital Business Intelligence Tips All Companies Should Embrace

7 Min Read
etl for data-driven businesses
Big Data

Understanding ETL Tools as a Data-Centric Organization

8 Min Read
big data for companies
Business Intelligence

The 6-Step Guide to Integrating Business Intelligence and Analytics

4 Min Read
business intelligence for exhibitions
Business Intelligence

Business Intelligence for Fairs, Congresses and Exhibitions

8 Min Read

SmartData Collective is one of the largest & trusted community covering technical content about Big Data, BI, Cloud, Analytics, Artificial Intelligence, IoT & more.

AI chatbots
AI Chatbots Can Help Retailers Convert Live Broadcast Viewers into Sales!
Chatbots
AI and chatbots
Chatbots and SEO: How Can Chatbots Improve Your SEO Ranking?
Artificial Intelligence Chatbots Exclusive

Quick Link

  • About
  • Contact
  • Privacy
Follow US

© 2008-23 SmartData Collective. All Rights Reserved.

Removed from reading list

Undo
Go to mobile version
Welcome Back!

Sign in to your account

Lost your password?