Cookies help us display personalized product recommendations and ensure you have great shopping experience.

By using this site, you agree to the Privacy Policy and Terms of Use.
Accept
SmartData CollectiveSmartData Collective
  • Analytics
    AnalyticsShow More
    data analytics and truck accident claims
    How Data Analytics Reduces Truck Accidents and Speeds Up Claims
    7 Min Read
    predictive analytics for interior designers
    Interior Designers Boost Profits with Predictive Analytics
    8 Min Read
    image fx (67)
    Improving LinkedIn Ad Strategies with Data Analytics
    9 Min Read
    big data and remote work
    Data Helps Speech-Language Pathologists Deliver Better Results
    6 Min Read
    data driven insights
    How Data-Driven Insights Are Addressing Gaps in Patient Communication and Equity
    8 Min Read
  • Big Data
  • BI
  • Exclusive
  • IT
  • Marketing
  • Software
Search
© 2008-25 SmartData Collective. All Rights Reserved.
Reading: ETL tools: Don’t Forget About the Little Dogs
Share
Notification
Font ResizerAa
SmartData CollectiveSmartData Collective
Font ResizerAa
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
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

Please complete: “There are things known and things unknown and in between …”
AI Helps Businesses Develop Better Marketing Strategies
Office 2.0 Conference : Office 2.0 Blog: Community Power
How to Create and Deploy Effective Metrics
Market Research in 3-D! – For Market Research, Social Networks Is to 2009 as what the Online Survey was in 1998



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 toolsetl tools
Share This Article
Facebook Pinterest LinkedIn
Share

Follow us on Facebook

Latest News

data analytics and truck accident claims
How Data Analytics Reduces Truck Accidents and Speeds Up Claims
Analytics Big Data Exclusive
predictive analytics for interior designers
Interior Designers Boost Profits with Predictive Analytics
Analytics Exclusive Predictive Analytics
big data and cybercrime
Stopping Lateral Movement in a Data-Heavy, Edge-First World
Big Data Exclusive
AI and data mining
What the Rise of AI Web Scrapers Means for Data Teams
Artificial Intelligence Big Data Exclusive

Stay Connected

1.2kFollowersLike
33.7kFollowersFollow
222FollowersPin

You Might also Like

Mobile Business Intelligence
Business IntelligenceSoftware

Mobile Business Intelligence: Strategies, Trends and Pitfalls

6 Min Read
big data for companies
Business Intelligence

The 6-Step Guide to Integrating Business Intelligence and Analytics

4 Min Read
Business Intelligence
AnalyticsBusiness Intelligence

The Importance of Business Intelligence in Organizations

5 Min Read
Business Intelligence
AnalyticsBusiness IntelligencePredictive Analytics

Business Intelligence to Deliver the Real-time Business Answers

4 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 and chatbots
Chatbots and SEO: How Can Chatbots Improve Your SEO Ranking?
Artificial Intelligence Chatbots Exclusive
ai is improving the safety of cars
From Bolts to Bots: How AI Is Fortifying the Automotive Industry
Artificial Intelligence

Quick Link

  • About
  • Contact
  • Privacy
Follow US
© 2008-25 SmartData Collective. All Rights Reserved.
Go to mobile version
Welcome Back!

Sign in to your account

Username or Email Address
Password

Lost your password?