Software // Information Management
Commentary
4/30/2007
08:04 AM
Rajan Chandras
Rajan Chandras
Commentary
Connect Directly
RSS
E-Mail
50%
50%

Data Integration Comes in Three Flavors

Those shopping for data integration solutions will find that they come in three flavors: Stand-alone tools from niche players like MetaMatrix, Group 1, Pervasive and Tableau… Focused Solutions from vendors like Business Objects, Cognos, Informatica, Initiate and SAS… and One-Stop Shops such as IBM, Microsoft and Oracle. Here's what each flavor has to offer.

Those shopping for data integration solutions will find that they come in three flavors that sometimes seem similar, but keep these distinctions in mind.

Stand-alone Tools: Niche data-integration tools from vendors such as MetaMatrix, Group 1 Software, Pervasive and Tableau enable you to provide "spot" solutions for specific problems such as pulling together data from diverse sources into a portal (MetaMatrix) mixing and matching technologies to create your own "data integration stack" (Pervasive or Group 1 together with Tableau). Enterprise and solution architects will relish the opportunity to exercise their creativity to create heterogeneous, best-of-breed solutions at reasonable cost.

Focused Solutions: Solution vendors such as Business Objects, Cognos, Informatica, Initiate Systems and SAS offer high-class capabilities in data integration as well, but usually with a specific purpose, such as business intelligence or customer data integration. If they have the integrated solution that you need, look no further - but if you pick just one component from the solution, the proposition will look less attractiveOne-Stop Shops: Large enterprises stand to benefit from emerging one-stop shops like IBM, Microsoft and Oracle (and to a lesser extent, Informatica and SAS). These large vendors have multiple capabilities that, these vendors will tell you, are "seamlessly integrated." This will be largely true, but it would be wise to dig deeper into this promise. The key is that these integrated capabilities should be flexible as well as seamless. How well are the components integrated at the metadata level, i.e. contribute, share and leverage metadata? To what extent is the integrated solution standards-driven and/or loosely-coupled? Are these mega-solutions compliant with your enterprise architecture, or do they set off in a new direction? Ironically, even as you stand to gain from integrated vendor solutions, you may risk loss of choice, potential vendor lock-in and the sheer unaffordability of large solutions.

The data integration marketplace will not continue to churn (until, that is, IBM, Microsoft and Oracle divvy and buy up all the other remaining vendors), but there is plenty of innovation out there. The entrepreneurial spirit is alive and well, and customers will continue to have plenty of options at various levels of sophistication and magnitude. These are good days for data integration vendors and customers indeed. The future of data integration, to use an aphorism, isn't what it used to be. It's better.Those shopping for data integration solutions will find that they come in three flavors: Stand-alone tools from niche players like MetaMatrix, Group 1, Pervasive and Tableau… Focused Solutions from vendors like Business Objects, Cognos, Informatica, Initiate and SAS… and One-Stop Shops such as IBM, Microsoft and Oracle. Here's what each flavor has to offer.

Comment  | 
Print  | 
More Insights
The Agile Archive
The Agile Archive
When it comes to managing data, donít look at backup and archiving systems as burdens and cost centers. A well-designed archive can enhance data protection and restores, ease search and e-discovery efforts, and save money by intelligently moving data from expensive primary storage systems.
Register for InformationWeek Newsletters
White Papers
Current Issue
InformationWeek Tech Digest - July 22, 2014
Sophisticated attacks demand real-time risk management and continuous monitoring. Here's how federal agencies are meeting that challenge.
Flash Poll
Video
Slideshows
Twitter Feed
InformationWeek Radio
Archived InformationWeek Radio
A UBM Tech Radio episode on the changing economics of Flash storage used in data tiering -- sponsored by Dell.
Live Streaming Video
Everything You've Been Told About Mobility Is Wrong
Attend this video symposium with Sean Wisdom, Global Director of Mobility Solutions, and learn about how you can harness powerful new products to mobilize your business potential.