There has to be a better way

Derek Harris

Subscribe to Derek Harris: eMailAlertsEmail Alerts
Get Derek Harris: homepageHomepage mobileMobile rssRSS facebookFacebook twitterTwitter linkedinLinkedIn

Related Topics: IT News & Views

IT News: Blog Post

Data Integration Study Compares ETL with Next Generation Technologies

Next-gen technologies address increasingly complex integration challenges, ETL best for simple batch file transfer

While ETL continues to be the predominant data integration technology in use today, the sheer size and complexity of today's information and application systems require new levels of innovation that lower costs, deliver rapid time to value, and put more control into the hands of business users.

A new study by IdealNet, a professional business expertise and technical services company, takes a look at the data integration technology curve, from the 1980s to present day, examining first, second and third generation solutions. It also compares first generation tools such as conventional ETL with newer open source and data virtualization technologies, and includes recommendations as to which technologies would be most appropriate based on an organization's data integration requirements.

The results of the study are captured in a video, titled "An Analysis of Data Integration Technologies." Some of the key findings:

· Informatica is the leading provider of ETL, clearly defines ETL for batch oriented bulk file transfer

· Talend and Pentaho are the open source leaders with associated ETL and BI strategies

· ETL is limited in scalability – each connection is essentially standalone

· Queplix 3rd generation product – leading data virtualization solution, better suited to integrate 2, 3, 4 or more sources

· Unique advanced data virtualization platform provides greater capability, lowers costs

To learn more, see

More Stories By Derek Harris

Derek Harris Sr. is a senior technology writer and blogger with more than 20 years experience in journalism.

While covering a broad spectrum of technology segments, his focus is weighted on enterprise technologies in the data storage, security and infrastructure spaces.